List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:October 18 1999 9:00pm
Subject:lock problem
View as plain text  
Hi!

>>>>> "Karl" == Karl Wiechel <karl@stripped> writes:

Karl> Hello!
Karl> What does this tell you about a site using MySQL that constantly locks completely
> and won't do anything?:

Karl> lemmel:/etc/init.d# mysqladmin -p processlist
Karl> Enter password: 
Karl>
> +----+-----------+---------------------+-----------+-------------+------+----------------------+------------------------------------------------------------------------------------------------------+
Karl> | Id | User      | Host                | db        | Command     | Time | State  
>              | Info                                                                       
>                          |
Karl>
> +----+-----------+---------------------+-----------+-------------+------+----------------------+------------------------------------------------------------------------------------------------------+
Karl> | 45 | skivsmlng | bistromatik.blip.se | skivsmlng | Query       | 270  | Copying
> to tmp table | INSERT INTO topartists SELECT tabledata.clean as hmm, tabledata.artist,
> tabledata.collector FROM tab |

Everything depends on the above query.  As soon as it's ready,
everything will continue as normal.

As you didn't provide us with enough information, it's impossible to
say what's wrong.  Are you sure you don't have a full disk somewhere?

Regards,
Monty
Thread
lock problemKarl Wiechel18 Oct
  • lock problemMichael Widenius19 Oct