Concurrent Inserts For MyISAM

0
Your rating: None

MyISAM storage engine supports concurrent inserts. If there are multiple INSERT statements, they are queued and performed in sequence, concurrently with the SELECT statements.

The concurrent_insert system variable can be set to modify the concurrent-insert processing. This variable is set to 1 by default. To disable concurrent insert just set concurrent_insert variable to 0. If the variable is set to 2, concurrent inserts at the end of the table are allowed even for tables that have deleted rows. See also the description of the concurrent_insert system variable.

Post new comment

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
Image CAPTCHA
Copy the characters (respecting upper/lower case) from the image.

Cumulus Tag Cloud

Kiran Says

SEO Architect,SEO Specialist reflect my values.

By enduring black hat methods the SEO industry is setting itself up for washout and sleepwalking into oblivion.

Jobs in India