June 20, 2013

Post: Percona Server for MySQL 5.5.31-30.3 now available

… quality. Percona Server has introduced innodb_read_views_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB memory usage diagnostics. Bugs Fixed: Fix for bug #1131187 introduced a regression that could cause a memory leak if query cache was used together with InnoDB. Bug…

Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency

… threads) with fast IO (OCZ R4 1.6TB) and 128GB memory. For the hot test, the data fits in the buffer… in this series. Regardless, when the working set fits in memory, InnoDB almost always performs better, at least for this workload…

Comment: Sphinx search performance optimization: attribute-based filters

… of records, for we use sphinx based on attributes, but memory consumption is exaggerated, so we applied the technique described here…

Post: Percona MySQL University @Portland next Monday!

… event will be held at Portland State University’s Smith Memorial Student Union, located at 1825 SW Broadway, Suite 327/8…

Comment: MySQL and Percona Server in LinkBench benchmark

… of java VM at the high throughput. The room of memory (10~20GB for 100 sessions?) might be needed for high…

Comment: ZFS on Linux and MySQL

… an easy move for a MySQL dba to steal 20GB memory from the Innodb buffer pool to give it to the…

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

… is brewing. Or if you watch your MySQL server’s memory usage and you see that it’s starting to swap…

Comment: ZFS on Linux and MySQL

… on ZFS and MySQL. One question, why with 192GB of memory, did you limit the ARC to 4GB? Also wondering if…

Comment: Percona XtraBackup 2.1.3 for MySQL available for download

…_size + sort_buffer_size)*max_threads = 4432877 K bytes of memory Hope that’s ok; if not, decrease some variables in…

Post: Percona MySQL University @Portland: June 17

…. It will be held at Portland State University’s Smith Memorial Student Union. We’ll finalize the schedule next week and…