* kapachov > what is the number max of tables that can have a data base MySql?
Limited by the OS and file system only, maximum number of files in a directory, and unless you use InnoDb tables you must divide this number by 3. Maybe you could use multiple databases? You can retrieve data from multiple databases in the same SELECT statement. > that so 1.000.000? That is rather high number of tables... you would need a special file system, I think. It is not very usual to need this high number of tables in a single database... is it possible to redesign your 'data model'? > and tha number max de conections? This is configurable... depends on the 'max_connections' parameter for the mysqld server process, the default is 100. Depending on the design of your system, connections can be shared by multiple users, or they can be created and dropped on the fly. -- 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