… comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one… post is aimed at a new optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… the system. MySQL Log analyzes with Mk-Log-Parser is a very good start for a ways to generally optimize MySQL load on… lot of time optimizing PHP code but because it takes only 10% of response time in average even speeding it up 10… not the biggest part yet but if we’d speed up Sphinx and MySQL dramatically we would have to go and look…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… to check out MySQL Performance on “Memory Appliance” by Violin Memory which can be used as extremely high speed storage system. I helped Violin Memory to optimize MySQL for customer workload and Violin memory… load was mostly CPU bound. Next I went on testing MySQL. My goal was to simulate as much IO as possible…
Post: Predicting how long data load would take
May 24, 2007 By 12 Comments
… a binary form. MySQL Configuration Different storage engines have different settings which need to be set for optimal load speed. Depending on load… DATA INFILE (–tab mysqldump output). Generally LOAD DATA can be optimized better and a bit faster because of easier parsing. Mysqldump… though. During our recent data load speed we for example could see data load speed of 60GB during one hour and 10GB…
Post: How fast can you sort data with MySQL ?
August 18, 2007 By 26 Comments
… sort_buffer_size is 32K which gives us the following speed: mysql> select * from gt order by i desc limit 10; +——–+——————————————+ | i… in set (0.56 sec) Not bad ! Even though MySQL does not optimize “get top N sorted rows” very well it takes… any exception. Even spending a lot of time optimizing and otherwise working with MySQL I continue to run in results which surprise…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…, both in terms of size and spindle speed. I need to know how many physical…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql… big gains. Schema, query, and index optimization Analyzing and optimizing a server’s table and index …
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
… selectivity might show benefit from using indexes. In fact even MySQL optimizer currently does not take it into account. For In memory… in random places – this may affect index scan/range scan speed dramatically. The rows referenced by indexes also could be located… large data sets. In MySQL single query runs as single thread (with exeption of MySQL Cluster) and MySQL issues IO requests one by…
Post: How InnoDB handles REDO logging
February 3, 2011 By 18 Comments
…, your transaction will never complete. Both the MySQL configuration and hardware will affect the speed at which InnoDB can log. You can… in InnoDB uses a fixed length circular transaction log, the speed at which you can process updates is tightly linked to… background processing of dirty pages can then apply algorithms to optimize those writes during checkpoint. What else? There is of course…
Page: Presentations
May 3, 2006 By
… important MySQL Settings which should be tuned for optimal MySQL performance giving some advice of selecting prover values for them. Download MySQL Performance CookBook MySQL… how you can speed up various things in MySQL as well as solve other performance related problems. Download Innodb Performance Optimization MySQL Users Conference…
Post: Thinking about running OPTIMIZE on your Innodb Table ? Stop!
December 9, 2010 By 13 Comments
…mysql> optimize table a; +——–+———-+———-+——————————————————————-+ | Table | Op | Msg_type | Msg_text | +——–+———-+———-+——————————————————————-+ | test.a | optimize…
