June 19, 2013

Post: Benchmarking Percona Server TokuDB vs InnoDB

May 7, 2013 By 32 Comments

…with TokuDB, of course I wanted to compare…PAD = random_string() BEGIN …results we have. The results are in TPS (more is better) and we start with…mysql/mysql.sock user=root skip-grant-tables TokuDB-related options are all defaults, as I understand from documentation TokuDB comes with good settings…

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

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

March 4, 2013 By 7 Comments

… and compare the result sets. Our hope is that the one of two things will happen; either the results returned…min_word_length. First, MyISAM, with MySQL 5.5, on the SEO data set: mysql: SELECT id, title, MATCH(title, …string of length less than 3 (the default), I think you’re going to be forced to set…

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

Post: Identifying the load with the help of pt-query-digest and Percona Server

December 29, 2011 By 3 Comments

… test; SET timestamp=1325145746; select count(*) from auto_inc; Compare that to Percona Server with log_slow_verbosity=…# Boolean: # Full scan 100% yes, 0% no # String: # Databases wp_blog_one (264/84%), wp_blog…by MySQL. The end result might be that you end up limiting the number of results returned…

Filed Under: Insight for DBAs, MySQL

Post: Cache Performance Comparison

August 9, 2006 By 74 Comments

…compared performance of MySQL Query Cache and File Cache. Jay uses Apache Benchmark to compare… control or other precausions like string escaping which you will need … it is almost doubled if result sets are cached from query cache. … repeat my benchmark or experiment with more caches here are source …

Filed Under: Insight for Developers Tagged With:

Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size

June 27, 2012 By 4 Comments

…with fast index creation and without it with different buffer pool sizes. Results…of long random strings update sbtest set c=concat(… and index size: mysql> show table status like “sbtest” \G …with index (but is a bit too small to keep 2 copies) In this case we’ll see the following picture: Comparing…

Filed Under: Insight for DBAs, MySQL

Post: Dynamic row format for MEMORY tables

September 6, 2011 By 5 Comments

… known as HEAP) in MySQL has been one …explicitly and how to set the data block size… has changed significantly with this patch–for the… VM Peak value is not comparable due to slightly different…strings of random length between 0 and 4096 in uniform distribution, that is, 2048 on average. The results…

Filed Under: MySQL, Percona Software

Post: Why Index could refuse to work ?

September 8, 2006 By 15 Comments

…Comparing String to Number is not going to use the index. Lets check if your guess is right: mysql… | +—-+————-+———+——+—————+———+———+——-+——+————-+ 1 row in set…with…result in wrong result for some queries. The thing is there are multiple strings…

Filed Under: Insight for DBAs Tagged With:

Post: Using CHAR keys for joins, how much is the overhead ?

June 18, 2007 By 18 Comments

…with rightful question about the difference. I did not know so I decided to benchmark. The results below are for MySQL…compared to integer based join. So how do I read these results ? CHAR keys are indeed slower for joins compared…

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