One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times. … need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the configuration that I used: ## InnoDB options innodb…” method reduces the impact of traditional InnoDB log flushing, which can cause downward spikes in performance. Other then that, I have also…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
… use sysbench fileio, 16KiB block size (to match workload from InnoDB, as this is primary usage for me), and recently I… async IO mode. There are two reasons for that. First, MySQL/InnoDB uses async writes, so this will emulate database load, and… gather metrics every 10 sec to see how stable the performance is, and it really helps to observe some artifacts, as…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… have to edit: /etc/mysql/my.cnf Also make sure that innodb_buffer_pool_size is for performance reasons set to x4 of… sure what the MySQLDB performance cracks like Baron recommend you to be on the safe / perfect side. innodb_log_file_size is…). According to my previous posts in this blog a dynamic innodb log file RECREATE did NOT seem to work if you…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
…? Is possible to detect those gap locks using SHOW ENGINE INNODB STATUS: —TRANSACTION 72C, ACTIVE 755 sec 4 lock struct(s… gaps locks in your transactions affecting the concurrency and the performance you can disable them in two different ways: 1- Change… source of information: http://dev.mysql.com/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… values by PK column and then performing the lookup, and then there are other possibilities like InnoDB doing read_ahead by noticing… a look at the status counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & read… for the best possible performance gain. This is not entirely visible in the manual either for MariaDB or MySQL, but you need…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…. MySQL Status Counters These status counters were captured when performing the benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w… MRR are performing badly. The interesting thing is that though both MariaDB and MySQL 5.6 are reporting high numbers for Innodb_rows…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… the most popular. I do not particularly like its write performance – I wrote about it before, that’s why I am… async IO mode. There are two reasons for that. First, MySQL/InnoDB uses async writes, so this will emulate database load, and… gather metrics every 10 sec to see how stable the performance is, and it really helps to observe some artifacts, as…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… MariaDB as a first-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions MariaDB in many places…, better diagnostics, improvements to partitioning, and the addition of multiple InnoDB buffer pools. Best of all, MariaDB 5.5 might be… of MySQL that suit different needs and personalities, with different characteristics, and feature and performance improvements are moving rapidly forward for the MySQL…
