Tuesday, December 09, 2003 2:51 PM Chris Elsworth wrote: > If you increase delayed_insert_limit then you're effectively giving > the DELAYED thread more preferencee to the table; it will write more > rows (once it can, ie there's a phase of time where there's no locks > on the table) in a batch, which potentially makes other selects wait > longer. > > Inserting delayed_queue_size means the clients can pile more and more > rows into the DELAYED thread while it gets chance to write. This may > give your clients a bit of a boost, but only if the DELAYED thread > fills up; at a default of 1000, you must be doing a lot of inserts to > reach that.
Thank you Chris, I think I understand now. >Remember if you have a lot of rows waiting and mysql > crashes, they're lost. Well, I know that, but loosing 2000 inserts when i made more than 3 000 000 a day isn't a big problem. This table is for statistics only, data isn't very important and MySQL doesn't crash as often happyily :) Now i just need to choose, I can boost the insert ratio but i'll take some risks, or i can leave all as default ... Bye David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
