Geek asks and answers

MySQL client history does not log some queries

I noticed that most recently the client tool mysqldoes not register all requests that I issue. The behavior seems very inconsistent; some requests are written to the log, and others without a specific template, although it seems that the simpler the request, the more likely it is to be logged. This is annoying, to say the least. I am using MySQL 5.6.14 under Ubuntu 12.04 LTS.

Actually, it seems that there is not a lot of template: such a request as SELECT COUNT(*) FROM TABLE_X WHERE COL_1=3;can be registered, while it SELECT COL_1,COUNT(COL_1) FROM TABLE_X GROUP BY COL_1will not.

Any ideas? This is a very recent version of MySQL, and I use it only in development, but I want to deploy it on our live machines, since resolving to a microsecond timestamp solves a number of problems that I have in a much cleaner way than until now.

UPDATE: according to Alex_at_wearenotmachines below, any form template *PASSWORD*in the request disables logging, which is clearly an overly broad criterion.

+3
source share
2 answers

Just reported this on bugs.mysql.com - do you get an unexpected mysql> prompt in the middle of the command thing? And on average, about 0.75 seconds to run the create table command? seems a little slow ....

- - SELECT password FROM. . 3 , , , , , , .

+2

. . , !

, . , , , "IDENTIFIED: PASSWORD", - ( , ), : IDENTIFIED ['"]*:*PASSWORD*['" ] *

, (, ( ), ...)

(, ! http://forums.mysql.com/read.php?11,631456,631456#msg-631456), , , mysql. , . script, fix_mysql_client...

+2

More articles:


All Articles