ansaurus

Question

mysql how to see most common queries (Lamp server, cpanel whm)

Answer 1

+3 A:

Since in your last question you seemed to be uninterested in solutions that you don't already have installed, here's a solution that uses only common POSIX commands:

grep 'Query' general-query.log |
  sed -e 's/.* Query       //'  |
  sort | uniq -c | sort -n

Depending on the size of your MySQL general query log, this might take a while to run.

Bill Karwin 2010-05-02 18:56:19

PS: there's a literal tab character after `Query` in the sed command, but it got expanded into spaces when I pasted the command.

Bill Karwin 2010-05-02 18:56:52

not good "select * from users where user = 'nikos'"and "select * from users where user = 'andreas'"for my purpose is the same querieHow do i generate the general-query.log ?

Nikos 2010-05-02 19:10:48

See http://dev.mysql.com/doc/refman/5.1/en/query-log.html for information on how to configure MySQL to output the general query log.

Bill Karwin 2010-05-02 19:41:48

Answer 2

+1 A:

Not sure about all queries, but you can log slow queries for optimization

http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html

Midhat 2010-05-02 18:57:07

I don't have any slow sql queries because the limit for mysql slow is seconds, and no query is more than a second

Nikos 2010-05-02 19:01:10

ansaurus

tags:

views:

answers:

mysql how to see most common queries (Lamp server, cpanel whm)

related questions