June 18, 2013

Post: Benchmarking Percona Server TokuDB vs InnoDB

May 7, 2013 By 32 Comments

… to compare InnoDB performance vs TokuDB. I have a particular workload I’m interested in testing – it is an insert-intensive workload… how both InnoDB and TokuDB performs if PK is (`id`,`hid`,`mid`). This also will affect select performance, so we will need… = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max…

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

Post: Virident vCache vs. FlashCache: Part 2

May 17, 2013 By 3 Comments

… – SSD config) which shows the most consistent performance. The others all have assorted performance drops scattered throughout the graph. We see the… time-based flushing enabled actually produces better and more consistent performance than vCache without time-based flushing, but even at its… = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max…

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

Post: High Rate insertion with MySQL and Innodb

January 7, 2011 By 17 Comments

… partitioning can impact performance of your select queries dramatically. The inserts in this case of course are bulk inserts… using single value inserts you would… of the ways to get a great performance (the competing way is to have prepared bulk insert statements). We need to try new…

Filed Under: Benchmarks, MySQL Tagged With:

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

February 26, 2013 By 1 Comment

… works compared to traditional MyISAM FTS. We’ll get to performance in the third installment. For now, the important number here… Perl script, inserting one row at a time with AutoCommit enabled – remember, the focus here isn’t on performance just yet. Having… one, which discusses improving bulk insert performance. At the very bottom, the page claims that you can speed up bulk loading into an InnoDB…

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

Post: MySQL Server Variables - SQL layer or Storage Engine specific.

June 8, 2006 By 14 Comments

…bulk inserts (multiple value inserts). Really helps if you have really bulk inserts 100-1000+ values per single insert statement. concurrent_insert – Enables concurrent insert…

Filed Under: Insight for DBAs Tagged With: ,

Post: How many partitions can you have ?

December 5, 2009 By 19 Comments

… was had data merged into it with INSERT ON DUPLICATE KEY UPDATE statements. The performance was extremely slow. I turned out it… UPDATE path on INSERT OF DUPLICATE KEY UPDATE (adding ON DUPLICATE KEY UPDATE set c=c+1 to my bulk inserts) the regression became even larger. 1 partition insert took 50 seconds to complete, 10…

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

Comment: Air traffic queries in MyISAM and Tokutek (TokuDB)

November 6, 2009 By 26 Comments

…. 2) Given that the indexes were built with a single bulk load, the MyISAM indexes are not fragmented. That makes the… insertions are slow and produce fragmented indexes. TokuDB can handle the worst-case insertions without fragmentation or aging. Saying that B-tree insertion performance…

Filed Under: Benchmarks, MySQL Tagged With: ,

Comment: Linux schedulers in tpcc like benchmark

January 31, 2009 By 19 Comments

…); indeed scheduling is not only about aggregating write requests and bulk performances, but also about arbitrating resources usage among consumers and making… more a waste, but in those conditions, user’s perceived performances may be more reflected by per-request time to completion… device layout) or is it more of a “plain sequential bulk insert/update on a very few tables” thing? Seekwatcher (http://oss…

Filed Under: Benchmarks Tagged With:

Comment: Thoughts on MySQL Replication

July 9, 2006 By 18 Comments

… sized bulk_insert_buffer_size performance improvement can be dramatic. Sometimes I’ve got 100 times increase (using 100.000 values per insert statement…_packet as well and keep key_buffer_size larger than bulk_insert_buffer_size otherwise performance could go down.

Filed Under: Insight for DBAs Tagged With: ,

Post: Ultimate MySQL variable and status reference list

January 8, 2011 By 4 Comments

….commanual bulk_insert_buffer_…Performance_schema_mutex_classes_lostblogpercona.commanual Performance_schema_mutex_instances_lostblogpercona.commanual Performance_schema_rwlock_classes_lostblogpercona.commanual Performance_schema_rwlock_instances_lostblogpercona.commanual Performance…

Filed Under: Insight for DBAs, MySQL
« Older Posts