> > So, i'm using INSERT DELAYED with some good succes. > > > > But I've got a question. > > If i decrease delayed_insert_limit to ten secondes for example, is that mean > > that delayed_queue will be flushed every ten secondes ? > > Is there an other variable that specify the flush time ? > > No - delayed_insert_limit refers to how many rows a DELAYED thread > will insert at once before checking if any other SELECTs are waiting > for the table. The process (and all related variables you can tweak) > are documented here: > > http://www.mysql.com/doc/en/INSERT_DELAYED.html > Thanks Chris,
I've read mysql doc sereval times, but i can't find any varaible that specify when the delayed queue was flushed. If I understand, I can increase delayed_insert_limit for better performance, but I should also increase the delayed_queue as well ? David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
