Mysql slow query log issue...?

Question

Analyzing the slow query log of my mysql database server, i found an interesting query taking more time and making issues in performance of my application.Please help me to find out the issue ?

# Query_time: 481  Lock_time: 0  Rows_sent: 25571220  Rows_examined: 25571220

  SELECT /*!40001 SQL_NO_CACHE */ * FROM `closing_stock`;

score 4 · Accepted Answer · answered May 14 '11 at 12:17

4

It is a dump of the table. Are you running backups too often or something like that?

answered May 14 '11 at 12:17

JamesRyan

8,138
2
24
36

@Jayakrishnan, @JamesRyan is absolutely correct !!! +1 for Him. This is exactly what mysqldump does. – RolandoMySQLDBA May 14 '11 at 20:56
yes its correct. – Jayakrishnan T May 16 '11 at 07:18

Mysql slow query log issue...?

1 Answers1