Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What do the following do

Status
Not open for further replies.

likelylad

IS-IT--Management
Jul 4, 2002
388
GB
Can anyone describe what the following do in a MySQL Server

1)Delay Insert Limit=100
2)Delay Insert Timeout=300
 
probably you mean the mysql variables delayed_insert_limit/timeout

this is what mysql documentation says:
-delayed_insert_limit - After inserting delayed_insert_limit rows, the INSERT DELAYED handler will check if there are any SELECT statements pending. If so, it allows these to execute before continuing.
- delayed_insert_timeout - How long a INSERT DELAYED thread should wait for INSERT statements before terminating.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top