up vote 0 down vote favorite
share [g+] share [fb]

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`;
link|improve this question
71% accept rate
feedback

1 Answer

up vote 3 down vote accepted

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

link|improve this answer
@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 7:18
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.