… MySQL has traditionally been challenging. Most data can be obtained from the slow or general log, but this involves a lot of data you don’t need too, and isn’t flexible at all. The specific problem of logging failed… is needed as the plugin needs the offset to some MySQL data structures that, the plugin authors say, aren’t exposed by…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… each event. Notice that this is the same problem for s0 (which will be late when it …# For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then … Does it mean that we cannot easily recover the data with mysqlbinlog? There is a solution of course, …
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… on the intermediate server, thus resulting in less binary log data being sent down to the lower-level slaves. You can… of other MySQL and OS-level status variables that you might want to keep an eye on to prevent a problem before… SQL nodes in a MySQL Cluster installation are going to be talking to the same set of data nodes on the back…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
… check if data on replicas is in sync with data on the master pt-stalk, to gather data when performance problems happen randomly or… on “5 Percona Toolkit Tools for MySQL That Could Save Your Day”Percona Toolkit for MySQL is a must-have set of… to a replica and fix the problem without rebuilding the tables How to gather data for performance problems that happen randomly and last…
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
… be logged in to the server at the time the problem happened. As I began reviewing available captures, I was able… on that. Granted, this means there is no run time data available, but at least you get a nice ranking of… the problem go away. The server took the next round of peak traffic time without issues. If you regularly work with MySQL…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… from the old master, which can cause all kinds of data corruption. MySQL provides the handy RESET SLAVE command. But as we… huge problems (it’s anyway no longer supported from MySQL 5.5). If you want to know more details, please read on! MySQL… set master-xxx variables in my.cnf! From MySQL 5.5 Starting with MySQL 5.5, the situation has slightly changed. First…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… read_view_open_now() which is another problem originally reported as upstream bug #49169. This …was used with –innodb-optimize-keys and –no-data options, all secondary key definitions would be …(Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help …
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
… that transaction 5 is the one that is causing the problems. Since SQL_SLAVE_SKIP_COUNTER doesn’t work with GTID… data inconsistencies between Master and Slave servers. pt-table-checksum can help you here, which is found in Percona Toolkit for MySQL. Last week I gave a talk at Percona MySQL University @Toronto about GTID. It includes…
Post: Webinar: MySQL 5.6 Performance Schema
May 13, 2013 By 5 Comments
…, I’ll be leading a Webinar titled, “Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload …Other areas of focus include: Bottlenecks with Disk IO Problems with excessive temporary tables and external sorts Excessive…due to waits on InnoDB locks and Meta Data locks Interested ? Sign up …
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… its state before updating. This caused some problems for some users, especially if automatic upgrading… used with –innodb-optimize-keys and –no-data options, all secondary key definitions would be …(Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help…
