lock problem

[Michael Widenius]

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