… time hard to find due to their nondeterministic nature. Any tool that makes finding such bugs easier, preferably before anybody is… to the MySQL server developers. The Valgrind Memcheck tool, which is synonymous with Valgrind itself, is relatively widely used for the MySQL server… of goodies does Helgrind find on MySQL server. Let’s take a recent 5.1 bzr version (pre-5.1.61) and a single test…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… you skip over one. MySQL 5.0 to 5.1 upgrade is a lot safer upgrade path than 4.1 to 5.1 just because so much…. MySQL always was very good maintaining on disk binary compatibility between version and so you can run MySQL 5.0 database with MySQL 5.1 with… and use mk-upgrade tool to run comparison. The tool will run SELECT queries on both new and old MySQL installations and check…
Post: How Can Percona MySQL Server Development Services Help ?
January 28, 2013 By 3 Comments
… wrong version of MySQL. If you’re running MySQL 5.1 but the bug is planned to be fixed only in MySQL 5.6, this might not be good enough for you. Percona MySQL…-Percona Tools – Can we help you with non-Percona Tools, too? We have worked with a number of Open Source tools from the MySQL…
Post: Tools and Techniques for Index Design Webinar Questions Followup
October 4, 2012 By 5 Comments
…. I’d like to invite folks who are interested in tools for query optimization to attend the new Percona online virtual…: Given that the book was written in 2005, before MySQL 5.1 and 5.5 were released, is it still relevant? That book is designed… changes in MySQL 5.6 change the best practices for index design? Fundamentally, index design best practices will not change. MySQL 5.6 is…
Post: Fun with the MySQL pager command
January 21, 2013 By 6 Comments
…mysql> SELECT … 32a1894d773c9b85172969c659175d2d – 1 row in set (0.40 sec) # Rewritten query – wrong mysql> SELECT … fdb94521558684afedc8148ca724f578 – 1…tools…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
… MYSQL, upgrade MySQL, 10x start/stop MySQL, upgrade MySQL, downgrade MySQL, upgrade MySQL, install a security fix for something, 20x start/stop MySQL, upgrade MySQL, … . Restarting and changing MySQL… the other end there are Debian and Ubuntu. Both use tool called dpkg for package management. There isn’t a month…. In this particular case the problems were with MySQL packages upgraded from 5.1 to 5.5. The former were not fully uninstalled, the latter…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
… our series. In part 1 we talked about boosting performance with memcached on top of MySQL, in Part 2 we talked… is not the appropriate place for storing data. A tool like Tokyo Tyrant may not be for everyone or every… memory, memached was started with 16 threads ( 1.4 memcached ), mysql was 5.1 XtraDB. Each environment had 2 tables each with…
Post: Rebuilding MySQL with same options
April 8, 2010 By 4 Comments
… command: ./configure ‘–localstatedir=/var/db/mysql‘ ‘–without-debug’ ‘–without-readline’ ‘–without-libedit’ ‘–without-bench’ ‘–without-extra-tools‘ ‘–with-libwrap’ ‘–with-mysqlfs’ ‘–with-low-memory’ ‘–with-comment=FreeBSD port: mysql-client-5.0.67_1‘ ‘–enable-thread-safe…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…simple but powerful way to profile MySQL memory usage; the Massif tool from Valgrind. An excerpt from the…be same as what was downloaded (3.8.1 here) There are several advantages to self-compiling…_description_log_event const*) (in /usr/local/percona/mysql-5.5.28/usr/sbin/mysqld) | | ->27.73% (114,084…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 55 Comments
…% 1 72040.6 sda3 25.5 2.7 1.6 3.8 0.2 1.5 47% 1 78041.7 sda3 25.5 1.2 0.7 4.5 0.1 0…. This is one of the reasons I wrote the diskstats tool — you can understand busy-ness and utilization correctly. The %util… 1.8 3% 0 13.1 sdj1 0.7 5.1 235.2 0.0 0.0 1.7 28% 0 14.1 sdj1 0.5 0.1 5…
