Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Turn on Query Logs
How To Turn on Query Logs? - MySQL FAQs - Server Daemon mysqld Administration
✍: FYIcenter.com
If you want MySQL to write query logs to a file, you can use the "--log=fileName" option at the "mysqld" command line. The tutorial exercise below shows you a good example on how to use this option and view the query log file:
>cd \mysql\bin >mkdir \mysql\logs >mysqld --log=\mysql\logs\query.log
Starts another command window, and enter the following commands:
>cd \mysql\bin >mysql -u root -pretneciyf mysql> USE test; Database changed mysql> show tables; +----------------+ | Tables_in_test | +----------------+ | articles | | links | | test | +----------------+ 3 rows in set (0.03 sec) mysql> SELECT * FROM links; +------+-------------------+ | id | name | +------+-------------------+ | 1 | dba.fyicenter.com | | 10 | dba.fyicenter.com | +------+-------------------+ 2 rows in set (0.11 sec) mysql> EXIT; Bye
Here is what you will get in the query log file:
>type \mysql\logs\query.log mysqld, Version: 5.0.24-community-log. started with: Tcp port: 0 Unix socket: (null) Time Id Command Argument 20:19:41 3 Connect root@localhost on 20:20:00 3 Query SELECT DATABASE() 3 Init DB test 20:20:05 3 Query show tables 20:20:52 3 Query SELECT * FROM links 20:21:02 3 Quit
2007-05-11, 4819👍, 0💬
Popular Posts:
If we have the following in a Java code: String s="abc"; String s2="abc"; Then what will be output o...
What Happens If the UPDATE Subquery Returns Multiple Rows? - Oracle DBA FAQ - Understanding SQL DML ...
What is CodeDom? “CodeDom” is an object model which represents actually a source code. It is designe...
How To Create an Add-to-Bloglines Button on Your Website? - RSS FAQs - Adding Your Feeds to RSS News...
What is Traceability Matrix? Traceability Matrix is one of the document will prepare by QA.To make s...