[RESOLVED] Viewing Transactions in MySQL
I've hit a dumb day, so need your help.
I need to be able to check which transactions happened on my server.
A couple of month ago I managed to find a command which switched loging on and off. The logs were stored in mysql.general_log
Now for the life of mine I can't remember what these commands were
Find your MySQL configuration file.
Uncomment the log = /path/to/log/file row (you need to search the file for the log row).
Restart your MySQl server.
If you are not working on a Linux/Unix please let me know.
On Windows you need to restart your mysqld.exe file and add the log information. There are a bunch of arguments you can add to the mysqld.exe command for various logging:
You might also need to do:
to switch logging on at all.
There are a bunch of other logging options but I would suggest you read the MySQL Manual for the version you are using.
OK I've found the solution I've used before.
This solution IS causing great overhead on the server, I only find in comfortable because I am using it on a test server with ONLY one user.
First thing to do is to set your log output to TABLE:
Set global log_output="TABLE";
Second is to ensure that logging is ON:
set global general_log=on;
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)