Concurrent Inserts

Support forum for the ViciBox ISO Server Install and ISO LiveCD Demo

Moderators: enjay, williamconley, Staydog, mflorell, MJCoate, mcargile, Kumba

Concurrent Inserts

Postby Acidshock » Thu Sep 25, 2014 12:40 am

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.
VERSION: 2.14-698a | BUILD: 190207-2301 | Asterisk:13.24.1-vici | Vicibox 8.1.2
Acidshock
 
Posts: 428
Joined: Wed Mar 03, 2010 3:19 pm

Re: Concurrent Inserts

Postby Kumba » Mon Sep 29, 2014 1:43 pm

Looks like I missed it when translating the older config to the new one. I'll add it to the bug patch thread.
Kumba
 
Posts: 939
Joined: Tue Oct 16, 2007 11:44 pm
Location: Florida

Re: Concurrent Inserts

Postby geoff3dmg » Tue Sep 30, 2014 3:12 am

How effective is that option btw?
Vicibox 5.03 from .iso | VERSION: 2.10-451a BUILD: 140902-0816 | Asterisk 1.8.28.2-vici | Multi-Server | Amfeltec H/W Timing Cards | No Extra Software After Installation | Dell PowerEdge 1850 | Pentium 4 'Prescott' Xenon Quad @ 3.40GHz
geoff3dmg
 
Posts: 403
Joined: Tue Jan 29, 2013 4:35 am
Location: Lancashire, UK

Re: Concurrent Inserts

Postby Kumba » Tue Sep 30, 2014 11:02 am

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
Kumba
 
Posts: 939
Joined: Tue Oct 16, 2007 11:44 pm
Location: Florida


Return to ViciBox Server Install and Demo

Who is online

Users browsing this forum: No registered users and 43 guests