From: "d2clon" > im very interested about the limitations and hardware features support. > for example: > > software limitation: > how much rows does a table can to have? > how much size of a database does mysql support?
These depend on the version of MySQL and the OS The number of rows is virtually unlimited; some users appear to store 5,000,000,000 rows in a table, so no worries there.... The size of a table is limited by the file system: http://dev.mysql.com/doc/mysql/en/table-size.html > hardware features support: > has mysql multi-processor support? how much processors? AFAIK MySQL runs a query in a single process. Since database servers often need to process more than one query at the same time additional processes will be started to serve the queries for extra connections. The OS will arrange the use of processors by various processes > how is the size maximum of the RAM that mysql support? This is again an OS limit. In a 32-bit environment processes are limited to 2GB (3GB or so by using certain pages in various Linux versions); in a 64-bit environment processes can use far more memory (I don't know the limit by heart, but is is much larger than you can afford or the motherboard supports) Using recent developments such as MySQL Cluster you can spread a database over multiple servers, so this will increase the size of the databases MySQL can handle even more. Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
