zgkhoo Posted November 9, 2007 Share Posted November 9, 2007 what is the max number table/database limit for mysql? what if i reach those limit? Link to comment https://forums.phpfreaks.com/topic/76685-what-is-the-max-number-tabledatabase-limit-for-mysql/ Share on other sites More sharing options...
mezise Posted November 10, 2007 Share Posted November 10, 2007 Hi, it depends on many things: mysql version, table type, OS version, file system, disk storage size. Go to mysql manual pages and search by "limit" keyword. You'll find many interesting entries. Or just try to google "mysql maximum number of tables" Michal Link to comment https://forums.phpfreaks.com/topic/76685-what-is-the-max-number-tabledatabase-limit-for-mysql/#findComment-388270 Share on other sites More sharing options...
zgkhoo Posted November 10, 2007 Author Share Posted November 10, 2007 wat if i reach those limit? the database cant insert any data anymore? would it crash the website? Link to comment https://forums.phpfreaks.com/topic/76685-what-is-the-max-number-tabledatabase-limit-for-mysql/#findComment-388305 Share on other sites More sharing options...
mezise Posted November 10, 2007 Share Posted November 10, 2007 General answer is "yes", but a programmer or a system administrator may check periodically or before every meaning operation if there are needed resources. Link to comment https://forums.phpfreaks.com/topic/76685-what-is-the-max-number-tabledatabase-limit-for-mysql/#findComment-388478 Share on other sites More sharing options...
zgkhoo Posted November 11, 2007 Author Share Posted November 11, 2007 wat if i changed to oracle? is it need rewrite all my *.php files? thanks Link to comment https://forums.phpfreaks.com/topic/76685-what-is-the-max-number-tabledatabase-limit-for-mysql/#findComment-388836 Share on other sites More sharing options...
zgkhoo Posted November 11, 2007 Author Share Posted November 11, 2007 *bump* Link to comment https://forums.phpfreaks.com/topic/76685-what-is-the-max-number-tabledatabase-limit-for-mysql/#findComment-388972 Share on other sites More sharing options...
AndyB Posted November 11, 2007 Share Posted November 11, 2007 http://dev.mysql.com/doc/refman/5.0/en/full-table.html The maximum is absolutely huge. Do you suspect a real problem, or are you asking out of interest only? Link to comment https://forums.phpfreaks.com/topic/76685-what-is-the-max-number-tabledatabase-limit-for-mysql/#findComment-389036 Share on other sites More sharing options...
zgkhoo Posted November 12, 2007 Author Share Posted November 12, 2007 i suspect a real problem..which afraid after i design the database reach the limit.. thanks Link to comment https://forums.phpfreaks.com/topic/76685-what-is-the-max-number-tabledatabase-limit-for-mysql/#findComment-389880 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.