June 18, 2013

Post: Benchmarking Percona Server TokuDB vs InnoDB

May 7, 2013 By 32 Comments

… performs if PK is (`id`,`hid`,`mid`). This also will affect select performance…insert-roll-2, command line to run: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql… = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_…

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

Post: Virident vCache vs. FlashCache: Part 2

May 17, 2013 By 3 Comments

…. vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL configuration parameters… = 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: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

… Perl script, inserting one row at a time with AutoCommit enabled – remember, the focus here isn’t on performance just yet. Having….ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 16:09 FTS_00000000000000ad_STOPWORDS.ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 15… 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: Ultimate MySQL variable and status reference list

January 8, 2011 By 4 Comments

…MySQL manual….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

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

June 8, 2006 By 14 Comments

MySQL Server has tons of variables which may be adjusted to change behavior or for performance purposes. They are … optimize 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: High Rate insertion with MySQL and Innodb

January 7, 2011 By 17 Comments

… gains as well as room for more performance optimizations. Dmitri has good suggestions on tuning MySQL 5.5 and this is what… 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…

Filed Under: Benchmarks, MySQL Tagged With:

Post: MySQL Server Memory Usage

May 17, 2006 By 21 Comments

… understandable. If you configure MySQL Server so it uses too small amount of memory it will likey perform suboptimally. If you however… increase memory consumption for given thread, however if table will perform complex operations such as full table scans, sorts, or need… some special queries memory usage might be even larger – bulk inserts may allocate bulk_insert_buffer_size bytes of memory if done to MyISAM…

Filed Under: Insight for DBAs Tagged With: , ,

Post: Aligning IO on a hard disk RAID – the Benchmarks

June 9, 2011 By 13 Comments

… goal was to compare performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings…_size = 0 tmp_table_size = 64M key_buffer_size = 8M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max… cache enabled, single thread performance improvement is marginal however WB cache brings single thread random write performance close to what 8 threads…

Filed Under: MySQL

Post: MySQL 5.6.7-RC in tpcc-mysql benchmark

October 8, 2012 By 22 Comments

MySQL 5.6.7 RC is there, so I decided to test how it performs in tpcc-mysql workload from both performance and stability…. Benchmark date: Oct-2012 Benchmark goal: Test how MySQL 5.6.7 performs Hardware specification Server: Dell PowerEdge R710 CPU: 2x Intel… = 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

Post: How many partitions can you have ?

December 5, 2009 By 19 Comments

… large MySQL data warehouse had the table which was had data merged into it with INSERT ON DUPLICATE KEY UPDATE statements. The performance… 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: , ,
« Older Posts