Adam Lipscombe wrote:
I have MySql 4.1.12 installed on an XP box in C:\mysql.
I have the settings below in my C;\MySql\my.ini file:
I have the transaction-isolation set to READ-COMMITTED but the server seems to ignore this. When the server starts up the tx_isolation as reported by mysqladmin extended-status is REPEATABLE-READ.
I can set it manually from the mysql command line and that works. The tx_isolation is then reported as READ-COMMITTED.
Its almost as if the server is not reading the my.ini file.
It may not be. Do you specify this file when you start the server on the command line? If you don't then you need to move my.ini to the windows directory:
"When the MySQL server starts on Windows, it looks for options in two files: the `my.ini' file in the Windows directory, and the `C:\my.cnf' file. The Windows directory typically is named something like `C:\WINDOWS' or `C:\WinNT'. You can determine its exact location from the value of the |WINDIR| environment variable using the following command:
C:\> echo %WINDIR%
MySQL looks for options first in the `my.ini' file, then in the `my.cnf' file. However, to avoid confusion, it's best if you use only one file. If your PC uses a boot loader where the |C:| drive isn't the boot drive, your only option is to use the `my.ini' file. Whichever option file you use, it must be a plain text file."
