Hi! On Jan 20, rmck wrote: > 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?
No, it did not hang - "Repair with keycache" is slow, especially for 23G file. You should configure MySQL so that it'll use "Repair by sorting". See the manual for details. > 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] > Regards, Sergei -- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
