…slave_load_tmpdirblogpercona.commanual slave_net_timeoutblogpercona.commanual Slave_open_temp_tablesblogpercona.commanual Slave_received_heartbeatsblogpercona.commanual Slave_retried_transactionsblogpercona.commanual Slave_runningblogpercona.commanual slave_skip_errorsblogpercona.commanual slave…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…_File: mysql-bin.000007 …. omitted …….. Exec_Master_Log_Pos: 207 slave1 > show status like ‘%temp%’; +————————+——-+ | Variable_name | Value | +————————+——-+ | Slave_open_temp_tables | 1 | +————————+——-+ The slave is now…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…’ ‘Select_range_check’, ’0′ ‘Select_scan’, ’1104831′ ‘Slave_open_temp_tables‘, ’0′ ‘Slave_retried_transactions’, ’0′ ‘Slave_running’, ‘OFF’ ‘Slow_launch_threads’, ’0′ ‘…mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql…
Comment: Estimating Undo Space needed for LVM Snapshot
June 10, 2008 By 5 Comments
… versus when its time to look for more table storage) but it definitely allows mysql snapshots to be a lot smaller. I… flush tables w/ read lock doesn’t interfere with any queries or anything) flush tables with read lock; (it loops until slave_open_temp_tables=0) flush logs; show master status; > status.log show slave status; >> status…
