…slave can be found in this blogpost. Percona XtraBackup option xtrabackup –export now supports transportable tablespaces introduced in MySQL… of tables and slow IO then XtraBackup can spend a lot of time opening … #1170806. Percona XtraBackup would leave xbtemp temp files behind due to a typo. Bug…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… an open source solution, XtraBackup drives down backup costs while providing unique features for MySQL backup…up was standalone server (neither master nor slave in replication) and binlog information wasn’t…temp files behind due to a typo. Bug fixed #1172016. Percona XtraBackup would assume the table…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…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 21 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…
