…upgrading was configured on machines with running database servers. We’ve now …query which opened that table. Bug fixed #1127008 (Sergei Glushchenko). Fix for bug #1070856 introduced a regression in Percona Server for MySQL… from innodb_pass_corrupt_table value checks by optimizing them for better CPU…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…XtraBackup enables backups without blocking user queries, making it ideal for companies …’s DBD::MySQL package for server communication instead of spawning the MySQL command line… to fail. Fixed by fix checking if xtrabackup_pid file exists once… if the server isn’t running and logs were in a separate …
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… with MySQL Sandbox) can especially be helpful. Once you have spotted the query which performs differently between MySQL Server versions you should: Check Query Plan Run EXPLAIN to see if plans for the query are the same. Changing Query…
Post: Checking for a live database connection considered harmful
May 5, 2010 By 38 Comments
…’ command at the MySQL protocol level, which will increment Com_admin_commands in SHOW GLOBAL STATUS, or a trivial query such as…. When you’re running 20k queries per second against your database server, an extra 20k queries per second to check whether the connection is… query latency. Every time you want to run a query, your app framework is doing a network round-trip to the database to check…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… MySQL version and starting new one. MySQL always was very good maintaining on disk binary compatibility between version and so you can run MySQL… mk-upgrade tool to run comparison. The tool will run SELECT queries on both new and old MySQL installations and check result set, explain plan…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…and actual failure. The pmp-check-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running checks that replication is functioning correctly…. Nagios are suitable for checking that the server is alive and responds to a query. The pmp-check-mysql-status is also…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… safely run 0.7*16 ~= 12 queries per second. For some ideas about what factor may make sense for your system check out… per Query and compare it to estimated (or benchmarked) system performance to provide our estimates. If we’re running Innodb with MySQL we… get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… You will be thanked by a lot of people running MySQL in wild. I also wanted to share some …you’re using large blobs. It is easy to check though. Run “FLUSH TABLES” and see whenever memory usage … you can do better as you can query temporary tables too: mysql> select sum(data_length+index_length) …
Post: Eventual Consistency in MySQL
November 18, 2011 By 8 Comments
… we run this query and it returns a non-empty result set, it shows us which rows in Bar are orphans. mysql> INSERT… to generate quality control queries automatically, we can run them at any time: $ cat generate_foreign_key_checks.sql | mysql -N | mysql -E *************************** 1. row…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… data type related changes, so you still need to run mysql_upgrade to check if any tables need to be rebuilt for new… of upgrade, you still need to keep into account possible query changes, replication etc. Q: Is it possible to move MyISAM… over normal upgrade checks you should be fine. Q: What are the key concerns upgrading MySQL 4.1 to MySQL 5.5? This…
