…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
… new MySQL version. Once you have the queries you will most likely able to repeat the problem by running query on old and new MySQL… 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… operation is different, you can also check SHOW PROFILE to see where differences are. Running query in the loop and getting o_profile…
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: Write contentions on the query cache
September 5, 2012 By 5 Comments
…of their top slow query according to pt-query-digest’s report. This query was run very frequently and …, I wanted to know more about how MySQL executes this query. So I used commands you’re probably…issues was the query cache as it was enabled. Contention on the query cache mutex when checking if the…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime…10 04:26:14 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci … output from the ./run_query command, called pivot_results cd shard-query/ $ ./run_query < queries.sql | tee raw |./pivot_results…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
…the General Query Log. Let’s see an example: Enable the log: general_log_file = /var/log/mysql/mysql.log …a value greater than 1: log_warnings = 2 Then check the error log: 121227 8:44:21 [Warning] …get other statistics that can be very useful if MySQL is running on a multi-tenant environment or we …
Post: Distro Packages, Pre-built Binaries or Compile Your Own MySQL
September 4, 2012 By 7 Comments
…versions across your environment, while keeping in check that each server does not break any…easy as stopping MySQL, updating symlinks or your my.cnf basedir, starting MySQL and running mysql_upgrade. Unlike … alter MySQL‘s default behavior i.e. disabling and totally disallowing use of query cache or…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… port, etc etc. Nothing unusual. Next I check what the MySQL version is, and I check (with the ‘file’ command) whether /usr/libexec… at the queries themselves. If the client has long-running queries, it can be pretty easy to catch. Maybe they’re long-running because… other things I’ll look at, including checking for default users in the mysql.* tables, running mk-duplicate-key-checker to find redundant…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…query: session10 > show profile for query 11; +——————————–+———-+ | Status | Duration | +——————————–+———-+ | starting | 0.000018 | | Waiting for query cache lock | 0.000003 | | checking query cache for query | 0.000007 | | checking…
