… few slave instances each of production database servers and will perform the backups. The write load is not excessive so a… a copy on write filesystem, the snapshots are free, no performance penalty. You can easily run a server with hundreds of… to start the snapshot while holding a “flush tables with read lock” and the flush operation will take some time to…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… using MyISAM for everything!. MyISAM may be good for raw performance, but there are limitations which MyISAM imposes that are difficult… operations and is not ACID compliant. MyISAM and InnoDB may perform differently under concurrency, which this benchmark does not cover. I…=32 table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer_size=8M default_tmp…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on other accounts efficiently. This… to hold the log system mutex for the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed #1171699. Missing…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… instead of using InnoDB heap allocation. This may improve write performance for high levels of concurrency. Bug fixed #1185686. Under very… to hold the log system mutex for the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed #1171699. Incorrect…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… actual physical volume. So, in effect, you’re adding performance hit to performance hit. The other reason is because virtual machines tend… something you’re not that familiar with, I’d suggest reading over the manual’s description of how replication filtering rules… that I question its readiness. There have been some unfortunate performance regressions compared to 5.5, such as bug #69258, and…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… to s2. This scenario can happen when you want to perform a planned failover. With GTIDs, all the operations are straightforward… we did above. So we will suppose that we can read the binary logs of the crashed master. The first thing…-b985-0800272864ba:1. How can I instruct mysqlbinlog to start reading from there? Unfortunately, there is no –start-gtid-position option…
Comment: Percona Playback 0.6 for MySQL now available
June 10, 2013 By 1 Comment
I don’t see the reason for inventing such a tool – isn’t the overhead of reading/parsing query logs and tcp dumps very large? Doesn’t this affect the performance metrics? Why not just replay binary logs (simulating concurrent connections using script) or proxy live data to a second server.
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…implementation is considered BETA quality. Percona Server has introduced innodb_read_views_memory and innodb_descriptors_memory status variables in …2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on other accounts efficiently. …
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… test in asynchronous mode, read performance is an extremely steady 3202MiB/sec with almost no deviation. Write performance is also both very strong… that the card is quite capable of matching the asynchronous performance: Synchronous read reaches peak capacity somewhere between 32 and 64 threads…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… of MySQL performance that still stands in the way of InnoDB scalability is the trx_list scan on consistent read view creation… that a major problem for MySQL scalability? The scan is performed under kernel_mutex (or trx_sys->mutex in 5.6… alpha stage. We are going to blog about other MySQL performance improvements introduced in our latest Percona Server release, stay tuned…
