…*************************** Master_Log_File: mysql-bin.000006 Read_Master_Log_Pos: 98 Relay_Log_File: mysql_sandbox20551-relay-bin.000028 Relay_Log_Pos: 235 Relay_Master_Log_File: mysql-… statements went into the binlog individually, there’s clearly an opportunity to break replication here. It looks …
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…mysql -e ‘select * from flexviews.binlog_consumer_status\G’ -uroot *************************** 1. row *************************** server_id: 999 master_log_file: binary_log.000001 master_log_size: 214652 exec_master_log… be clear in a moment. Lets create a table, insert some rows, add a change log, …
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…in MySQL 5.0 MySQL generally supports legacy storage format for a while, even if it is not clearly …sniff out queries if you can’t enable log for any reason). As you’ve gotten …master. Finally as you have your slave running on new MySQL version you want to promote it to the master and upgrade Master…
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
… I was cloning the master using LVM Snapshot and found it was taking quite a…of MySQL Logs. Too bad MySQL Binary log is the only one which it does not support natively. Happily it supports “raw” query log …-v -i -P “^(SET|use|#)” > q1.log I’m not sure if this would clear everything but in my case it …
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
…MySQL 5.1 this is done by the master InnoDB thread. Since then, InnoDB has been moving towards the parallelized purge: in MySQL…buffer_pool_size=16G innodb_log_file_size=1900M innodb_flush_log_at_trx_commit=2… the other way: Here it becomes very clear that there are no significant differences caused…
Post: Beware the Innodb Table Monitor
November 29, 2011 By 2 Comments
…contents of the Data dictionary to the mysql error log, which looks something like this: =========================================== …during off hours to connect to their master and collect the output so we …effects from running the monitor, but something clearly was a lot busier than expected during…
Post: Confusing MySQL Replication Error Message
June 4, 2008 By 10 Comments
…log ‘master-bin.003676′ position 444292333 080603 20:53:10 [Note] Slave: connected to master ‘repl@host.com:3306′,replication resumed in log ‘master…server-id. Seriously in this case Master clearly sees the problem in this case…reason for this error message which MySQL already does in many other cases…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
… hopes to clear confusions with the problem Im getting w/ our servers: Here is a snippet from our error.log: ************ 080625 23… 12410321, relay log ‘/var/log/mysql/relay.000086′ position: 4837623 080625 23:53:28 [Note] Slave I/O thread: connected to master ‘repl@10… 12501137, relay log ‘/var/log/mysql/relay.000088′ position: 85644 080626 0:06:20 [Note] Slave I/O thread: connected to master ‘repl@10…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… your data is coming from some Apache log or similar source. Write a …MySQL 5.0 and earlier, doing the work on a slave, then piping the results back up to the master…clearly better for some workloads out-of-the-box than MySQL is, especially for more complex queries. Percona is not tied to MySQL…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…s practically nothing else running (this is a dedicated master server). The machine has a lot of swap, but…cnf –pid-file=/var/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql 3172 3137 78 Nov19 ? 1-11:17… explain the meaning of the output, so it’s clear what I’m showing them. Then, I go …
