… one or more sequential access. There is one another interesting thing that has come up here, and that is the importance… lookup will be needed, however if the buffer size is small as compared to the combined size of the secondary key… the best query execution plan. I had noted a similar thing when benchmarking ICP, the optimizer made a wrong choice. It…
Post: Introducing the pmp-check-mysql-status Nagios Plugin
March 29, 2012 By Leave a Comment
… not generic because I wanted to focus on doing one thing with each plugin, and doing it excellently. This makes the… for two purposes: Check whether the Uptime variable is too small, indicating the server has been restarted Check whether Threads_connected… other purposes if you want. Here are some of the things you could do: Compare a counter to a threshold Compare…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… allocated. In fact this is often one of the first things I do as it is least intrusive. Run SHOW ENGINE… common thing about memory leaks is because it is memory which is allocated and forgotten about, unless it is very small blocks… are too slow to run in production. So the best thing to do in this case is see whenever you can…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… the same page multiple times. Consider if you have a small buffer pool and a very large number of rows from…. MariaDB 5.5 is close, yet slower by ~10s. Another thing that is important to know is that, just increasing the… is slow as compared to MySQL 5.6. Next interesting thing are the last two columns of the table above and…
Comment: ext4 vs xfs on SSD
April 24, 2012 By 23 Comments
… like a File System on the basis of ONE fairly small issue is short-sighted in the extreme. Take a look… is a developer culture of common decency. That’s where things like the support of ZFS outside of Solaris comes from…
Comment: How We Got Here
April 12, 2012 By 6 Comments
… new energy on the conference floor. It comes from many things, small like having the schedule printed in color instead of just…
Post: Small things are better
October 8, 2006 By 15 Comments
… have your recovery plan this kind failures. This is one thing you better to have backups for. Backups however take time… reason to keep tables small, so you do not have to use complicated scenarios to do simple things. Assume for example you… as whole indexes will well fit in memory for such small tables. Not to mention splitting 500 tables to several servers…
Comment: Why you don't want to shard.
August 14, 2009 By 33 Comments
… challenges with backups and expecially things as alter table. http://www.mysqlperformanceblog.com/2006/10/08/small-things-are-better/ With backups – the…
Comment: Small things are better
March 25, 2008 By 15 Comments
[...] After following the scale up path (i.e. buy bigger boxes) for a while now, we definitely need to scale out as things start to become “unhandy” and simply HUGE. (See small things are better) [...]
Comment: Percona Toolkit 1.0.1 released
September 9, 2011 By 13 Comments
Loving the toolset so far. It’s already been quite helpful to me this week. Great work as usual 
A small thing, but I love that the tools are available at percona.com/get. Huge timesaver when you end up troubleshooting on foreign servers.
