June 19, 2013

Post: Ultimate MySQL variable and status reference list

last_insert_idblogpercona.commanual Last

Post: Can MySQL temporary tables be made safe for statement-based replication?

…First, I stopped the slave threads so I could choose…mysql-bin.000007 Pos: 271 Event_type: Query Server_id: 1 End_log_pos: 90 Info: insertLast_Errno: 1146 Last_Error: Error ‘Table ‘test.t’ doesn’t exist’ on query. Default database: ”. Query: ‘insert… we might have been safe using a stored procedure. …

Post: Recovery deleted ibdata1

id column Threads started! Screen1: root@localhost:/var/lib/mysql# rm ib* root@localhost:/var/lib/mysql# Now the files have gone, but MySQLthread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread