… event you should not miss if you’re at all interested in MySQL. We really want you to be there — and that’s why we‘re… our Twitter feed, and retweet us when we mention this contest Tweet “My favorite #MySQL conference session” with a link to your…,” or +1 a session, just browse to the session and use the social sharing buttons on it. It is OK to…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… I do not particularly like its write performance – I wrote about it before, that’s why I am…recently I switched to use async IO mode. There are two reasons for that. First, MySQL/InnoDB uses async writes,… time we should expect, I ran random read sync IO mode, now for 1-64 threads. The throughput: We…
Post: Percona Announces New Relic Partnership
April 10, 2012 By 2 Comments
… that they should use New Relic. I even wrote it in the new edition of High Performance MySQL. Why? Simple. People who use New Relic… if that means NOT using Percona, I do that. I am, personally, very happy that we‘re doing this partnership. We don’t associate…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…problem were we trying to solve with these plugins? Why yet another set of MySQL monitoring …plugin, perhaps more than any other, should only be used judiciously. The server has been …not detected until sometime later when the problem has grown much more serious. You can use the pmp-check-mysql…
Post: Using XtraBackup on NFS for MySQL backups
December 9, 2010 By 5 Comments
… great for backing MySQL up to an NFS volume, but there is a …why you should always prepare your backups so they are completely ready to use. (You should test your backups even more than that — we… This is slower for general-purpose usage, but it should not be a big deal for xtrabackup. This and lots…
Post: Why message queues and offline processing are so important
August 10, 2010 By 3 Comments
…Optimization, you will notice that we define performance using the combination of three separate… and meeting your response time goal should always be your primary focus, …if the task is not user facing, which is why I often see … Or in plain English: The same MySQL servers can achieve much more work…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… at this point I should have identified a handful of tables that really matter. That’s why I save this part of… is virtually every query.) If it’s not possible to use a patched binary, we can use MySQL Proxy, packet sniffing, or other techniques to… the direction we‘re going, communicate to the client how much time we‘re spending, and shortcut effort if it’s not useful, e…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
…use for the statistics from which the ratio is derived (but not the ratio itself, which you should… there is a relationship. However, we can again reason that …MySQL to guide your decisions. It is also not the be-all and end-all of MySQL…, but still makes no sense, why wouldn’t you obsess over…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
…Using this application I can then compare using MySQL to using MySQL…not keep up any more this solution can really boost performance. I know you’re thinking my simple key lookup should…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… in many cases). I also should mention this feature is not that easy to use as it is implemented now… merged soon if not we should test them and make binaries with them available. With current MySQL 5.0 I… RAID10 is better than RAID5, why large stripes are better and why battery backed up cache is so …
