Hello mysql,
It seems like if load data infile initiated to dammaged table
sometimes after repair it does not unblock itself:
maindb:/spylog/db/tmpd # mysqladmin processlist | grep -v Sleep
+--------+----------+----------------+-----------+---------+-------+--------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State |
|Info
| |
+--------+----------+----------------+-----------+---------+-------+--------------+------------------------------------------------------------------------------------------------------+
| 30 | root | localhost | tmpd | Query | 71545 | |
|load data infile '/spylog/db/tmpd/domip.txt' ignore into table domip
| |
| 12122 | root | localhost | tmpd | Query | 67021 | Locked |
|select count(*) from domip
| |
| 58048 | titan | hydra.local | | Query | 0 | preparing |
|select id,cy,ts from misc.yandex_sites where url='auto.dp.ua'
| |
| 109643 | titan | emerald.local | | Query | 1 | Sending data |
|select
lsl.status,
lsl.source_id
fr |
| 111042 | titan | emerald.local | counter | Query | 0 | preparing |
|SELECT * from statistics.user_options where stat_id='53' and SITE_ID='153529'
| |
| 111337 | root | localhost | | Query | 0 | |
|show processlist
| |
+--------+----------+----------------+-----------+---------+-------+--------------+------------------------------------------------------------------------------------------------------+
If I'm not mistaken this problem presented couple of months ago for
select statement, may be it's the same sort of bug.
During this almost 20 hours mysql does not show any disk/CPU load
which should be if this process would go, also data file for domip
table did not change.
--
Best regards,
Peter mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
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
