MySQL: Query Log

Is there but do not update/show data

[tomda]

Hi,

I have been through docs/references given in post called "Database optimisation" (http://www.webmasterworld.com/databases_sql_mysql/3153256.htm)

I want to implement the query log (MySQL - MyISAM). The log file has been created when launching the server (with the few lines below) and no other data has been added since.

Either, all my queries are optimised (I really doubt they are), either there is something wrong with MySQL config.

Any idea?

Log query

D:\EasyPHP3\EASYPH~1\MySql\bin\mysqld.exe, Version: 4.1.9-max-log. started with:
Tcp port: 3306 Unix socket: MySQL
Time Id Command Argument

MySQL server variables

log OFF
log bin OFF
log error .\UN331680033.err
log slave updates OFF
log slow queries ON
log update OFF
log warnings 1
long query time 2

[phranque]

you might try "mysqladmin flush-logs"

there is a general query log as well as a slow query log - are they both enabled?

some of this stuff is mysql version-dependent (e.g. starting @ 5.1 you must specify file output - it defaults to table output) so you should read up on specifics here:
[mysql.org...]

[tomda]

Found the problem on mysql website..

From MySQL 4.1, "log-long-format" (showing queries that are not indexed) is not longer used.

"log-queries-not-using-indexes" should be used instead.