… is the configuration that I used: ## InnoDB options innodb_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group = 4 innodb_buffer… read performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance and…
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 … MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though fixing these does help in…
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, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 12 Comments
… to check how MySQL / InnoDB performs here. For benchmark I took MySQL 5.1.42 with built-in InnoDB, InnoDB-plugin 1.0.6… ). On storage configuration: FusionIO 160GB SLC and 320GB MLC cards are configured in software RAID0 to store InnoDB datafiles. For InnoDB logs and system… can have very impressive performance improvement in IO-intensive or IO-bound workloads. You may want to use InnoDB-plugin or XtraDB…
Post: Innodb Recovery - Is large buffer pool always better ?
July 17, 2007 By 3 Comments
…Buffer Pool size affects Innodb Performance ? I always expected the effect to be positive, Innodb with large buffer pool to performing better. Including Recovery… with Innodb Buffer pool configured to be just a bit over 20GB. Innodb recovery was taking long hours with reasonably sized Innodb log …
Post: How InnoDB handles REDO logging
February 3, 2011 By 18 Comments
Xaprb (Baron) recently blogged about how InnoDB performs a checkpoint , I thought it might be useful to explain … InnoDB cannot log at all, your transaction will never complete. Both the MySQL configuration and hardware will affect the speed at which InnoDB can log. You can request that InnoDB force its REDO…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… outliers and anomalies in every aspect of the server’s configuration and performance and contents. I’m looking for characteristics that are…! (By the way, we can also help you install and configure monitoring and graphing systems, if you don’t have any… might find that there are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example. (The INFORMATION_SCHEMA…
Page: Consulting for MySQL
July 31, 2006 By
…Innodb Storage Engine Running transaction applications with MySQL ? Need help with deadlocks, understanding how Innodb locking works or having Innodb performance…MySQL ? Performing configuration and troubleshooting platform related issues ? We can help you designing optimal hardware configuration and…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…from such benchmarks there is no direct comparison available. The configuration Tom compares results to are not OpenSource and on …bit lless of performance. innodb_thread_concurrency = 0 Good! So Innodb performed best in this workload without restricting number of threads inside Innodb Kernel. Again…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… amount of RAM from 8Gig to 16Gig help the write performance of Innodb on Solaris? HT: Yes, if your ‘write working set… ideal configuration in a dedicated server is: set innodb_flush_method=O_DIRECT in my.cnf, to prevent double buffering. Configure as much memory as possible to InnoDB‘s buffer…
