[RESOLVED] Viewing Transactions in MySQL

[Nightcat]

OK

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

HELP!!!!!!

[zimonyi]

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.

Archie

[Nightcat]

I'm working on Windows.

[zimonyi]

Ok.

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:

--log[=file_name]
--log-error[=file_name]

You might also need to do:

--general-log=1

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.

Archie

[Nightcat]

OK I've found the solution I've used before.

NOTICE:

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";

http://dev.mysql.com/doc/refman/5.1/...var_log_output


Second is to ensure that logging is ON:

set global general_log=on;

http://dev.mysql.com/doc/refman/5.1/...ar_general_log