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 |
