At 12:21 PM +0300 1999-12-21, Issam Alameh wrote:
>Hello,
>is there a way to log the access to mysql server, so I can read
>something like:
>
>client connected
>select ...
>
>select ...
>select ...
>
>insert...
>client disconnected??
>
>what type of logs I can have and how to do it.
>
>any help or documentation is highly appreciated
The general log logs the information in which you're interested.
Use the --log option when you start up the server. The update
log logs only queries that modify tables. User the --log-update
option when you start up the server.
--
Paul DuBois, paul@stripped
| Thread |
|---|
| • Logging | Issam Alameh | 21 Dec |
| • Re: Logging | Paul DuBois | 21 Dec |