View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0000327 | MySQL v5 for OS/2 & eComStation | Bug | public | 2009-03-07 22:40 | 2022-05-14 07:01 |
Reporter | khs | Assigned To | psmedley | ||
Priority | normal | Severity | major | Reproducibility | always |
Status | closed | Resolution | reopened | ||
Summary | 0000327: no slow query file with mysql 5.1.32 | ||||
Description | I set the following option in the my.cnf but there is no log file created. slow_query_log = 1 slow_query_log_file = h:/data/mysql5/slow_queries.log The status output in mysql: slow query log ON slow query log file h:/data/mysql5/slow_queries.log But there is no file in the directory. | ||||
Tags | No tags attached. | ||||
|
I assume you've reviewed the documentation at http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html to understand the changes introduced in 5.1? I'll try look at this tonight anyway |
|
I know that the configuration with 5.1 was changed. The old syntax is working with mysql 5.0.67. |
|
changed: Problem is not fixed with mysql 5.1.33. |
|
Resolved in 5.1.33 |
|
A possible reason for the log file problem could be the option "datadir". In the past it was set with "datadir=h:/data/mysql5" and the slow query logfile is missing. I test it today without "datadir" and the data directory as subdir of the program directory and now i see the slow.log. |
|
After "running mysql_upgrade.exe --force" the slow queries log file is written. But I need to run the upgrade after every startup of mysqld. |
|
Same situation with MySQL 5.1.34. The mysql_upgrade fix the problem for the running server. After shutdown it is broken again. |
|
Please retest with a support build of mysql |
Date Modified | Username | Field | Change |
---|---|---|---|
2009-03-07 22:40 | khs | New Issue | |
2009-03-11 20:44 | psmedley | Note Added: 0001246 | |
2009-03-21 10:59 | khs | Note Added: 0001262 | |
2009-04-07 12:30 | khs | Note Added: 0001275 | |
2009-04-07 13:03 | khs | Note Edited: 0001275 | |
2009-04-07 21:41 | psmedley | Note Added: 0001276 | |
2009-04-07 21:41 | psmedley | Status | new => closed |
2009-04-07 21:41 | psmedley | Resolution | open => fixed |
2009-04-08 10:27 | khs | Note Added: 0001277 | |
2009-04-08 10:27 | khs | Status | closed => feedback |
2009-04-08 10:27 | khs | Resolution | fixed => reopened |
2009-04-08 11:00 | khs | Note Added: 0001278 | |
2009-04-24 20:35 | khs | Note Added: 0001295 | |
2022-05-14 07:00 | psmedley | Assigned To | => psmedley |
2022-05-14 07:00 | psmedley | Status | feedback => resolved |
2022-05-14 07:00 | psmedley | Note Added: 0004270 | |
2022-05-14 07:01 | psmedley | Status | resolved => closed |