Re: open_files_limit on Windows

[Vladislav Vaintroub]

Anatoly,
that limit is historic and does not exist in MySQL versions starting from 5.5 nor in MariaDB starting from 5.3

So historically, 2048 limit was given by the C runtime library that comes with the Visual C++ compiler, and it does not matter which version of C runtime library you use, because a) C runtime library is statically linked with the server and b) it is a hard limit for all versions of C runtime library (http://msdn.microsoft.com/en-us/library/6e3b887c.aspx).

It is a per-process limit.

"open files" is not the same as "open tables". An open MyISAM table is 3 open files (.frm, . MYI, .MYD). The limit had only effect on MyISAM and Archive, not on Innodb.

You could not monitor number of open (with C runtime) files in MySQL.

Unfortunately this limit affected other, on Windows unrelated variables, like number of concurrent connections

The actual hard limit of open handles per process on current Windows (when not using C runtime) is 2^24 or about 16 millions.