…MySQL 5.5.31-30.3 on May 24, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL… memory leak if query cache was used together with…log enabled and then restarted with the binary log disabled, Crash-Resistant Replication could overwrite the relay log info log…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… binary logs are fully intact, and then the binary log filters are executed on the intermediate server, thus resulting in less binary log data… queries in the output of SHOW PROCESSLIST that might be a sign that trouble is brewing. Or if you watch your MySQL… simple query, but it’s always possible to build something more involved if that’s what you need. Q: What MySQL HA…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…the relationships between tables versus observing queries only. An additional benefit is …10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0… Identifies possible relationships between columns/tables based on names, tables without indexes, columns flagged ‘…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
….11-60.3 on June 3rd, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.6.11… #1185040. The INNODB_CHANGED_PAGES table couldn’t be queried if the log tracker wasn’t running. Bug fixed #1185304. Fixed the… Percona Server for MySQL 5.6.11-60.3 are available in our online documentation. Bugs can be reported on the launchpad…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… server can easily handle the write load of all the MySQL instances. The original idea was to configure them with raid… to better raid controller write cache use. Even the fairly slow gzip-1 mode works well. The tpcc database, which contains… together, ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact on performance with ZFS…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… dropped at this time as well. These set of queries were tested on the SSB at SCALE FACTOR: 20. This means there…/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on_metadata…
Post: Private, custom Percona MySQL Training
June 7, 2013 By Leave a Comment
…”] Alexei Rodriguez presenting at PLMCE13[/caption] During the Percona Live MySQL Community Event this year we had the pleasure of Alexei… Private Custom MySQL Training. Alexei is VP of operations there and you can watch a video of his presentation on YouTube. Alexei…
Post: Summertime Percona MySQL training update
June 6, 2013 By 1 Comment
…, give thought to MySQL training for you and your team. Summer is the time to brush up on those critical skills needed… course. Percona has a packed summer MySQL training schedule. In June we have: Moving to MySQL 5.6 – Austin, TX Begins Monday…, FL Begins Monday, August 5, 2013 , 9am – 5pm Moving to MySQL 5.6 – Minneapolis, MN Begins Thursday, August 8, 2013 , 9am…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… is the second post of a series of articles focused on MySQL 5.6 GTIDs. You can find part one here. Our… try! # For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the… master has crashed before sending all writes If the binary logs of the master are no longer readable, you will probably…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… is crashed and I have this error in my log : 07:53:55 UTC – mysqld got signal 11 ; This … may be invalid and cause the dump to abort. Query (0): is an invalid pointer Connection ID (thread ID): … /var/lib/mysql/srv-d2-mysql02.pid ended in an another environment I have three nodes on VM with percona-…
