May 24, 2012

Post: Webinar: MySQL and SSD

Just as a reminder – tomorrow, May-9, 2012, at 11am PDT I will be giving a free webinar “MySQL and SSD”. This is the same talk I gave on Percona Live MySQL Conference, so if you were there – you probably will find nothing new. Otherwise, you are welcome to join!

Post: Testing Intel SSD 520

… my talk on Percona Live MySQL Conference 2012, if you did not attend my talk – you are welcome to join the webinar…

Comment: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?

… query (at least now on Percona 5.5 server) I have a complex query w. joins on a table with 10+ million…

Post: Testing STEC SSD MACH16 200GB SLC

… my talk on Percona Live MySQL Conference 2012, if you did not attend my talk – you are welcome to join the webinar…

Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal

… my talk on Percona Live MySQL Conference 2012, if you did not attend my talk – you are welcome to join the webinar…

Post: Percona Live MySQL Conference & Expo Was A Great Event

… you’ll join us next April, or at our New York or London events. Our next conference will be Percona Live New… product releases and partnerships during the conference: New Relic and Percona, SkySQL and PalominoDB, MariaDB, TokuDB, Twitter, Continuent, and Zmanda to… feel nostalgia already. Videos of the keynotes are available on percona.tv for your viewing pleasure anytime. Sheeri Cabral also recorded…

Post: MariaDB 5.3 is released as GA!

… log enabled Faster queries through speedier joins, faster subqueries, and elimination of useless tables in joins Thread pooling and a segmented key…, so there is some subtlety to this list. For example, Percona Server has the same group commit fix, and MySQL 5…: There are strong forces to ensure 5.5 GA before percona live in Santa Clare This is great news indeed. MariaDB…

Comment: Introducing new type of benchmark

… be used. Your tpcc-mysql for example doesn’t use JOINs, something we know is expensive in the MySQL world, yet Oracle and to some extent SQL Server handle better. JOIN has long been something MySQL has done badly, people have… the increasing emergence of drop-in replacements for MySQL like Percona and MariaDB which are either tweaking or flat out overhauling…

Post: Diamond Keynote Panel, BOFs, Lightning Talks, and McAfee and AOL Sponsorships

…’m excited by all of the recent developments surrounding the Percona Live MySQL Conference and Expo! Our own Baron Schwartz will… pleased to introduce two new sponsors including McAfee which recently joined as a Diamond Sponsor and AOL which recently agreed to… Scalable System”, and “How to Become a Rockstar DBA”. The Percona Live MySQL Conference and Expo promises to be a great…

Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables

Many backup tools including Percona Xtrabackup, MyLVMBackup and others use FLUSH TABLES WITH READ LOCK … WITH READ LOCK is waiting for that very nasty “full join” select to complete. What is worse as the statement started… tables anyway) you can consider using –no-lock option with Percona Xtrabackup. Many other tools have similar option. This option can…