Select * on database

[cviper40]

Greetings.

I'm noted on mysql slow log, the following:

# Query_time: 1552.967353 Lock_time: 0.000086 Rows_sent: 383996307 Rows_examined: 383996307 Rows_affected: 0 Rows_read: 383996307
# Bytes_sent: 11252070774 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0
# InnoDB_trx_id: 41DEA35
use zabbix;
SET timestamp=1319756172;
SELECT /*!40001 SQL_NO_CACHE */ /*!50084 SQL_NO_FCACHE */ * FROM `history`;


The same query (select * from XXX) repeat from histoy_uint, trends, trends_uint, history_log.

Anybody knows if this querys corresponds with housekeeper process ?

[Alexei]

I am pretty sure such queries does not come from Zabbix software.

[cviper40]

Thanks a lot.
Anybody know how to trace this query ?

How can I know the origin of this query ?

Thanks a lot.

[walterheck]

I think you need to turn that question around: what kind of software do you have that is aware of zabbix? It couldn't be too much I hope? Do you have any patches against zabbix frontend or server binaries?

Also, it's not waterproof, but you could try checking the show processlist of your mysql server to see if anything out of the ordinary shows up. I'd hope that whatever this is doesn't use zabbix server creds? Another (much more nasty) way to go is to change the password for zabbix server mysql user and only change the credentials in your zabbix_serverd.conf.

Happy hunting