… Mysqldump works well for this, but can quite slow on larger schemas. One of the downsides …the dirty tablespace files while streaming the redo-logs to ensure that all transactions are also captured. …sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, …
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… could cause a memory leak if query cache was used together with InnoDB. Bug…log enabled and then restarted with the binary log disabled, Crash-Resistant Replication could overwrite the relay log info log… CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… executed on the intermediate server, thus resulting in less binary log data being sent down to the lower-level slaves. You… 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
… effectively when I know the relationships between tables versus observing queries only. An additional benefit is that SchemaSpy is command-line… Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… id=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption] Percona is glad… file I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug… #1185040. The INNODB_CHANGED_PAGES table couldn’t be queried if the log tracker wasn’t running. Bug fixed #1185304. Fixed the…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
On Friday I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still register… SQL can produce an infinite variety of queries. The query optimizer analyzes queries for common patterns the MySQL designers know can be improved. But…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using… known as a “flight”. I have labeled each query as Q{FLIGHT_NUMBER}.{QUERY_NUMBER}. In general, each flight examines different time…/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb…
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 Rodriguez discussing why Evernote uses Percona’s Private Custom MySQL Training. Alexei is VP of operations there and you can…
Post: Summertime Percona MySQL training update
June 6, 2013 By 1 Comment
… course. Percona has a packed summer MySQL training schedule. In June we have: Moving to MySQL 5.6 – Austin, TX Begins Monday… Begins Monday, June 17, 2013 , 9am – 5pm Eastern Moving to MySQL 5.6 – Manchester, UK Begins Monday, June 17, 2013 , 9am…, FL Begins Monday, August 5, 2013 , 9am – 5pm Moving to MySQL 5.6 – Minneapolis, MN Begins Thursday, August 8, 2013 , 9am…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… like this in MySQL 5.5, you will succeed without errors or warnings: mysql> ALTER TABLE test ADD INDEX (col2); Query OK, 0…): mysql> ALTER TABLE test ADD INDEX (col2); Query OK, 0 rows affected (0.36 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> ALTER… on the query optimizer and the MySQL version, we always recommend to check manually the optimizations proposed by Percona Toolkit. The MySQL server…
