MySQL

In the second version of High Performance Mysql, we can see the time-consuming comparison between SQL files and delimiter files during Backup and restoration.Method file size export time restore timeSQL dump 727 M 102 s 600 sDelimited dump 669 M 86

MySQL database is an open source database based on structured data. SQL statements are the core language of MySQL databases. However, when executing SQL statements in the MySQL database, you need to be careful with two traps. Trap 1: NULL values are

MySQL adds, modifies, and deletes columns. alter table: adds, modifies, and deletes TABLE columns, constraints, and other TABLE definitions. View column: desc table name;Alter table old _ name rename to new_name;Add column: alter table name add

A remote machine is required to access a mysql database. The result is [MySQL] [ODBC 5.1 Driver] Can't connect to MySQL server on '192. 168.1.101 '(192) The latest work und is as follows: (the most important step --> marked in red) How to Prevent

I. Preparations1. Install and install CentOS6 quickly.2. Install the library file required for mysql compilation. In this case, you can choose to use the CD yum.[Root @ admin share] # cd/media/[Root @ admin media] # mkdir CentOS[Root @ admin media] #

I. Summary:1. Run the following command to start MySQL in Linux:/Ect/init. d/mysql start (the installation path of mysql is earlier)2. Command for restarting mysql in linux:/Ect/init. d/mysql restart (the installation path of mysql is earlier)3. Run

# Useradd mysql-s/sbin/nologin# Wget http://downloads.mysql.com/archives/mysql-5.1/mysql-5.1.54.tar.gz# Tar zxvf mysql-5.1.54.tar.gz# Cd mysql-5.1.54#./Configure -- prefix =/usr/local/mysql-- With-mysqld-ldflags =-all-static // compile the server in

Use mysqldumpslow and mysqlsla to analyze mysql slow query logsMySQL optimization is not a permanent task, but a constant battle. Among them, the analysis of slow query logs is an important method. I used to look at it manually. However, this is not

The master-slave replication structure of MySQL is different from the master-slave replication structure. In the master-master replication structureIf the data stock on one server changes, it will be synchronized to the other server, so that the two

1) Two mysql servers A and B1. edit/etc/my. cnf for server Parameters [Server A]Server-id = 1Binlog-do-db = testBinlog-ignore-db = mysqlReplicate-do-db = testReplicate-ignore-db = mysqlMaster-host = 192.168.20.195Master-user = replMaster-password =

Mysql in the production environment is upgraded from 5.0 to 5.1 today. An error is returned in the result log, as shown below:Event schedaliz: An error occurred when initializing system tables. Disabling the Event Scheduler.Mysql. user has no 'event

I recently created a project with database garbled characters. I don't know how to set it in phpmyadmin. Let me go !! I thought it was definitely because the character set settings were inconsistent, php encoding was correct, and UTF-8 character set

  On the surface of the database table, there is an index and error prevention mechanism. However, a simple query takes a long time. Web applications may run well in the development environment, but are equally bad in the product environment. If you

Use two mysql servers to implement AB and master-slave replication. 1. Configure the MASTER server MASTER 172.16.1.3BACKUP 172.16.1.2 1. Edit the my. cnf File# Add the two rows on the original basis [Root @ zhaoyun ~] # Cat/etc/my.

An unibilling machine suddenly experienced heavy loads a few days ago. it is found that cpu usage is high in top. the agi program runs slowly and a zombie process occurs. in fact, there were only about 50 concurrent calls at that time. far below

The master-Slave synchronization of mysql fails. the following error is reported in the log: 120309 18:39:23 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000004 'at position 2207467, relay log '. /mysqld-relay-bin.00001

Installing MySQL sudo apt-get install mysql-server should be simple, and I don't think there is much problem with installation, so I will not talk about it much. Let's talk about the configuration below. Configure MySQL. Note that in Ubuntu, MySQL

The solution Can't connect to MySQL server on 'localhost' (10048), which is generally seen in the use of mysql windows 2003 server. The cause of the error:Applications need to be quickly released and create new connections, but the connections in

Error Code 1045 Access denied for user 'root' @ 'localhost' (using password: YES) the solution is to reset the root user password. The procedure for Windows is as follows: 1. log on to the system as a system administrator. 2. If the MySQL server is

When installing mysql in windows xp, a problem with mysql-5.1.45-win32.msi occurs: the cocould not start the service mysql error: 0 prompts an error. After research and try, the reinstallation was successful! The procedure is as follows:1.