High load cause of da_admin searching database?

Hello,

Last few weeks a server of us is having some issues.

# Time: 090918 10:00:19
#
href="mailto:User@Host">User@Host: da_admin[da_admin] @ localhost []
#
Query_time: 520 Lock_time: 0 Rows_sent: 197796 Rows_examined:
197796
SELECT /*!40001 SQL_NO_CACHE */ * FROM `zoeklog`;

The above query is causing this problem. Can you please advise what to do?

That is a query issued by mysqldump in order to export all data, it's part of the backup procedure.

I have the same problem too with a few large MyISAM tables that become unavailable during the export.

There are three solutions: atomize the table (split it into multiple tables, advised by any database design model), change the engine from MyISAM to InnoDB (not tested but should work), launch backups when the database is less busy.