…table_namesblogpercona.commanual master_bindblogpercona.commanual master_connect_retryblogpercona.commanual master_hostblogpercona.commanual master_info_fileblogpercona.commanual master_passwordblogpercona.commanual master_portblogpercona.commanual master_retry_countblogpercona.commanual master…
Post: Resyncing table on MySQL Slave
June 29, 2008 By 10 Comments
…TABLE tbl; UNLOCK TABLES; This will dump master‘s table content to the file clean the table on master and slave…tables or an active transaction) – this is also I used DELETE instead of TRUNCATE to clean out the table…0 Deleted: 0 Skipped: 0 Warnings: 0 mysql> rename table rep_maint to rep_old, rep_new…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…master‘, ’0′ ‘Com_show_open_tables‘, ’0′ ‘Com_show_privileges’, ’0′ ‘Com_show_processlist’, ’20′ ‘Com_show_slave_hosts’, ’61′ ‘Com_show_slave…truncate‘, ’0′ ‘Com_unlock_tables‘, ’102′ ‘Com_update’, ’15146253′ ‘Com_update_multi’, ’0′ ‘Connections’, ’263413′ ‘Created_tmp_disk_tables…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 21 Comments
…master should cause the same effect as on the slave. If Innodb would not locking rows in source table…; asc 0c88dedb358cd96c9069b73a57682a;…(truncated); 1: len 4; hex …mysql tables in use 1, locked 1 2539 lock struct(s), heap size 224576 MySQL…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… has to serialize transactions on the slave which could be executed in parallel on the master. So we learned it can be… is standard “shadow table” trick – use two tables insert into one and process and truncate another. MySQL offers atomic RENAME TABLE call which can be used to swap two tables.
Post: Debugging problems with row based replication
May 6, 2010 By 10 Comments
… First, lets create a test table on a MySQL master database and populate it with some data. CREATE TABLE `t1` ( `c1` int(11) NOT… a MySQL slave. After the above setup completes, I am going to change data on the slave by truncating t1. After truncation: select count(*) from t1 as empty_table_on_the_slave; +———-+ | count(*) | +———-+ |  …
Post: Why you can't rely on a replica for disaster recovery
July 31, 2010 By 25 Comments
… boundaries. We were eventually able to coax the filesystem into truncating the data file back to a size that didn’t… way. At a higher level, MySQL replication has the same weakness. If you rely on a MySQL slave for a “backup,” you’ll be out of luck when someone accidentally runs DROP TABLE on your master. That statement…
