…_x table why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? I would… deprecated That sounds like you’re using an old version of the tool. Q: Old version of PT OSC said risk in replication environment, I didn’t see that in the new version, does…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
…:51:16 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size…: ready for connections. Version: ’5.0.95′ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution Also, I don’t see….cnf [root@tstlx1 mysql]# locate my.cnf /etc/my.cnf /etc/my.cnf.old /etc/my.cnf.rpmnew [root@tstlx1 mysql]# cat /etc…
Post: Best kept MySQLDump Secret
March 23, 2012 By 11 Comments
… the end we will get new structure in the dump but no data. Here is example: SESSION1: mysql> show tables; +——————–+ | Tables_in…_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; — Dump completed on 2012-03-23 7:27:18 SESSION1: mysql> select… as mysqldump was running we got table empty table with new structure in mysqldump instead of table with valuable data. This…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… old MySQL version and starting new one. MySQL always was very good maintaining on disk binary compatibility between version and so you can run MySQL… run comparison. The tool will run SELECT queries on both new and old MySQL installations and check result set, explain plan and execution…. Swapping master. Finally as you have your slave running on new MySQL version you want to promote it to the master and…
Post: What's the recommended MySQL version?
August 15, 2011 By 24 Comments
… executing upgrades to MySQL 5.5. So what’s the bottom line? For new applications, I’ve said use MySQL 5.5 without… running MySQL 5.0, I’d say upgrade to 5.5 directly, skipping over 5.1. MySQL 5.0 is really old now… near future. At this point, MySQL 5.1 is starting to get old, and MySQL 5.5′s new releases have just minor fixes…
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… optimizer standpoint and updating stats may cause old MySQL Version to get slower plan instead of new one getting faster. Check stats sampling… is you might not be able to get new version to pick the old plan no matter how you try and you…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… the amazing MySQL manual, especially the option and variable …show_master_statusblogpercona.commanual Com_show_new_masterblogpercona.commanual Com_show_open_…rowsblogpercona.commanual oldblogpercona.commanual old_alter_tableblogpercona.commanual old_passwordsblogpercona.commanual old_style_user_…
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
… actively developed recently are also more likely to run on old MySQL release which is understandable as upgrade requires extra QA effort… which might not be practical for old applications. For the same reasons we often see old MySQL versions not being upgraded to the… upgrade operating system as well Or is MySQL Upgrade to new version while sticking to very old operating system is important for you…
Post: Why don't our new Nagios plugins use caching?
February 19, 2012 By 1 Comment
… response to the release of our new MySQL monitoring plugins on Friday, one commenter asked why the new Nagios plugins don’t use… high-quality Cacti templates for MySQL a few years ago (which are now replaced by the new project), making the Cacti templates… that the server is fine, based on a three-minute-old file — what good is that? You should be monitoring the…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
In this post, I’ll cover the new MySQL monitoring plugins we created for Nagios, and explain their features … through the init script. Overly zealous cron jobs to delete old files in /tmp can do the same thing. If the… down for a system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of contention in…
