SMF Support > Server Performance and Configuration

Something like mtop, but showing whole sql sentences in action?

(1/2) > >>

luuuciano:
Hi!

I am trying to catch a mod slowness under certain circumstances... tried using mtop, and it is cool... but just shows active sql sentences in 1 line, so if the sentences is longer it just not show it full...

Any idea how can I get those full sql sentences?

luuuciano:
I have found this
http://forge.mysql.com/tools/tool.php?id=38

butch2k:
You can always activate MySQL General Log to catch all queries going on if you have full control of your mysql server.

luuuciano:

--- Quote from: butch2k on March 05, 2012, 04:17:57 AM ---You can always activate MySQL General Log to catch all queries going on if you have full control of your mysql server.

--- End quote ---

Well, I think I did it, but nothing is being logged... maybe something is wrong...
I have added
log-bin=/var/log
log=/var/log
log-error=/var/log
log-slow-queries=/var/log
to the my.cnf file...
But maybe I need to add something on the starter script at /etc/rc.d/mysqld too?

Anyway, I have no idea what happens... mysqld just eats 100% cpu 95% of the pages loaded.... (I am trying pmxsubforums mod on a clean smf installation, but using the db information of another website running)

butch2k:
 :o :o :o :o
Definitely wrong indeed !!!!
The log-bin is not a log per se but used for replication purposes, you should put the options back to standard value asap !

The two values on interest for you are those related to general-query-log:
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_general_log

Keep in mind that in an active server it might consume a bit of ressources, so best to use it only for debugging purposes

Navigation

[0] Message Index

[#] Next page