… schema presents some unique challenge to the database optimizer. The SSB benchmark consists of four sets of… the database is cold, but uses less CPU time when the database is hot. I …datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… secondary keys from deferred key creation optimization. Bug fixed #1081016 (Alexey Kopytov). Percona Server for MySQL was built with YaSSL which could…overhead from innodb_pass_corrupt_table value checks by optimizing them for better CPU branch prediction. Bug fixed #1125248 (Alexey Kopytov). dialog…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…. Which is the perfect case for read-only transaction optimization in MySQL 5.6, because all SELECT queries in the AUTOCOMMIT mode…. We ran tests on Dell PowerEdge R720 box and varied cpu combinations with taskset. The following chart shows a results comparison… cause much confusion. Even though the read-only transactions optimization in MySQL 5.6 virtually eliminates contention on the mutex protecting the…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… secondary keys from deferred key creation optimization. Bug fixed #1081016 (Alexey Kopytov). Percona Server for MySQL was built with YaSSL which could…overhead from innodb_pass_corrupt_table value checks by optimizing them for better CPU branch prediction. Bug fixed #1125248 (Alexey Kopytov). dialog…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… — system files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses asynchronous IO which should allow it…) Pentium(R) D CPU 3.00GHz Caches | 2×2048 KB I have and old table which was not optimized for prolonged period of…_Ahead which is not available in MySQL 5.5 (different version is added back in MySQL 5.6) so I tried that…
Post: Guidance for MySQL Optimizer Developers
September 20, 2009 By 4 Comments
… – make optimizer pluggable and make it possible to stick to old optimizer behavior with new MySQL Version. Make Cost Model Adjustable MySQL Optimizer looks at…completely different ratio between CPU and IO cost. Focus on Execution Methods Performance problems can be due to optimizer picking the wrong…
Post: The Optimization That (Often) Isn't: Index Merge Intersection
December 14, 2012 By 6 Comments
…. To some extent, MySQL 5.0 and later changed this situation with the introduction of the “index merge” optimizer plan. The basic… a few possibilities: A new version of MySQL is released that has some new optimizer functionality that you end up missing out… rows examined” graph had dropped several orders of magnitude and CPU utilization on the machine had dropped by about 2/3…
Post: Are you designing IO bound or CPU bound application ?
December 20, 2006 By 10 Comments
… is extremely important for MySQL Performance Optimization. In fact I probably have to touch it in every second MySQL Consulting work or even more frequently. IO Bound workload is quite different from CPU bound one, which… kind of application are you designing ? Can you make it CPU bound/In memory ? If yes the whole class of the…
Post: Finding an optimal balance of I/O, CPU, and RAM for MySQL
May 16, 2011 By 4 Comments
… how MySQL scales as you add more memory to the server. Vadim recently benchmarked the effects of increasing memory and CPU core… storage — specifically, the Virident tachIOn drive — has more bandwidth than MySQL can fully utilize at present. Therefore, to decrease the price… done. You can read the full details in our Scaling MySQL With Virident Flash Drives and Multiple Instances of Percona Server…
Post: MySQL Workshops: Chicago & London this April
March 15, 2013 By Leave a Comment
… tickets to one or both MySQL workshops. Scaling and Optimization for MySQL on Monday & Tuesday, April 8 & 9 This MySQL workshop will cover: Apply… for MySQL: CPU, disks, memory, network; and how to use diagnostic tools in Linux. Investigate database trends via the counters exposed in MySQL…
