Win32 notes

The MySQL-win32 version has by now proven itself to be very stable. The MySQL-win32 version has all the features as the corresponding Unix version of MySQL with the following exceptions:

ALTER TABLE

One can't do a ALTER TABLE on file if it is hold open by another thread or the table cache. On MySQL-win32 I have added code to close the file owned by the thread that does ALTER TABLE but MySQL can't yet close the the file descriptors used by other threads. We have to do a major recode of the file lock system to handle this. For now, when using ALTER TABLE, one must be sure that no other threads are using the table. One can be sure of this by doing a 'mysqladmin refresh' before doing an ALTER TABLE.

Increasing the table cache

Win32 has only a very limited number of open files it can handle at the the same time (about 255). Because of this one shouldn't increase the number of open connections or number of cached tables very much on Win32.

Win95 and threads

Win95 leaks memory for each threads. Because of this one shouldn't run mysqld for an extended time on Win95 if one does many connections as each connection in MySQL creates a new thread! NT doesn't suffer from this bug.

Other win32 specific issues are described in the README file that comes with the MySQL-win32 distribution.

Go to the first, previous, next, last section, table of contents.