…queries, making it ideal for companies with large data sets and mission-critical applications …features for MySQL backup. The new 2.1.1 GA version offers improved performance, enterprise-grade… Percona XtraBackup can use XtraDB changed page tracking feature to perform the Incremental Backups now. Bugs…
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… time and lose performance because of this. I am one of those people. When MySQL 5.6 spends … a background thread, buf_flush_page_cleaner_thread, should be moving all pages to the free list. Foreground … the large wall between us and them. http://bugs.mysql.com/bug.php?id=68658 http://bugs.mysql.com/…
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… time and lose performance because of this. I am one of those people. When MySQL 5.6 spends … a background thread, buf_flush_page_cleaner_thread, should be moving all pages to the free list. Foreground … the large wall between us and them. http://bugs.mysql.com/bug.php?id=68658 http://bugs.mysql.com/…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…large_files_supportblogpercona.commanual large_page_sizeblogpercona.commanual large…
Post: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 100 Comments
… implementation, especially together with LIMIT is often the cause of MySQL Performance problems. Here is what you need to know about ORDER… we stick to simple MySQL using multiple indexes on most selective columns would be good idea for performance of such queries. For… do anything else make sure you block requests with too large page numbers. For some cases, for example if results are static…
Post: Read Buffers, mmap, malloc and MySQL Performance
September 12, 2007 By 8 Comments
… – o_profile (often together with strace) are great tools for MySQL Performance analyses. Too many people end tuning on plans and indexes… they are forced to deal with very large blocks. The second possibility is to use large pages. These already can be used for Innodb Buffer Pool and Key Buffer but could be used for other large allocations…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
MySQL Server has tons of variables which may be adjusted to change behavior or for performance purposes. They are documented in the… apply to MyISAM as key_buffer itself. large_pages – Use of Large Pages for allocation of large global areas such as Innodb Buffer Pool, Key Buffer etc. It works for certain storage engines which support large pages in…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… this example I spotted the query pattern responsible for large portion of the load in the application by …at the gain system shows from performance at 1 thread to the peak performance we see the number is 2…page_get_gen,btr_cur_search_to_nth_level,btr_pcur_open_with_no_init_func,row_s earch_for_mysql…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… be used, which can be important for large, heavily written tables. Q: in trick #1 will…= 5″ and “`id` IN (5)” regarding indexes and performance? A: Recent MySQL versions are smart enough to convert id…linked list – each leaf page contains pointers to both previous and next pages in index order. Note …
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… large number of transactions in total so serializing them would make MySQL unable to keep up. Disks can do 80-150 single page… performance and you should stay on MySQL 4.1 until MySQL has taken it away from you as already happened with MySQL 4.0. MySQL 5.0 can offer substantial performance…
