…how to build for massive scalability, how to do read-write splitting without breaking the user experience, how to…the tail it has information on core dumps and so on. It’s …to use a patched binary, we can use MySQL Proxy, packet sniffing, or other techniques to get more information than the slow log…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…log and tell innodb to do a full write of the database (basically dump memory to…MySQL‘s binlog and InnoDB’s log must have the transactions in the same order, for a recovery based on MySQL‘s binlog to…
Post: InnoDB: look after fragmentation
November 5, 2009 By 12 Comments
…data by primary key was slow. How slow ? Let me show. The query …+—————————+ 1 row in set (2 min 8.92 sec) mysql> SHOW STATUS LIKE ‘Innodb_scan_pages%’; +——————————+——-+ | Variable_name …primary options to force dump in primary key order. So notes to highlight…
