May 19, 2013

Virident vCache vs. FlashCache: Part 2

May 17, 2013 By 3 Comments

This is the second part in a two-part series comparing Virident’s vCache to FlashCache. The first part was focused on usability and feature comparison; in this post, we’ll look at some sysbench test results. Disclosure: The research and testing conducted for this post were sponsored by Virident. First, some background information. All tests were conducted [...]

Filed Under: Benchmarks, Hardware and Storage, MySQL Tagged With: , , , , , , ,

Benchmarking Percona Server TokuDB vs InnoDB

May 7, 2013 By 29 Comments

After compiling Percona Server with TokuDB, of course I wanted to compare InnoDB performance vs TokuDB. I have a particular workload I’m interested in testing – it is an insert-intensive workload (which is TokuDB’s strong suit) with some roll-up aggregation, which should produce updates in-place (I will use INSERT .. ON DUPLICATE KEY UPDATE statements [...]

Filed Under: Benchmarks, MySQL, Percona Server Tagged With: , , ,

Follow these basics when migrating to Percona XtraDB Cluster for MySQL

May 1, 2013 By 9 Comments

Galera/Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump right in without enough testing. Consequently, they’re more likely to either suffer failure or issues that prevent them from moving forward. If you are thinking of migrating your workload to Percona XtraDB Cluster, make sure to go through these [...]

Filed Under: Insight for DBAs, MySQL, Percona Software, XtraDB Cluster Tagged With: , , , ,

InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

This is part 2 in a 3 part series. In part 1, we took a quick look at some initial configuration of InnoDB full-text search and discovered a little bit of quirky behavior; here, we are going to run some queries and compare the result sets. Our hope is that the one of two things [...]

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

I’ve never been a very big fan of MyISAM; I would argue that in most situations, any possible advantages to using MyISAM are far outweighed by the potential disadvantages and the strengths of InnoDB. However, up until MySQL 5.6, MyISAM was the only storage engine with support for full-text search (FTS). And I’ve encountered many [...]

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

MySQL 5.5 and MySQL 5.6 default variable values differences

February 21, 2013 By 8 Comments

As the part of analyzing surprising MySQL 5.5 vs MySQL 5.6 performance results I’ve been looking at changes to default variable values. To do that I’ve loaded the values from MySQL 5.5.30 and MySQL 5.6.10 to the different tables and ran the query:

Lets go over to see what are the most important changes [...]

Filed Under: Insight for DBAs, MySQL Tagged With: , , ,

Announcing Percona XtraDB Cluster 5.5.29-23.7.2

February 13, 2013 By Leave a Comment

Percona is glad to announce the release of Percona XtraDB Cluster 5.5.29-23.7.2 on February 13th, 2013. Binaries are available from downloads area or from our software repositories. Bugs fixed: DML operations on temporary tables would try to append the key for provider library, which could cause a memory leak. Bug fixed for MyISAM temporary tables, [...]

Filed Under: MySQL, Percona Software, XtraDB Cluster Tagged With: ,

Adventures in archiving

February 11, 2013 By 16 Comments

One of our Remote DBA service clients recently had an issue with size on disk for a particular table; in short this table was some 25 million rows of application audit data with an on disk size of 345GB recorded solely for the purposes of debugging which may or may not occur. Faced with the task of [...]

Filed Under: MySQL Tagged With: , ,

Is there room for more MySQL IO Optimization?

January 3, 2013 By 11 Comments

I prefer to run MySQL with innodb_flush_method=O_DIRECT in most cases – it makes sure there is no overhead of double buffering and I can save the limited amount of file system cache I would normally have on database server for those things which need to be cached — system files, binary log, FRM files, MySQL [...]

Filed Under: Insight for DBAs, MySQL Tagged With: , ,

MySQL Upgrade Webinar Questions Followup

June 28, 2012 By 7 Comments

I did a Webinar about MySQL Upgrade – Best Practices Yesterday and there were some questions we could not answer during Webinar, following Jay’s Lead I decided to post them as a Blog Post. Q: Can you go directly MySQL 5.0 to 5.5 for MyISAM tables? MyISAM have not been getting any significant development since [...]

Filed Under: Insight for DBAs, MySQL
« Older Posts