Arjen posted a good note about MyISAM concurrent-insert features, though I should mention concurrent-insert can be cause of scalablity and peformance problems on… 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
… had an interesting surprise with concurrent inserts into a MyISAM table. The inserts were not happening concurrently with SELECT statements; they were…you are using the binary log, concurrent inserts are converted to normal inserts for CREATE … SELECT or INSERT … SELECT statements. If you use …
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…
Post: MySQL Slow query log in the table
May 31, 2007 By Leave a Comment
… can create stored procedure, something like LAST_SLOW_QUERIES and use it instead, just remember unless you add extra indexes this… MyISAM, disable concurrent inserts and run long reporting query on the log file query execution is still proceeds. I have not checked if concurrent insert…
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… auto increment values are assigned but never used. There are probably similar problems in INSERT IGNORE and ON DUPLICATE KEY UPDATE cases…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
…_pool_size=304M innodb_log_file_size=152M innodb_thread_concurrency=8 RAM: 1GB Processor: Intel P4 2.253GHz Cache size… 1166 inserts per second into that one table. using autocommit for innodb inserts I got 1125, and 1158 inserts per second into the table using myisam I got 1186 and 1177 inserts per…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 21 Comments
… writes are done in MyISAM table. So why was this done, being pretty bad for MySQL Performance and concurrency ? The reason is… gives better concurrency. However as the name says it makes locks unsafe fore replication and point in time recovery, so use innodb…; instead of: INSERT INTO tbl2 SELECT * from tbl1; INSERT … INTO OUTFILE does not have to set extra locks. If you use this aproach…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 139 Comments
…buffer_size=9M max_connect_errors=10 thread_concurrency=4 myisam_sort_buffer_size=950M character-set-server…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…
