MySQL

In MySQL master-slave replication, it is often necessary to check some important tables for consistency. Because of the delay in the synchronization of the master-slave data, the way of directly reading the server data cannot strictly guarantee the

The tables in the InnoDB storage engine are very much like the Index organization table in Oracle, each table must have a primary key, and if the table does not display a defined primary key at creation time, the primary key is automatically created

The creation of libraries, tables, and query statements in MySQL is very helpful for us to use the database in the future, this article is a summary of these basic statements, I hope it will help you 1. Create and delete databases Creating a

Source Code Compilation Installation MySQL-5.5 Need to prepare cmake-2.8.8.tar.gz and mysql-5.5.25a.tar.gz two packs into linux/usr/local/src in advance One of the important characteristics of CMake is its independent source code (OUT-OF-SOURCE)

Environment: System: CentOS Linux release 6.0. x86_64 Software: mysql.5.1.x Master IP 192.168.200.1 Slave IP 192.168.200.2 MySQL installation please refer to MySQL Single instance installation The role of MySQL master-slave synchronization (1)

Description Operating system: CentOS 6.3 32-bit Prepare the article: First, configure IP, DNS, gateways, and ensure that the remote connection tool can connect to the server Second, configure the firewall, open 80 ports, 3306 ports

Many Internet applications provide full-text search capabilities, and users can use a word or phrase as a query item to locate matching records. In the background, these programs use the LIKE statement in a select query to execute such a query,

Because the character set cannot be defined when a parameter is defined in a stored procedure, when a stored procedure is invoked, the global variable character_set_server is read by default, and the value of the global variable is read only at

There are many ways to export from SQL to MySQL, which is a simple way to import and export without programming, directly using the graphical interface in SQL and MySQL. The prerequisite is that you have installed the SQL Server client and the

#!/usr/bin/env python #coding =utf8 #author: Itnihao #mail: itnihao@qq.com #source: Http://code.taoba o.org/p/python2/src/trunk/#version: 1.0 ' function: MySQL backup. Use Mysqldump to backup the libraries in mysql 1.user,pass,host,path,del

This tutorial takes the MySQL 4.1.22 version as an example, and a newer version of the installation process is similar. Before reading, please download 4.1.22, download the address: www.mysql.com or http://www.skycn.com/soft/24418.html After

I. BACKGROUND We know that when the amount of data in the database becomes larger and bigger, the pressure will become larger, whether it is read or written. Using MySQL replication multiple master slave scheme, load balancing is done in the upper

What is the storage engine? Data in MySQL is stored in files (or memory) in a variety of different technologies. Each of these technologies uses different storage mechanisms, indexing techniques, locking levels, and ultimately provides a wide range

Modifying the default character set for MySQL is done by modifying its configuration file. Generally, there are two kinds of situations: Windows platform The MySQL configuration file under Windows is My.ini, generally in C:\windows\my.ini or

1 If you install the system from the RPM package with the situation: Modify/ETC/MY.CNF [mysqld]datadir=/var/lib/mysqlport=3300

$sql = "show create table category";$res = mysql_query($sql) or die(mysql_error());while($obj=mysql_fetch_object($res))...{　　print_r($obj);　　echo "";} Output stdClass Object ( [table] => category [CREATE TABLE] => create TABLE ' category ' ( '

My platform is: Eclipse3.2 MyEclipse5.5 Tomcat5.5 MySql5.0 First step: Create a database: It's no hard work, just use the script below to make it OK. CREATE DATABASE page; use page; CREATETABLE `product` ( `id` varchar(11) NOTNULL, `sortid`

Experimental environment VMware 6.5.2 +redhatenterprise 5 as The purpose of the experiment is to install the source package, to realize its function simply, and not to discuss the principle deeply. Kernel version: Today try to install the MySQL

When interviewing MySQL DBA or those planning to do MySQL performance optimization, my favorite question is: MySQL server in accordance with the default settings after installation, what should be done to adjust it? To my surprise, how many people

1. Modify the password of root in MySQL: Shell>mysql-u root-p Mysql>set PASSWORD for Root=password ("root"); 2. telnet to MySQL server: (of course, server must first authorize a remote user) Shell>mysql-h Host-u User-p 3. Open database: Use