Hi, I'm doing a school project, and I'll need to have a lot of information in a database. What is the maximum number of tables/rows for one mysql database? The method I had in mind could possibly reach a billion rows (all computer generated rows). The rows would be very small, only a few bits of info. Would one table be able to hold this? Or would I have to make a bunch of smaller ones?
Well tables has a limit but it depends on the OS being run. Many different Linux distros have a max number of files within a directory. Usually that's about 32k files. For every table within a database, 3 files get created. 32k/3 = about 9 thousand individual tables. Again though, that depends on the limits placed by the OS. Thats not a hard max though. Rows are pretty much unlimited. Reference: http://dev.mysql.com/doc/refman/5.1/en/features.html