View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0000327 | MySQL v5 for OS/2 & eComStation | Bug | public | 2009-03-08 09:10 | 2022-05-14 16:31 |
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-08 09:10 | khs | New Issue | |
2009-03-12 07:14 | psmedley | Note Added: 0001246 | |
2009-03-21 21:29 | khs | Note Added: 0001262 | |
2009-04-07 22:00 | khs | Note Added: 0001275 | |
2009-04-07 22:33 | khs | Note Edited: 0001275 | |
2009-04-08 07:11 | psmedley | Note Added: 0001276 | |
2009-04-08 07:11 | psmedley | Status | new => closed |
2009-04-08 07:11 | psmedley | Resolution | open => fixed |
2009-04-08 19:57 | khs | Note Added: 0001277 | |
2009-04-08 19:57 | khs | Status | closed => feedback |
2009-04-08 19:57 | khs | Resolution | fixed => reopened |
2009-04-08 20:30 | khs | Note Added: 0001278 | |
2009-04-25 06:05 | khs | Note Added: 0001295 | |
2022-05-14 16:30 | psmedley | Assigned To | => psmedley |
2022-05-14 16:30 | psmedley | Status | feedback => resolved |
2022-05-14 16:30 | psmedley | Note Added: 0004270 | |
2022-05-14 16:31 | psmedley | Status | resolved => closed |