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? Quote 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 Quote 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? Quote 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. Quote 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 Quote 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* Quote 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? Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.