…MySQL manual, especially the option and variable reference table…insert_idblogpercona.commanual interactive_timeoutblogpercona.commanual join_buffer_sizeblogpercona.commanual keep_files_on_createblogpercona.commanual Key_blocks_not_flushedblogpercona.commanual Key_blocks…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
…: mysql> insert into test2 select * from test; ERROR 2013 (HY000): Lost connection to MySQL server during query You may think will will scan the table… Innodb Table Corruption. In more complex cases you may need to use higher innodb_force_recovery modes to block purging activity, insert buffer merge…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
…fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, …and a bunch of other benefits (non-blocking ALTER TABLE, for example). The benefit is …SELECTs do is keep the insert buffer in a production steady-state. The buffered records are forced to be merged by the SELECTs…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…insert‘, ’17889656′ ‘Com_insert_select‘, ’11′ ‘Com_kill’, ’47′ ‘Com_load’, ’0′ ‘Com_load_master_data’, ’0′ ‘Com_load_master_table‘, ’0′ ‘Com_lock_tables…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…mysql tables in use 1, locked 0 MySQL thread id 8079, query id 728899 localhost root Sending data select…them. Old stale uncommitted transactions may block purge process eating up resources. By…merged and how many merges did it took. Ratio of number of merges to number of inserts is pretty much insert…
