… (more is better) threads Quadxeon with enabled concurrent-insert Quadxeon –skip-concurrent-insert Sun V40z with enabled concurrent-insert Sun V40z –skip-concurrent-insert 1 44.08 64.82 61….66 So if you are using range-queries and doing INSERT not often than disabling concurrent-insert with –skip-concurrent-insert can improve MyISAM performance. As I said…
Post: Concurrent inserts on MyISAM and the binary log
May 14, 2008 By 7 Comments
…with concurrent inserts into a MyISAM table. The inserts were not happening concurrently with SELECT statements; they were blocking and the process list was filling up with…
Post: Using MyISAM in production
June 17, 2006 By 35 Comments
… which ones. Concurrency. MyISAM uses table locks and has concurrent inserts which can go concurrently with selects. This is sometimes presented as great concurrency for inserts but in reality it means only one INSERT is…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 21 Comments
…in MyISAM table. So why was this done, being pretty bad for MySQL Performance and concurrency ?…and performance problems. You also can use this option with replication sometimes, if you really …INSERT INTO tbl2 SELECT * from tbl1; INSERT … INTO OUTFILE does not have to set extra locks. If you use…
Post: High Rate insertion with MySQL and Innodb
January 7, 2011 By 16 Comments
… with the system which needs high insertion rate for data which generally fits in memory. Last time I worked with similar system it used MyISAM and the system was built using… went down to about 15% in MySQL 5.5.8 with 8 concurrent threads. This both shows there is a substantial gains…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…concurrent…myisam_recoverblogpercona.commanual myisam_recover_optionsblogpercona.commanual myisam_recover_optionsblogpercona.commanual myisam_repair_threadsblogpercona.commanual myisam_sort_buffer_sizeblogpercona.commanual myisam_stats_methodblogpercona.commanual myisam_use…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…inserts). Really helps if you have really bulk inserts 100-1000+ values per single insert statement. concurrent_insert – Enables concurrent insert (while Selects are running) for MyISAM…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… the indexes – does it uses dynamic or static record format ? (static record format for sort used by MyISAM may cause sort files to… statement duration for Inserts with auto-increment column. This starts giving you problems if you have a lot of concurrent inserts happening to the…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
…insert with many tables. The read performance, which is the main measurement for this benchmark suffered quite as expected – with…Concurrent growth of many tables causes data fragmentation and affects table scan performance nadly – MyISAM…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 139 Comments
… It has exactly one table. MYISAM table with the following activity: Per day: 1. INSERTS: 1,000 2. UPDATES:…var/log/mysql-slow.log sql-mode=TRADITIONAL concurrent_insert=2 low_priority_updates=1 The problem was… my experience. I know some big websites are using MySQL, but we had neither the budget to…
