… the Dell PowerEdge R420 with two Intel(R) Xeon(R) CPU E5-2450 0 @ 2.10GHz, 48GB of RAM and SATA… on Launchpad lp:~vadim-tk/sysbench/insert-roll-2, command line to run: sysbench –test=insert_roll.lua –oltp-table-size=10000… = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max…
Post: High Rate insertion with MySQL and Innodb
January 7, 2011 By 17 Comments
… MySQL 5.1 and Innodb Plugin we could see 40%+ CPU wasted on mutex spinlocks (per oprofile), which went down to… your select queries dramatically. The inserts in this case of course are bulk inserts… using single value inserts you would get much lower numbers… a great performance (the competing way is to have prepared bulk insert statements). We need to try new Percona Server 5.5…
Comment: Linux schedulers in tpcc like benchmark
January 31, 2009 By 19 Comments
…. I suspect a mixed workload (alternated write intensives, reads, and cpu bound moments, not just huge sustained writes) would give controller… workloads including possibles concurrents reads and cpu work, idling moments, etc. as opposed to steady, bulk, write-only workloads (ie. importing dumps… device layout) or is it more of a “plain sequential bulk insert/update on a very few tables” thing? Seekwatcher (http://oss…
Post: How many partitions can you have ?
December 5, 2009 By 19 Comments
… 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… like updates in Innodb for CPU bound workloads can be as much as 5 times slower than inserts – which is quite a…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…hyperthreading = yes Speeds | 24×1600.000 Models | 24xIntel(R) Xeon(R) CPU X5650 @ 2.67GHz Caches | 24×12288 KB # Memory ##################################################### Total | 23…. = 0 tmp_table_size = 64M key_buffer_size = 8M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
….7 performs Hardware specification Server: Dell PowerEdge R710 CPU: 2x Intel(R) Xeon(R) CPU E5-2660 0 @ 2.20GHz Memory: 192GB… = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
Hi Peter, We are having a problem with CPU high usage, its is going up to 98%. We have … = 64M #max_connect_errors = 10000 read_rnd_buffer_size = 8M bulk_insert_buffer_size = 8M query_cache_limit = 254M query_cache_size…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… – using multiple cores becomes increasingly important as their number per CPU just keeps doubling. It is also rather interesting how is… other requirements, needs all auto-increment values in multiple value insert to be sequential. To be honest Heikki probably took a… same for all insert cases – in fact if the insert is single value insert or the number of values in the bulk is known…
Post: SELECT LOCK IN SHARE MODE and FOR UPDATE
August 6, 2006 By 51 Comments
…> begin; Query OK, 0 rows affected (0.00 sec) mysql> insert into tst values(1); Query OK, 1 row affected (0… to set row level locks which is memory and CPU overhead. For some bulk operations it would be more efficient to use… never have chance to complete. The best example would be INSERT INTO MyISAMTable SELECT * FROM INNODBTable; – A lot of shared locks…
