http://www.mysqlperformanceblog.com Everything about MySQL Performance Fri, 03 Jul 2009 02:02:00 +0000 http://backend.userland.com/rss092 en At Percona we provide services both Onsite - visiting the customers and Remote - logging in to their systems or communicating via email,phone,instant messaging. We believe both approaches have their benefits and drawbacks and mixing them right way allows you to get your problems solved most efficient way. Onsite ... http://www.mysqlperformanceblog.com/2009/07/02/onsite-and-remote-getting-best-of-both-worlds/ The Scaling with Flash webinar I've mentioned earlier was a success and we got the recording available. It contains Percona presentation, presentation of Schooner appliances and Q&A session. Enjoy. http://www.mysqlperformanceblog.com/2009/07/02/scaling-w-flash-webinar-recording-available/ For the last couple of months, we've been quietly developing a MySQL protocol parser for Maatkit. It isn't an implementation of the protocol: it's an observer of the protocol. This lets us gather queries from servers that don't have a slow query log enabled, at very high time ... http://www.mysqlperformanceblog.com/2009/07/01/gathering-queries-from-a-server-with-maatkit-and-tcpdump/ Dear community, The release 0.8 of the opensource backup tool for InnoDB and XtraDB is available for download. Key features: New mode of innobackupex --stream=tar4ibd; new command tar4ibd based on libtar-1.2.11 Experimental option --export is added (see Vadim's post "Impossible - possible, moving InnoDB tables between servers"for details) tar4ibd is made to be sure that ... http://www.mysqlperformanceblog.com/2009/07/01/xtrabackup-08/ As you see MySQL is doing great in InnoDB performance improvements, so we decided to concentrate more on additional InnoDB features, which will make difference. Beside ideas I put before http://www.mysqlperformanceblog.com/2009/03/30/my-hot-list-for-next-innodb-features/ (and one of them - moving InnoDB tables between servers are currently under development), we have few mores: - Stick some ... http://www.mysqlperformanceblog.com/2009/06/29/few-more-ideas-for-innodb-features/ With the growing adoption of Google's User Statistics Patch**, the need for supporting scripts has become clear. To that end, we've created check-unused-keys, a Perl script to provide a nicer interface than directly querying the INFORMATION_SCHEMA database. check-unused-keys can be invoked and used as follows: %> check-unused-keys --help Usage: ... http://www.mysqlperformanceblog.com/2009/06/26/check-unused-keys-a-tool-to-interact-with-index_statistics/ I have not got a chance to have a standard session on Velocity Conference this year, However I'm hosting the BOF. Bring your flash, IO Performance, and general performance stories and questions if you have any. I also plan to attend the conference afternoon on Monday and ... http://www.mysqlperformanceblog.com/2009/06/21/hosting-the-bof-at-velocity-conference/ I will co-present in webinar on Performance Challenges and Solutions for IO Bound Workloads in MySQL. My part of the presentation will be speaking about why switching from CPU bound workload to IO bound is such an important event, how to prepare to it as well ... http://www.mysqlperformanceblog.com/2009/06/19/scaling-io-bound-workloads-webinar/ Today marks the official launch of Percona.tv. We'll be uploading technical screencasts, conference video, and anything else cool we can think up. If you've got ideas or requests, let us know and we'll do our best to accommodate! http://www.mysqlperformanceblog.com/2009/06/18/announcing-perconatv/ It is a known fact that ext3 is not the most efficient file system out there and for example file removals can be painfully slow and cause a lot of random I/O. However, as it turns out, it can sometimes have a much more severe impact on the MySQL performance ... http://www.mysqlperformanceblog.com/2009/06/16/slow-drop-table/