10, 000 files open at the same time...maybe the OS itself is getting
flustered, you want to make sure that your OS can handle it, on *nix, u can
do a
ulimit -a and see the open files parameter
Beyond that, the system level limit on Linux can be found as
cat /proc/sys/fs/file-max
- Original
In the last episode (Jun 08), Shoshi Iphtach Cohen said:
Hi experts,
I appreciate if you could tell me how many MySQL tables we can open in
parallel.
From a client's point of view? Unlimited. Internally, mysql will only
open table_cache number of tables at once. If the number of open