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
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 Me
