| Bug #3254 | Query cache parameters are not picked up from my.ini file | ||
|---|---|---|---|
| Submitted: | 22 Mar 2004 2:14 | Modified: | 13 Sep 2004 8:25 |
| Reporter: | Andreas Götz | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Administrator | Severity: | S3 (Non-critical) |
| Version: | 1.0.2b | OS: | Windows (WinXP) |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
[22 Mar 2004 2:14]
Andreas Götz
[22 Mar 2004 2:15]
Andreas Götz
This does actually seem to be true for all my.ini parameters, also replication settings and others are not picked up, which might lead to misconfiguration...
[13 Apr 2004 19:49]
MySQL Verification Team
Thank you for the bug report. I tested against version 1.0.3 and the my.ini keys were showed adequately.
[14 Apr 2004 0:07]
Andreas Götz
(Query cache) parameters are still not handled as expeced. my.ini: query_cache_size = 12M query_cache_type = 1 Actual Administrator 1.0.3 see screenshot.
[14 Apr 2004 0:09]
Andreas Götz
Screenshot 1.0.3
Attachment: untitled.PNG (image/x-png, text), 59.64 KiB.
[14 Apr 2004 5:23]
MySQL Verification Team
my.ini keys
Attachment: my_ini_display.png (image/png, text), 38.23 KiB.
[14 Apr 2004 5:28]
MySQL Verification Team
Indeed looking your picture it is like you had reported however please see the picture I added and you can verify that both keys are showed adequately on my machine. I am using WinXP, my.ini located c:\windows.
[14 Apr 2004 5:43]
Andreas Götz
Funny. Admin reports it's using c:\win\my.ini which has the settings shown. Copying to c:\windows\my.ini didn't help. Anything I can do to debug this? I've attached my file for testing...
[14 Apr 2004 5:44]
Andreas Götz
faulty cfg file
Attachment: my.ini (application/octet-stream, text), 1.08 KiB.
[14 Apr 2004 6:38]
MySQL Verification Team
What is the output of the below command on your machine ? C:\Documents and Settings\miguel>echo %windir% C:\WINDOWS
[14 Apr 2004 6:40]
Andreas Götz
C:\Profiles\MCHWE175>echo %windir% C:\WIN Again- correct file is indeed used (updates are written back)- I begin to suspect a parsing problem. Did you try with my file?
[14 Apr 2004 7:38]
MySQL Verification Team
Your configuration file doesn't makes difference, for to make a complete test of this case is necessary to have a machine with non-default windir installation and non-default MySQL installation for our GUI team to do or I will do myself. Thank you for the bug report.
[27 Apr 2004 5:24]
Ulrich Bayer
Hi, I am sorry but I am not certain that I understand the situation 100%. The parsing of the file seems to work, I have tried the ini-file you have submitted. Is the automatically chosen location of the my.ini-file the problem? Btw if you enter the skip-mode (hold ctrl during the initial connection-dialog) you can choose what file should be read/updated.
[13 Sep 2004 8:25]
Ulrich Bayer
No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Open". Thank you.
