M
M
Mikael Grigoryan2012-08-16 17:59:29
MySQL
Mikael Grigoryan, 2012-08-16 17:59:29

Is it possible to log queries on the 1st table

Is it possible in MySQL to log select queries related only to the 1st specific table or the 1st database? The logging settings described in the documentation include global request logging.

[mysqld]
bind-address = 127.0.0.1
log = /var/log/mysqld.log
log-error = /var/log/mysqld.error.log

However, it makes no sense to enable global settings just to see queries on the 1st table.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
Sergey, 2012-08-16
@temujin

No.
Query log goes for the entire server.
But you can try to "get around" - use a combination:

SET GLOBAL LOG := 1;
-- необходимые запросы
SET GLOBAL LOG := 0;

In this case, of course, logging should be disabled by default.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question