… Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has… incompatible with automake 1.12. Bug fixed #1099387 (Alexey Bychko). Reduced the overhead from innodb_pass_corrupt_table value checks by…
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 be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has… incompatible with automake 1.12. Bug fixed #1099387 (Alexey Bychko). Reduced the overhead from innodb_pass_corrupt_table value checks by…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
…of version 5.5.30-30.2 significantly reduces the impact of the list scan by …then a matter of copying a relatively small memory block which, depending on many factors, can be…following kinds of transactions: MySQL transactions started with START TRANSACTION READ ONLY MySQL transactions created by a …
Comment: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
April 4, 2013 By 17 Comments
… and drupal, and i converted databases from MyISAM to InnoDB, mysql tunning script gives below results for temp table , server has…_size to reduce the number of disk-based temporary tables Note! BLOB and TEXT columns are not allow in memory tables. If…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… MySQL in wild. I also wanted to share some troubleshooting techniques I use. Plot Memory Usage First I would like to see MySQL memory… you might see instead is flushing tables regularly or reducing table cache reduces memory consumption to be withing the reason. Connection Related Allocations…
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
…January I have created the outline of improvements available in MySQL 5.6 which I thought was worth sharing to give…- Fight Cache Coherence and False Sharing issues – Reduced Innodb Memory Fragmentation – Reduced Locking for Partitioned tables – Reduced Contention for LOCK_open – Support for multiple…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…_SCHEMA_MAX_THREAD_INSTANCES | 1000 | 224 | | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock | | INNODB_FILE_PER_TABLE | OFF | ON | | SYNC… 4MB instead of 1MB now allowing MySQL to handle larger queries. Makes sense as amount of memory available is much larger these… 5000. If you’re using innodb_thread_concurrency this will reduce overhead associated with grabbing and releasing innodb_thread_concurrency slot…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… Buffer Pool and have multiple MySQL Query Cache instances hashed by query hash. It would help to reduce complexity dramatically. Fast Invalidation…. Query Cache Storage Engines MySQL Query Cache now stores queries in local memory, which is great however memory amount might be limited especially…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld) S… system is already have low wait ratio increasing amount of memory for example is unlikely to help. One helpful way to… with different memory amount having same workload. You will often see increasing amount of memory not only helps you to reduce wait time…
Post: MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown
March 14, 2013 By 2 Comments
… memory). Also, I was testing, as I said before, index condition pushdown. Let’s have a look at the EXPLAIN output: mysql… improvement over MySQL 5.5. For example, in this case, the actual number of “Handler_read_next” calls was reduced from 8346769 (5.5) to just 266 (5.6), reducing the executing time by almost 5…
