Professional Web Applications Themes

Query history - MySQL

Is there a way to see what queries have been run recently on a table in mysql? Thanks in advance! rbr...

  1. #1

    Default Query history

    Is there a way to see what queries have been run recently on a table in
    mysql?

    Thanks in advance!

    rbr

    rbr Guest

  2. #2

    Default Re: Query history

    You can switch on the query log in the config file:

    # General log
    log=/some/path/allqueries.sql

    This way, any SQL is sent to that file. Quite useful for localhost
    databases and test servers, but it wastes a lot of space for production
    databases.

    Best regards

    rbr wrote: 
    Willem Guest

  3. #3

    Default Re: Query history

    Thank you much. Especially for the eerily quick reply!

    I believe my log is already on. I will need to go grep the log file for
    what I need.

    Thanks again.

    rbr

    Willem Bogaerts wrote: [/ref]

    rbr Guest

Similar Threads

  1. Query of Queries on query New type query
    By david_h in forum Coldfusion Database Access
    Replies: 2
    Last Post: May 6th, 08:55 PM
  2. insert mysql query into a history table... ?
    By Gawie Marais in forum PHP Development
    Replies: 2
    Last Post: June 23rd, 10:53 AM
  3. history
    By Régine DESSOUBRET in forum Linux / Unix Administration
    Replies: 7
    Last Post: February 24th, 03:49 PM
  4. How can i use the URL History of the IE from asp.net?
    By exshige in forum ASP.NET General
    Replies: 3
    Last Post: August 5th, 04:53 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139