Building Rock Solid Websites

.

Blogs

MySQL processes

On a current job I am getting localhost mysql to import a database that is 280MB in size. It has so far been running over 24 hours, through the import field o f phpmyadmin. Had I known it was going to take this long I would have taken to the command line to do it ...however...now it is still apparently ticking over, and I would like to find out just how far through the process it is, and whether it is still running or just refusing to provide phpmyadmin with the notification.

So how to do that?
Open the terminal, and do :

mysql -uroot -p

SHOW FULL PROCESSLIST\G

then look at what processes are running against the database in question.
SHOW FULL PROCESSLIST\G

and see if it changed the current work; if so then your job is still in fact running.

An application you could use to do the same thing, only without the constant need to re-do the command is mytop : http://jeremy.zawodny.com/mysql/mytop/
Debian has this in it's repos; apt-get install mytop
mytop -uroot -p