Hello,
Ord says :
> Next I tried to get a write lock on the table so that I could run the
> updates, but that made a huge mess - I could not obtain the lock.
I also have the same kind of problems while trying to RENAME a table when a
DELAYED INSERT is running.
I tried all the methods below and failed, specifically when doing FLUSH
TABLES and FLUSH TABLES WITH READ LOCK which simply prevents the DELAYED
INSERT handler to restart correctly and immediatly makes mysql reach its
maximum thread limit.
Benoît Grangé
LibertySurf Télécom
10, rue Fructidor, 75834 Paris CEDEX 17
Tel: +33 (0) 1 41 66 77 88, Fax: +33 (0) 1 41 66 77 67
> -----Original Message-----
> From: Ord Millar [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, January 21, 2001 3:30 AM
> To: MySQL List (E-mail)
> Subject: Insert delayed & locks
>
>
> I had some trouble using insert delayed - I wonder if anyone
> can shed some
> light on the problem.
>
> I have a table for logs that records are inserted into
> regularly - once
> every 10 seconds or so. I tried to update record in the
> table, but the
> update just waited forever, it seemed to be waiting untill the delayed
> thread had run.
>
> Next I tried to get a write lock on the table so that I could run the
> updates, but that made a huge mess - I could not obtain the lock.
>
> Finally, I tried to flush the tables, but then things were
> even worse - each
> insert delayed query was waiting to create an insert thread,
> the inserting
> threads weren't going aywhere, and new insert threads were
> piling up faster
> than I could kill them. I finally had to restart the server
> to get back to
> normal.
>
> So... it looks like the right way to do it is to stop the
> inserts into the
> tables (or direct them to some alternate table), kill the
> insert delayed
> thread to make it write it's data, and then work on the
> table? Or is there
> a much easier / safer way to go about this?
>
> Thanks,
> Ord Millar
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
