www.webdeveloper.com
Results 1 to 5 of 5

Thread: [RESOLVED] Viewing Transactions in MySQL

  1. #1
    Join Date
    Jun 2008
    Posts
    118

    resolved [RESOLVED] Viewing Transactions in MySQL

    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!!!!!!

  2. #2
    Join Date
    Sep 2010
    Posts
    160
    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

  3. #3
    Join Date
    Jun 2008
    Posts
    118
    I'm working on Windows.

  4. #4
    Join Date
    Sep 2010
    Posts
    160
    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

  5. #5
    Join Date
    Jun 2008
    Posts
    118
    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:

    Code:
    Set global log_output="TABLE";
    http://dev.mysql.com/doc/refman/5.1/...var_log_output


    Second is to ensure that logging is ON:

    Code:
    set global general_log=on;
    http://dev.mysql.com/doc/refman/5.1/...ar_general_log

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles