Mysql too slow?
Hey guys, could you please look at this output and check if my msql is slow?When I send emails (100 per batch), the load increased so I typed:
mysqladmin -u root -p ext proc stat to check for long processes.
I have attached the output in a txt file
Thanks in advance
Also, this is what I am getting in top :
5285 mysql 16 0 91304 42m 1332 S 0.0 4.2 0:08.50 mysqld
5286 mysql 16 0 91304 42m 1332 S 0.0 4.2 0:00.01 mysqld
5287 mysql 16 0 91304 42m 1332 S 0.0 4.2 0:38.13 mysqld
5294 mysql 15 0 91304 42m 1332 S 0.0 4.2 1:10.29 mysqld
5313 mysql 16 0 91304 42m 1332 S 0.0 4.2 1:07.40 mysqld
5325 mysql 16 0 91304 42m 1332 S 0.0 4.2 1:08.28 mysqld
5425 mysql 16 0 91304 42m 1332 S 0.0 4.2 1:08.93 mysqld
5564 mysql 15 0 91304 42m 1332 S 0.0 4.2 1:08.97 mysqld
6091 mysql 15 0 91304 42m 1332 S 0.0 4.2 1:05.28 mysqld
7219 mysql 15 0 91304 42m 1332 S 0.0 4.2 0:57.27 mysqld
9246 mysql 15 0 91304 42m 1332 S 0.0 4.2 0:47.19 mysqld
9248 mysql 15 0 91304 42m 1332 D 0.0 4.2 0:48.82 mysqld
10393 mysql 15 0 91304 42m 1332 S 0.0 4.2 0:46.12 mysqld
13513 mysql 16 0 91304 42m 1332 S 0.0 4.2 0:45.53 mysqld
13514 mysql 16 0 91304 42m 1332 S 0.0 4.2 0:44.06 mysqld
13592 mysql 15 0 91304 42m 1332 S 0.0 4.2 0:44.09 mysqld
13599 mysql 16 0 91304 42m 1332 S 0.0 4.2 0:46.47 mysqld