… used: ## InnoDB options innodb_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive…” method reduces the impact of traditional InnoDB log flushing, which can cause downward spikes in performance. Other then that, I have also… read performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance and…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
…/mysql/my.cnf Also make sure that innodb_buffer_pool_size is for performance reasons set to x4 of log file size… 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: 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… 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: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
One of the very frequent cases with performance problems with MySQL is what they happen every so often …
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… periodic drops in performance which might be the result of the insert buffer filling up and then decreasing performance until some space… (innodb_ibuf_accel_rate) which might be interesting to tweak during your test. Mark Callaghan over at Facebook has seen big performance…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…Andy, I am not testing IO performance and instead trying to optimize writes, also the durability requirements … second worth of data, hence I did not test with innodb_flush_log_at_trx_commit=1. I would also not recommend running on EBS with innodb_flush_log_at_trx_commit=1, because IO times on…
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… 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: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
This benchmark doesn’t test the IO performance of EBS though as you’re not flushing to disks on each commit. What numbers do you get when you set innodb_flush_log_at_trx_commit to 1?
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition …
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… need to create locks to prevent that from happening. 2- innodb_locks_unsafe_for_binlog = 1. Disables the gap locks except…
