How does "load data infile" work in different binlog_format?
calculate innodb_buffer_pool size
insert on duplicate
Using two SQLs to monitor MySQL data
You may know MySQL doesn't support DDL transactions.
For a subquery, the explian plan scans from the outer table first, then the inner table. If the outer table is larger than the inner table, try to use an inner join. Here is an example.
Multiple buffer pools and Multiple Background I/O Threads
We hit a timeout issue on inserts/updates on an innodb table. We can only resume INSERTS/UPDATES by restarting apache or MySQL. The inserts/updates were logged in the slow query log and time out on the value of "innodb_lock_wait_timeout=120".
error: MySQL is keeping restarted and generated a lot of error message on the InnoDB datafile.
If you use MySQL5.0, you need to upgrade to MySQL5.1 first, then upgrade to MySQL5.5.