June 20, 2013

Post: Introducing percona-patches for 5.1

… to say on their blog.  The main improvements come in both performance gains and improvements to…are: Performance patches for InnoDB ®. Although many patches are present in XtraDB / InnoDB-plugin, the RC status of plugin … for tpce-like benchmark, where I compare MySQL-5.1.43 vs percona-5.1.43…

Post: Top 5 Wishes for MySQL

… for you to get your own blog). I should have replied much … plugins instead of patches. 2. Be Scalable I’d like to see MySQL…should happen for most common cases. Innodb scaling issues are the most common…single MySQL server with improved performance and high availability. Of course there is MySQL

Post: MariaDB 5.3 is released as GA!

… are a little slow to blog about this and acknowledge the… member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition…MySQL 5.5 offers pluggable authentication; you just have to pay for the plugin… partitioning, and the addition of multiple InnoDB buffer pools. Best of all,…

Comment: 5.4 in-memory tpcc-like load

…This is a great way to improve performance for all MySQL users, and to get the maximum … suitable license As Vasil described in this blog post (http://blogs.innodb.com/wp/2009/03/software-is-… latest version of the InnoDB Plugin, and conduct our own testing, to ensure InnoDB‘s continued reliability. …

Post: A (prototype) lower impact slow query log

… personal blog, I blogged about the impact of the MySQL slow query log. Since we’… offset and the write operation are performed as an atomic step. So we … reused for something else.. say an innodb data file, and writing part of … an audit plugin. It turns out I had to extend the MySQL plugin API to …

Post: When should you store serialized objects in the database?

… Friendfeed posted a blog post explaining how they changed from storing data in MySQL columns to … Until 5.1-plugin simple operations like adding a secondary index on an InnoDB table require the …loss in functionality. You can no longer easily perform aggregation functions on the data (MIN, MAX, AVG…

Post: HandlerSocket on SSD

…HandlerSocket, the plugin to MySQL which open NOSQL way to access data stored in InnoDB. The published results are impressive, but I want to understand some, that’s why I run couple more experiments. In blog… more amount of IO we have to perform), and with 300 mil rows the …