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

Select *, if (sva = 1, "male", "female") as ssva from taname where sva <> "" 12.2. Control Flow FunctionsCASE value WHEN [compare-value] THEN result [WHEN [compare-value] THEN result...] [ELSE result] end case when [condition] THEN result [WHEN

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

MySQL database performance optimization solutionThe actual operating scheme for database performance optimization. With the continuous development of MySQL database, the performance optimization of MySQL database has become more and more important.

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

Mysql aotu_increment is often used in master-slave relationships. MySQL does not have a specific sequence of oracle. In addition, the previous project used select max (*) to implement this function. Later, compared to the max (*) method, it was

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

Case:Id name Course name score1 Zhang San math 692 Li Si math 893 Zhang San, mathematics 69Delete redundant student information that is identical except for automatic numbers Bytes ---------------------------------------------------------------------

  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