… in the MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say that MySQL… was, honestly, why would you ever want to use MySQL on top of something like that? I can’t imagine the performance…/libexec/mysqld: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… MySQL AB is delivered by Marten Mickos. It is truly a year of storage engines, focused on showing what is on top… core” plans are announced for MySQL Server – the online backup in MySQL 6.0, it’s to ship in commercial version only. An Innodb Plugin is announced and will be separate from MySQL…
Post: Network at the Percona Live MySQL Conference and Expo
March 28, 2013 By Leave a Comment
… sessions and tutorials. And the keynote speakers are all top notch, MySQL technology and industry experts who will share their views of… other Tuesday night activities. Wednesday is the Community Networking Reception in the exhibit hall. Mingle with attendees over drinks and food… to network abound at the Percona Live MySQL Conference and Expo. Connect with MySQL community members in the hallways between talks. Or have…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…? Below is a chart with top mutexes for each server at 64 threads: For MySQL 5.5.30 top mutex is &doublewrite->mutex… for MySQL 5.6.11. Conclusion: In CPU-bounds case MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… MySQL scalability? The scan is performed under kernel_mutex (or trx_sys->mutex in 5.6) and that is one of the top… TRANSACTION READ ONLY MySQL transactions created by a non-locking SELECT statement in the autocommit mode. The relevant optimization in MySQL 5.6 boils… in autocommit. Which is the perfect case for read-only optimization in MySQL 5.6 and as you can see MySQL 5.6 shines in…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump right in without enough testing. Consequently, they… use writesets to replicate cluster events to the other nodes, in essence these are RBR events, plus a few additional structures… will not be able to execute events as fast, on top of that, other factors affecting async replication like if your…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… using the base HDD MySQL configuration for purposes of comparison. Given the apparent differences in time-based flushing in vCache and FlashCache, both… the system during all these various tests. Clockwise from the top left in the next graph, we have “no cache”, “FlashCache”, “vCache…-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run…
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
… vendor lock in no matter what solution you choose? Whether it is open source or not? e.g. I choose MySQL, then… be able to choose from multiple suppliers of MySQL but it’s still MySQL, even if it’s some fork like Maria… of an example but am coming up empty off the top of my head. I agree with most of your points…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… this here and here. In summary, you need to interleave the allocation of memory for the MySQL process using the numactl utility… like: pt-stalk, vmstat, top, iostat, etc all saving to disk with the current time stamp in front of each line. I… S3. Why? The push to S3 was especially puzzling since MySQL was not involved. The server was running with nearly 7GB…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… capacity somewhere between 32 and 64 threads, and synchronous write tops out somewhere between 64 and 128 threads. The latency numbers… against. For example, in the graph below we compare the performance of the P320h on a standard TPCC-MySQL test to the original FusionIO and the Intel i910 with assorted buffer pool sizes: And in this graph…
