Ingvar Li-Si-Tsin writes: <cut> > But today I got a letter from my hosting administrator > saying (in a rude way - but it > is another matter) that I am kind of disturbing the whole > server"s work > because of the amount of tables in my database.And he also > threatened to switch off > my site.But it"s not him that bothers me - I can remove my > domain. > It is the question of > HOW MANY TABLES I CAN HAVE IN MY DATABASE > > If I am right ( meaning this number is endless) - so I > would nail this son of a gun.. > In case I am not - it means that I will have to change the > whole architecture of > my database.So I would do - but the question remains: Why > did I not find anything > about it in the precious books. Or am I wrong? A there any > official links that could > say anything about it? > > Please answer a.s.a.p. - it is urgent to me. > Sincerely Yours > Lisitsin > P.S. A war is nothing - a manoeuvre is everithing (AN OLD > RUSSIAN PROVERB)
Hi Lisitsin, There is no limitation of how many tables you can have in your database. The problems that you may confront with a big number of tables comes with the filesystem. Each ISAM and MyISAM tables consist of three files (other table types from 1-3 files) and when you begin to have many tables, the number of files is often a multiple number of the number of tables. So rather than a MySQL issue, it is an filesystem issue. Check what filesystem you have in use and how big amount of files in a directory will affect it. If you are using Linux, I would recommend reiserfs. When your ISP told you that you are disturbing with the number of tables in your datadir, there was probably a problem with the number of files (I don't understand why though) rather than a problem with having mysqld taking too much CPU or anything like that. Regards, - Jani For technical support contracts, visit https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Jani Tolonen <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com --------------------------------------------------------------------- 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
