EmergencyEMERGENCY? Get 24/7 Help Now!

Database Algorithms sin Pantalones

 | February 21, 2012 |  Posted In: Tokutek, TokuView

So there I was, gesticulating in front of the chalkboard, lecturing to 120 students. Topic: the beauty of advanced data structures. The door opens and the department chair walks up the aisle onto the stage and comes up to me. 242 eyes follow her progress through the room. She whispers to me that I must […]

Read More

DBD::mysql 4.014 breaks pt-table-checksum 2.0

 | February 21, 2012 |  Posted In: Insight for DBAs, MySQL, Percona Software

DBD::mysql 4.014 breaks pt-table-checksum 2.0.  The cause is unknown, but the effect is a lot of errors like: DBD::mysql::st execute failed: called with 2 bind variables when 6 are needed [for Statement “…” with ParamValues: …] at ./pt-table-checksum line 7216. The fix is simple: upgrade (or even downgrade) DBD::mysql to any version except 4.014. To […]

Read More

How to convert MySQL’s SHOW PROFILES into a real profile

 | February 20, 2012 |  Posted In: Insight for Developers, MySQL

SHOW PROFILES shows how much time MySQL spends in various phases of query execution, but it isn’t a full-featured profile. By that, I mean that it doesn’t show similar phases aggregated together, doesn’t sort them by worst-first, and doesn’t show the relative amount of time consumed. I’ll profile the “nicer_but_slower_film_list” included with the Sakila sample […]

Read More

Why don’t our new Nagios plugins use caching?

 | February 19, 2012 |  Posted In: Insight for DBAs, MySQL

In response to the release of our new MySQL monitoring plugins on Friday, one commenter asked why the new Nagios plugins don’t use caching. It’s worth answering in a post rather than a comment, because there is an important principle that needs to be understood to monitor servers correctly. But first, some history. When I […]

Read More

MariaDB 5.3.4 benchmarks

 | February 18, 2012 |  Posted In: Benchmarks, MySQL

MariaDB 5.3 has reached the release candidate milestone, and the 5.3 version promises a lot of new features and optimization (i.e in optimizer http://kb.askmonty.org/en/what-is-mariadb-53#query-optimizer). No surprise I wanted to check how all improvements affect general performance. So I why don’t we run old good sysbench benchmark.

Read More

Can we improve MySQL variable handling ?

 | February 18, 2012 |  Posted In: MySQL

MySQL Settings (also known as Server Variables) have interesting property. When you set variable in running server this change is not persisted in any way and server will be back to old value upon restart. MySQL also does not have option to re-read config file without restarting as some other software so approach to change […]

Read More