* Egor Egorov > RB> Are you saying that the mysql server will need to open all > the tables in a > RB> database at the same time? When does this happen? When I issue the USE > RB> command? > > Roger, number of opened files is not the same as number of files in > the directory. When table is created, MySQL creates file(s) on the > disk. So, the maximum number of tables is defined by OS > characteristics: how many files (subdirs) OS can handle for the > directory. > > This does not apply to InnoDB tables as they use different > storage scheme.
>From your original post in this thread, answering a question if 300 tables in one database is ok: "Maximum number of tables depends on your OS - the maximum numbers of file descriptors allowed." This was a confusing use of the term 'file descriptor', if I may say so... ;) Also, the number must be divided by 3, as each myisam table have a .frm, a .MYD and a .MYI file... Well, I am not confused any more. Thanks. :) -- Roger query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
