Insight for DBAs

Confusing MySQL Replication Error Message

I already wrote about some MySQL Error Messages which are confusing, here is one more:


080603 20:53:10 [Note] Slave: connected to master ‘’,replication resumed in log ‘master-bin.003676’ at position 444286437
080603 20:53:10 [Note] Slave: received end packet from server, apparent master shutdown:
080603 20:53:10 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘master-bin.003676’ […]

Read more

INFORMATION_SCHEMA tables in the InnoDB pluggable storage engine

Much has been written about the new InnoDB pluggable storage engine, which Innobase released at the MySQL conference last month. We’ve written posts ourselves about its fast index creation capabilities and the compressed row format, and how that affects performance. One of the nice things they added in this InnoDB release is […]

Read more

Dangerous command

Remembering that I did RENAME DATABASE in MySQL 5.1.21 and found it useful I tried it with 5.1.24 (I was playing with 20GB InnoDB database, so dumping is not fastest way) and all my tries finished with “Syntax error”.
So RTMF and documentation says
“This statement was added in MySQL 5.1.7 but was found to […]

Read more