June 20, 2013

Post: ZFS on Linux and MySQL

May 24, 2013 By 17 Comments

…idea was to configure them with raid-10 + LVM, making sure to stripe the… more zealous.  Pretty interesting to speed up point in time recovery when you dataset…cheap.  In fact the best tpcc results I got were when using compression. …use.  Even the fairly slow gzip-1 mode works well.  The tpcc database…

Filed Under: Hardware and Storage, Insight for DBAs, MySQL Tagged With: , , , ,

Post: Virident vCache vs. FlashCache: Part 2

May 17, 2013 By 3 Comments

…better or more consistent results, or results that are more inline with the numbers put up by vCache, but…size = 128M innodb_flush_log_at_trx_commit = 1 innodb_log_file_size = 1G innodb_log_…5000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache = 10240 max_allowed_packet = 16M…

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

Post: Benchmarking Percona Server TokuDB vs InnoDB

May 7, 2013 By 32 Comments

… sbtest$I_r100, sbtest$I_r1000, with roll-up sum for 10, 100, 1000 records in the main table. and…good for InnoDB. So let’s see what results we have. The results are in TPS (more is better) and…_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock …

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

Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer

March 29, 2013 By 10 Comments

…a link to the full documentation for setting up the plugin: http://dev.mysql.com/doc/… = $totalTimeStore / 100000; $timer->start(); for ($i = 0; $i < 10; $i++) { for ($i = 0; $i < 100000; $i++) { $obj =...  Here are the raw results from this test run (100,000 store operations, 1,000,000 fetch operations…

Filed Under: MySQL Tagged With: , , , ,

Comment: Is MySQL 5.6 slower than MySQL 5.5?

March 27, 2013 By 23 Comments

…/Linux) using VBoxHeadless.exe with 1 core # cat /proc/cpuinfo processor : 0 …sse2 syscall nx lm constant_tsc up rep_good nopl pni monitor ssse3 … 48 bits virtual I get this as result: transactions: 148503 (495.00 per sec.) …-performance-schema with standard mysql-5.6.10-debian6.0-x86_64.deb package …

Filed Under: MySQL Tagged With: , , ,

Post: MySQL 5.5.8 - in search of stability

January 3, 2011 By 11 Comments

… localhost tpcc500w root “” 500 32 10 1800. For better understanding the results for each run, I will show…, by disabling the doublewrite area, we improved the result 1.55x times. As it seems hard for InnoDB…60? This is a bummer. Throughput again jumps up and down. The dirty pages percentage is not …

Filed Under: Benchmarks, MySQL Tagged With: ,

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

February 26, 2013 By 1 Comment

… and the strengths of InnoDB. However, up until MySQL 5.6, MyISAM was …. The second part will compare query results between MyISAM FTS and InnoDB FTS …_end_time | | | stopword_table_name | | | use_stopword | 1 | | table_state | 0 | +—————————+———+ 10 rows in set (0.02 sec)…

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

Post: Death match! EBS versus SSD price, performance, and QoS

February 21, 2011 By 55 Comments

…busy in_prg 1.0 {10} 1.4 0.7 118.1 0.3 0.0 9.7 3% 0 2.0 {10} 4…. and device to device — and causing horrible database pile-ups. We’re comparing apples and oranges no matter what, … customers running databases in various cloud services with great results. In particular, it can be made to work really …

Filed Under: Cloud and NoSQL, Hardware and Storage, MySQL

Post: Percona Server scalability on multi-cores server

September 29, 2010 By 14 Comments

… 5.1.49-12.0, we are going to provide regular builds dedicated to the Cisco UCS platform) The full results are… that half of them are not real CPU cores. For up to 10 threads, the scale factor is quite impressive: it is… calculate the scale factor as the result with 10 threads divided by the result with 1 thread.) Above 10 threads, the rate of increase is…

Filed Under: Benchmarks, MySQL

Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1

January 8, 2007 By 117 Comments

…. CREATE TABLE IF NOT EXISTS `$tableName` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(64) …up run (duration 180 sec), and then run three effective runs (duration of each is 60 sec). As the final result… by 2-26 times and than Falcon by 1.64 – 3.85 times. READ_PK_RANGE_INDEX Query…

Filed Under: Benchmarks Tagged With: ,
« Older Posts