www.webdeveloper.com
Results 1 to 4 of 4

Thread: Is there a way to check what queries have been sent to the server and when?

  1. #1
    Join Date
    Jun 2007
    Posts
    400

    Is there a way to check what queries have been sent to the server and when?

    I'm trying to troubleshoot an issue with disappearing threads on my forum, I suspect the delete functionality is broken and is deleting more than it should, but I'm not sure. If I could see when and what queries were sent to my MYSQL server it'd help a lot.

  2. #2
    Join Date
    Dec 2007
    Location
    Dayton, OH
    Posts
    390
    Yes you can!

    If you have the MySQL Administrator tool installed you can simply look at the server logs and then click on the General Query Log tab.

    if you don't you can go here. . .

    [MySQL install dir]\data\generallogs

    That file will contain all transactions.
    It's truly shameful that I have to tell people that they are asking .NET questions in a classic ASP board. . .

  3. #3
    Join Date
    Jun 2007
    Posts
    400
    Wait let me add a bit of important info here. It's not my server, I have space with startlogic. I don't think I can actually get into the directory tree and all of that.

    Maybe I should be asking startlogic themselves. Their customer service gives me headaches though, and I was curious if there was a way from the actual SQL command line or anything like that.

  4. #4
    Join Date
    Dec 2007
    Location
    Dayton, OH
    Posts
    390
    Hmmm. I doubt you could do that purely with SQL, unless they are logging queries in a table or something like that.
    It's truly shameful that I have to tell people that they are asking .NET questions in a classic ASP board. . .

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