… from a single connection. # Thread_id: 4 MICROTIME RESOLUTION QUERY TIMING This is …Lock_time: 0.000048 Rows_sent: 56 Rows_examined: 1113 LOGGING OF THE REPLICATED STATEMENTS Normally MySQL… Merge_passes: 0 # No InnoDB statistics available for this query SELECT COUNT(1) FROM t2; Important note: …
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
Post: Recovery deleted ibdata1
August 10, 2012 By 9 Comments
…mysql# And restart MySQL: root@localhost:/var/lib/mysql# /etc/init.d/mysql restart After the restart all InnoDB tables are reachable: mysql> select count(*) from sbtest; +———-+ | count(*) | +———-+ | 1000000 | +———-+ 1…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
… no needs to lock or shutdown server. …InnoDB: import: extended import of testexport/order_line is started. InnoDB: import: 2 indexes are detected. InnoDB: Progress in %: 1 2 3 4…quick check mysql> select count(*) from order_line; +———-+ | count(*) | +———-+ | 32093604 | +———-+ 1 row …
