Help.....
I have a REPAIR table command that has been running since 1/15... I dont know if its
hung or what? Should I kill it ? Top shows that it seems to be running?
mysql> show processlist;
+----+------+-----------+---------+---------+--------+----------------------+-----------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info
|
+----+------+-----------+---------+---------+--------+----------------------+-----------------------------------------------+
| 10 | root | localhost | ip_logs | Query | 391630 | Repair with keycache | REPAIR
TABLE Jan04 QUICK
+----+------+-----------+---------+---------+--------+----------------------+-----------------------------------------------
# ls -alh Jan04.*
-rw-rw---- 1 mysql mysql 8.6K Dec 29 08:19 /curipdb/ip_logs/Jan04.frm
-rw-rw---- 1 mysql mysql 23G Jan 15 16:25 /curipdb/ip_logs/Jan04.MYD
-rw-rw---- 1 mysql mysql 22G Jan 20 06:30 /curipdb/ip_logs/Jan04.MYI
#
top sorted by CPU:
06:32:07 up 5 days, 14:31, 4 users, load average: 1.46, 1.49, 1.39
102 processes: 101 sleeping, 1 running, 0 zombie, 0 stopped
CPU0 states: 0.2% user 0.1% system 0.0% nice 0.0% iowait 99.2% idle
CPU1 states: 12.0% user 0.4% system 0.0% nice 0.0% iowait 87.0% idle
Mem: 3874188k av, 3863468k used, 10720k free, 0k shrd, 33544k buff
2618824k actv, 563052k in_d, 89848k in_c
Swap: 4289328k av, 527664k used, 3761664k free 3197660k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
5285 mysql 5 -10 501M 497M 452 S < 12.5 13.1 1580m 0 mysqld
17002 root 16 0 1108 1108 820 S 0.3 0.0 0:13 0 top
728 root 16 0 236 4 0 S 0.1 0.0 1:37 0 sshd
Thanks
Rob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
