…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_…innodb_status_fileblogpercona…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… for mistakes: mysql> show master status \G *************************** 1. row *************************** File: db04-bin.000068 Position: 98 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0…: 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…
Comment: Using LVM for MySQL Backup and Replication Setup
August 15, 2008 By 53 Comments
… READ LOCK; > SHOW MASTER STATUS; > \! ls -lart mysql-bin*|tail -n1 > UNLOCK TABLES; > MYSQL File Position Binlog_Do_DB Binlog_Ignore_DB mysql-bin.000156 956920476… READ LOCK; > SHOW MASTER STATUS; > \! ls -lart mysql-bin*|tail -n1 > UNLOCK TABLES; > MYSQL File Position Binlog_Do_DB Binlog_Ignore_DB mysql-bin.000156 957115478…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…. Let’s look at the binary logs: master > show master status; +——————+———-+————–+——————+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +——————+———-+————–+——————+ | mysql-bin.000007 | 474…
Comment: No more MySQL Crash Safe Replication in 5.0 ?
August 10, 2010 By 7 Comments
…: Last MySQL binlog file position 0 98, file name ./mysql-bin.000002 —round 2— show master status; +——————+———-+————–+——————+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +——————+———-+————–+——————+ | mysql-bin…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
… of 1a mysql> show master status; +————+———-+——————————————-+——————+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +————+———-+——————————————-+——————+ | bin.000030 | 9462 | db1,db2…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
February 8, 2012 By 94 Comments
… empty set and the master status differs: *************************** 1. row *************************** File: mysql-bin.000050 Position: 106 Binlog_Do_DB: Binlog_Ignore_DB: And again, the function “set…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…/db…status | 162626 | +———————————–+———————-+ +———————————–+———————-+ | Variable_name | Value | +———————————–+———————-+ | Aborted_clients | 6 | | Aborted_connects | 0 | | Binlog…doing this …
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…The question really is how do you determine the memory…Binlog_cache_disk_use’, ’145′ ‘Binlog_cache_use’, ’9638599′ ‘Bytes_received’, ’2671219831′ ‘Bytes_sent’, ’2416986544′ ‘Com_admin_commands’, ’76′ ‘Com_alter_db…hosts’, ’61′ ‘Com_show_slave_status‘, ’13834′ ‘Com_show_status‘, ’194766′ ‘Com_show_…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…31014 + 27426 = 58440 os file descriptors. So – 1) Do I get errno: 24 becuase I have …400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp_table_…status_file = 1 innodb_file_per_table = 1 innodb_data_home_dir = /db2/innodb innodb_log_group_home_dir = /db…
