June 20, 2013

Post: Percona Server for MySQL 5.5.31-30.3 now available

May 24, 2013 By Leave a Comment

… 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…

Filed Under: MySQL, Percona Server, Percona Software Tagged With:

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

May 22, 2013 By Leave a Comment

… 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…

Filed Under: Benchmarks, MySQL Tagged With: , , , , , , ,

Comment: Sphinx search performance optimization: attribute-based filters

June 12, 2013 By 11 Comments

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

Filed Under: Insight for Developers, MySQL Tagged With: , ,

Post: Percona MySQL University @Portland next Monday!

June 12, 2013 By Leave a Comment

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

Filed Under: Events and Announcements, MySQL, Percona MySQL Consulting, Percona MySQL Support, Percona MySQL Training, Percona MySQL University, Percona Remote DBA Tagged With: ,

Comment: MySQL and Percona Server in LinkBench benchmark

June 9, 2013 By 18 Comments

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

Filed Under: Benchmarks, MySQL, Percona Server Tagged With: , , , ,

Comment: ZFS on Linux and MySQL

June 7, 2013 By 17 Comments

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

Filed Under: Hardware and Storage, Insight for DBAs, MySQL Tagged With: , , , ,

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

June 7, 2013 By Leave a Comment

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

Filed Under: Insight for DBAs, Insight for Developers, MySQL, MySQL Webinars Tagged With: , , ,

Comment: ZFS on Linux and MySQL

May 31, 2013 By 17 Comments

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

Filed Under: Hardware and Storage, Insight for DBAs, MySQL Tagged With: , , , ,

Comment: Percona XtraBackup 2.1.3 for MySQL available for download

May 30, 2013 By 3 Comments

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

Filed Under: MySQL, Percona Software, Percona XtraBackup Tagged With:

Post: Percona MySQL University @Portland: June 17

May 22, 2013 By 1 Comment

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

Filed Under: MySQL, Percona MySQL University Tagged With: , ,
« Older Posts