… amazing MySQL manual, especially the option and …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…
Post: Fun with the MySQL pager command
January 21, 2013 By 6 Comments
… $6}’ | sort | uniq -c | sort -r’ mysql> show processlist; 309 Sleep 3 2 Query 2 Binlog Dump 1 Command Astute readers will… ORDER BY TOTAL DESC; +————-+——-+ | COMMAND | TOTAL | +————-+——-+ | Sleep | 344 | | Query | 5 | | Binlog Dump | 2 | +————-+——-+ True, but: It’s nice to know several…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… to MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL …: table id 17 flags: STMT_END_F BINLOG ‘ L5cLURMBAAAALwAAAAUDAAAAABEAAAAAAAEABHRlc3QABHRlc3QAAwMD/gL+CQY= L5cLURgBAAAAOAAAAD0DAAAAABEAAAAAAAEAA///+AIAAAAAAAAAA2JhcvgCAAAAAAAAAANob3A= ‘/*!*/; ### UPDATE test.test ### WHERE…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
… are not too many audit capabilities in MySQL Community so the first option to audit MySQL‘s authentication process is to get… an example: Enable the log: general_log_file = /var/log/mysql/mysql.log general_log = 1 User correctly authenticated: 121227 8:31…: 96 CPU_TIME: 19 BYTES_RECEIVED: 62869617 BYTES_SENT: 14520 BINLOG_BYTES_WRITTEN: 0 ROWS_FETCHED: 783051 ROWS_UPDATED: 1017714 TABLE…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
One common theme in the questions our MySQL Support customers ask is MySQL Replication Lag. The story is typically along the lines… performance in general). Typical problems for replication include setting sync_binlog=1, enabling log_slave_updates, setting innodb_flush_log_at… as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the most…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… to provide our estimates. If we’re running Innodb with MySQL we can use Innodb_data_reads , Innodb_data_writes, Innodb… ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld) S…: 775 CPU_TIME: 49 BYTES_RECEIVED: 21847267 BYTES_SENT: 336986112 BINLOG_BYTES_WRITTEN: 0 ROWS_FETCHED: 485139 ROWS_UPDATED: 0 TABLE…
Post: Implementing Parallel Replication in MySQL
November 8, 2010 By 3 Comments
… in the MySQL server. We have a brief outline of the ideas at this wiki blueprint. So far, the “binlog order” idea…
Post: Beware: ext3 and sync-binlog do not play well together
January 21, 2009 By 19 Comments
… of our customers reported strange problem with MySQL having extremely poor performance when sync-binlog=1 is enabled, even though the system… – we get 2350 transactions/sec with sync_binlog=1 and 2550 transactions/sec with sync-binlog=0 which is about 10% overhead… MySQL side – may be opening binlog with O_DSYNC flag if sync_binlog=1 instead of using fsync will help ? Or may be binlog…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +——————+———-+————–+——————+ | mysql-bin.000007 | 474 | | | +——————+———-+————–+——————+ master > show binlog events in ‘mysql-bin.000007′\G *************************** 1…
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
… you, you can use the new –verify-binlog-checksum option of mysqlbinlog: # mysqlbinlog –verify-binlog-checksum mysql_sandbox18676-relay-bin.000002 [...] ERROR: Error… read from binlog did not pass crc check; the first event ‘mysql-bin.000001′ at 2793, the last event read from ‘./mysql-bin…
