… InnoDB memory usage diagnostics. Bugs Fixed: Fix for bug #1131187 introduced a regression that could cause a memory leak if query cache was used… #1171941. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine. In… the working set fits in memory, InnoDB almost always performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For the InnoDB tests, a 64GB buffer pool was used. O…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… trouble is brewing. Or if you watch your MySQL server’s memory usage and you see that it’s starting…reaction was, honestly, why would you ever want to use MySQL on top of something like that? I can’t…-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap just…
Comment: ZFS on Linux and MySQL
June 7, 2013 By 17 Comments
… likely not hitting a bottleneck caused by compression. If I use SSD for L2ARC, I’ll need to do the same… is not an easy move for a MySQL dba to steal 20GB memory from the Innodb buffer pool to give it to the…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can …cases. This significantly improves InnoDB scalability on read-only workloads, especially when the default glibc memory allocator is used. Bug fixed #1131187 (…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…repositories. Benchmark showing the impact of memory allocators on MySQL performance can be found in this…fixed #1080539 (Teemu Ollakka). Standard MySQL port would be used when port number wasn’t … Yurchenko). If variable innodb_thread_concurrency has been defined to throttle InnoDB access, and work …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… (innodb_flush_log_at_trx_commit != 1), or work around it with by fsyncing to memory (… needs to be modified. Generally if you use Innodb, you should be able to handle deadlock … of us are used to the tradeoffs we take when deploying conventional stand-alone MySQL Innodb with asynchronous slaves….
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… his critique of MySQL Management. Monty is working on the Maria storage engine to replace Innodb for a number of use cases. The first “open core” plans are announced for MySQL Server – the online backup in MySQL 6… Percona Live MySQL Conference and Expo in Santa Clara, Calif., April 22-25. Share a memory you have from past MySQL user conferences…
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
…another issue in InnoDB transaction processing that notably affects MySQL performance – for every transaction InnoDB creates a read view and allocates memory for … notable MySQL performance drop. Now in Percona Server, for each connection we use a preallocated read view structure, reuse that memory …
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can …cases. This significantly improves InnoDB scalability on read-only workloads, especially when the default glibc memory allocator is used. Bug fixed #1131187 (…
