… for all three …binlog_cache_sizeblogpercona.commanual Binlog_cache_useblogpercona.commanual binlog_direct_non_transactional_updatesblogpercona.commanual binlog_do_dbblogpercona.commanual binlog_formatblogpercona.commanual binlog_ignore_dbblogpercona.commanual binlog…alter_db_upgradeblogpercona…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… Binlog_Do_DB | Binlog_Ignore_DB | +——————+———-+————–+——————+ | mysql-bin.000007 | 474 | | | +——————+———-+————–+——————+ master > show binlog …. However, since all the statements went into the binlog individually, there’s…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
… tables using SQL). On the Master you can do filtering using binlog-do-db and binlog-ignore-db commands. This is there a lot of people… the data. There is replicate-do-db and replicate-ignore-db options which closely mirror behavior of their binlog-do-* counterparts and which are as…. This works in much larger amount of cases, but not all of them. For example stored procedures are handled (because binary…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
… | Binlog_Do_DB | Binlog_Ignore_DB | +————+———-+——————————————-+——————+ | bin.000030 | 9462 | db1,db2,db3,db1,db2,db3 | | +————+———-+——————————————-+——————+ 1 row in set (0.00 sec) *** All db…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… \G *************************** 1. row *************************** File: db04-bin.000068 Position: 98 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.00 sec) If you’re…: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table… running close, quite often being at same master position at all. Even if replication gets a bit behind in most cases…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… | | Binlog_cache_use | 9630066 | 468 | | Bytes_received | 38563413074 | 1708212 | | Bytes_sent | 216162991863 | 7796961 | | Com_admin_commands | 255868807 | 11893 | | Com_alter_db | 0… more scalable.” And the client said “that’s all? Didn’t you do any work? Peter’s report 6 months ago was…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…’ ‘Com_delete’, ’348788′ ‘Com_delete_multi’, ’1′ ‘Com_do‘, ’0′ ‘Com_drop_db‘, ’0′ ‘Com_drop_function’, ’0′ ‘Com_drop_index’, ’0…_all‘, ’0′ ‘Com_rollback’, ’4666272′ ‘Com_savepoint’, ’0′ ‘Com_select’, ’378247551′ ‘Com_set_option’, ’285487367′ ‘Com_show_binlog_events’, ’0′ ‘Com_show_binlogs…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…all for your info. Question: After kicking … 27426 = 58440 os file descriptors. So – 1) Do I get errno: 24 becuase … datadir = /db/mydata tmpdir = /db-logs/ibdlogs/dbtmp pid-file = /db/mysql.pid log-error = /db/…cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…all for your info. Question: After kicking … 27426 = 58440 os file descriptors. So – 1) Do I get errno: 24 becuase … datadir = /db/mydata tmpdir = /db-logs/ibdlogs/dbtmp pid-file = /db/mysql.pid log-error = /db/…cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… does not do anything else… | Id | User | Host | db…user | | NULL | Connect | 0 | Has read all relay log;… sec) 4) Slave Catchup/Binlog Application method….
