…” align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption]…_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug fixed #1185040…. Reduced the overhead from the Handle Corrupted Tables check as it was missing branch predictor annotations. …
Post: Percona Live MySQL Conference 2013 wrap-up
April 29, 2013 By Leave a Comment
… we were very pleased with the event and the feedback (check the #perconalive hashtag for a sampling of the great comments… Despite the buzz, MySQL is still much more common than even the most popular NoSQL database when viewing indicators such as inclusion in LinkedIn bios Oracle MySQL may diminish in importance within the…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… (about 23GB). So it makes sense to check if the dataset size makes any difference…. To warmup server and load data and indices to the buffer pool we use following …0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… long-running transactions, or other problems. The pmp-check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, such as… MySQL‘s PID file exists. Evidence of contention in the processlist. The pmp-check-mysql-processlist plugin checks SHOW FULL PROCESSLIST for patterns that indicate…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
… growing overtime, indicating a possible memory bug. Whatever the reason, there is a simple but powerful way to profile MySQL memory usage… program is using, it also gives very detailed information that indicates which parts of your program are responsible for allocating the… file etc. After mysqld is properly started (check if you can login with your mysql client), you would execute whatever steps you…
Post: Introducing the pmp-check-mysql-status Nagios Plugin
March 29, 2012 By 2 Comments
… you can use for fairly arbitrary checks of status counters and variables. This is the pmp-check-mysql-status plugin, which can perform computations on status variables. By default, I recommend using it only for two purposes: Check whether the Uptime variable is too small, indicating the server has been restarted Check whether Threads_connected is…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… bottleneck. Also check out my old article on the topic which goes into a lot more details. Q: how mysql use index… that you can use and index for “order by desc” indicates a double linked list. Innodb has double linked list – each… more expensive. Everyone, Thank you for attending and your questions! Check out more MySQL Webinars from Percona!
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… because they’re in Locked status, which might be an indication that it’s time to convert MyISAM tables to InnoDB… of other things I’ll look at, including checking for default users in the mysql.* tables, running mk-duplicate-key-checker to…
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 30 Comments
… indication of trouble. Not only it means you may run out of MySQL connections quicker than you expected but it also frequently indicates… the process and you can use your favorite tools to check what that process is doing. [root@w1 ~]# netstat -ntp | grep… process are not only helpful to debug sleeping connections with MySQL but many other cases when you see web application locking…
Post: Learning about MySQL Table Fragmentation
May 1, 2008 By 20 Comments
… drive sequential read rate or you would see MySQL becoming CPU bound if IO subsystem is too fast… 6 15K SAS hard drives in RAID10. Another indication of bad fragmentation was average IO size seen …poor or miss configured IO subsystem I do another check by running cat /dev/sdb1 > /dev/null – Physical …
