… Percona warmly invite you to Percona Performance Conference 2009 on April 22 and 23, 2009 in the Hyatt Regency in Santa Clara… sessions from Percona this year on the schedule for the 2009 MySQL Conference and Expo. This is not because we didn…’t only care that your database is fast — you care that your application is fast as a whole. That’s why we…
Post: Announcing Percona Performance Conference 2009 on April 22 & 23
February 5, 2009 By 5 Comments
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 12 Comments
… I followed Yoshinori Matsunobu’s recommendations http://yoshinorimatsunobu.blogspot.com/2009/05/tables-on-ssd-redobinlogsystem.html and taking fact that…
Post: State of the art: Galera - synchronous replication for InnoDB
October 27, 2009 By 13 Comments
First time I heard about Galera on Percona Performance Conference 2009, Seppo Jaakola was presenting “Galera: Multi-Master Synchronous MySQL Replication… data. Although it also has serious drawback – our cluster is fast as fast the “weakest” node in the chain. So if one… and exploit the latest developments in computer science to produce fast and scalable synchronous replication solution that “just works” for databases…
Post: InnoDB: look after fragmentation
November 5, 2009 By 12 Comments
… username) FROM tracker where TIME_ID >= ‘2009-07-20 00:00:00′ AND TIME_ID = ‘2009-07-20 00:00:00′ AND… it (tough it is possible in XtraDB / InnoDB-plugin with FAST INDEX creation) so be careful with queries scan many records…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
… and Baron played with InfoBright (see http://www.mysqlperformanceblog.com/2009/09/29/quick-comparison-of-myisam-infobright-and-monetdb/) this… really have data for InfoBright and MonetDB, let see how fast they are in different queries. First favorite query for any…, 2.12s 10y, 79.77s, 29.14s UPDATE (5-Oct-2009): James Birchall recommended to use hint COMMENT ‘lookup’ for fields…
Comment: Drop table performance
April 21, 2011 By 22 Comments
… parallel into the same file. This this big showstopper for fast storages, and if you do not use innodb_file_per… issues with ext3 and sync_binlog http://www.mysqlperformanceblog.com/2009/01/21/beware-ext3-and-sync-binlog-do-not-play…
Comment: Drop table performance
April 20, 2011 By 22 Comments
… parallel into the same file. This this big showstopper for fast storages, and if you do not use innodb_file_per… performance issues with ext3 and sync_binloghttp://www.mysqlperformanceblog.com/2009/01/21/beware-ext3-and-sync-binlog-do-not-play…
Comment: MySQL 5.5.8 - in search of stability
January 5, 2011 By 11 Comments
….fr/blog/archives/2009/09/mysql-performance-io-optimization-innodb.html) – in this case you don’t mix its fast seq.writes…
Comment: MySQL 5.5.8 and Percona Server: being adaptive
December 22, 2010 By 25 Comments
….mysqlperformanceblog.com/2010/04/08/fast-ssd-or-more-memory/ and there http://www.mysqlperformanceblog.com/2009/05/01/raid-vs-ssd…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…. For example a test (http://mysqlha.blogspot.com/2009/03/pbxt-is-fast-no-kidding.html) by Mark Callaghan shows that PBXT…
