Concurrent Inserts

[Acidshock]

Just noticed that in the Vicibox 6.0 the concurrent_inserts option was left out of the MySQL config. Was this done on purpose? I noticed all the versions before had this option.

[Kumba]

Looks like I missed it when translating the older config to the new one. I'll add it to the bug patch thread.

[geoff3dmg]

How effective is that option btw?

[Kumba]

It's pretty effective at letting MyISAM do inserts while table scans are going on. It allows rows to be inserted while a select is running against the table in a non-locking fashion until the select gets to the section of the table where the inserts are happening. Then the inserts are blocked until the select finished. It helps lower the load noticeably due to the log tables not blocking too many queries.

It's not a huge difference in performance but it is noticeable on the database.

You can add it by pasting the following command after logging in as root:

sed -i 's/table_cache=8192/table_cache=8192\nconcurrent_insert=2/' /etc/my.cnf