… rows. Table Structure The table structure of the table with no secondary indexes is as follows: CREATE TABLE `purchases_noindex` ( `transactionid… interesting part. Results With the table purchases_noindex, that has no secondary indexes, I was able to achieve an avg. insert… using secondary indexes. While secondary indexes cause read performance to improve, but they have an impact on the write performance. Well…
Comment: MySQL on Amazon RDS part 1: insert performance
April 25, 2012 By 37 Comments
I see no improvement from RDS with innodb_flush_log_at_trx_commit set to 2 or 0. My benchmarks have the same results, regardless of the setting. Does RDS fools the flush in some way or has the setting disabled somehow?
Post: Introducing Zend DBi as a MySQL Replacement on IBM i
May 8, 2012 By Leave a Comment
… on Zend DBi just as it works on MySQL, with no need to rewrite applications, management scripts, or anything else. There is no difference in query syntax, client-server protocol, or data storage… variant of the MySQL server. We have a history of improving the MySQL server and finding and solving bugs in it…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
… Percona type version of MySQL – ie one of Percona’s “improved” versions of MySQL (that is what Percona does, isn’t…, and I find my qps dropping by 2/3 – with no changes to what is happening on the server. Any ideas…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 9 Comments
… no difference in query times between MySQL 5.5 and MySQL 5.6/MariaDB 5.5 This is another area of improvement… a wrong choice. It looks like that there is still improvement and changes needed in the optimizer’s cost estimation algorithm… the index tuples fit in the buffer. But there is no performance improvement when the workload is in-memory, in fact MRR…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… this optimization the idea of MRR is further extended to improve join performance. As I told you above, when table t1…_read. We can see that with appropriately sized buffers less no. of Innodb_buffer_pool_reads are done, and less amount… much of a difference in the query times. Conclusion BKA improves the query time by a huge margin for IO bound…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… on the surface becomes challenge with MySQL because there are no clear resource usage metrics available, and so in most cases… amount of resources prepared statements take on server. There is no comparable variables of how many user variables are allocated (and… very hopeful future releases of MySQL, MariaDB or Drizzle bring improvements in this space allowing us to see directly for what…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… configuration because it uses a threshold for which there is no good one-size-fits-all value. This plugin, perhaps more… that can be performed with existing plugins, so there was no need to write new ones. For example, the plugins that…. Please download and try out the plugins, and help us improve them. If you are a customer and you need help…
Comment: InnoDB's gap locks
April 4, 2012 By 14 Comments
… COMMITTED InnoDB doesn’t take additional locks on the gap, improving the concurrence. You would avoid all “Lock wait timeout exceeded…; session2> commit; session1> select * from t; +——+ | i | +——+ | 21 | | 26 | | 30 | +——+ No locks on the gap, so no wait timeout and more concurrence.
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 …
