… 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…: 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… next year. MySQL releases are split between the MySQL Community, and MySQL Enterprise is released with different versions on different schedules. MySQL 5.0… available for MySQL. Facebook mentions they have over 1,800 MySQL Servers. MySQL Enterprise provides Monthly Rapid Updates [MRU] while Community MySQL versions updated…
Post: Network at the Percona Live MySQL Conference and Expo
March 28, 2013 By Leave a Comment
… the speaker lineup for the Percona Live MySQL Conference and Expo. We have outstanding MySQL experts speaking on a variety of topics… sessions and tutorials. And the keynote speakers are all top notch, MySQL technology and industry experts who will share their views of…, opportunities to network abound at the Percona Live MySQL Conference and Expo. Connect with MySQL community members in the hallways between talks…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
Galera/Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump … will not be able to execute events as fast, on top of that, other factors affecting async replication like if your…
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: trx0sys.c:196. And most likely this symptom is related to BUG#67808. For MySQL 5.6.11 top mutexes is &buf_pool->mutex,&new_index->lock…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
…->mutex in 5.6) and that is one of the top reasons for contention on that mutex. Percona Server as of… to the following kinds of transactions: MySQL transactions started with START TRANSACTION READ ONLY MySQL transactions created by a non-locking SELECT… perfect case for read-only optimization in MySQL 5.6 and as you can see MySQL 5.6 shines in this benchmark…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… the system during all these various tests. Clockwise from the top left in the next graph, we have “no cache”, “FlashCache…-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration A) appears below: #####fixed…
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
… or not? e.g. I choose MySQL, then I go write my app to use MySQL. Later I may want to move… be able to choose from multiple suppliers of MySQL but it’s still MySQL, even if it’s some fork like Maria DB (???) that’s still basically MySQL. You have the constraints of that platform and if you… 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
…, you need to interleave the allocation of memory for the MySQL process using the numactl utility, drop the file cache and…, I started of data gathering metrics like: pt-stalk, vmstat, top, iostat, etc all saving to disk with the current time… 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… latency just over 3ms. How well does it perform with MySQL? Exact results vary, depending upon the usual factors (read/write… compare the performance of the P320h on a standard TPCC-MySQL test to the original FusionIO and the Intel i910 with…
