Jamer Posted May 4, 2017 Share Posted May 4, 2017 Hi, I recently upgraded my forum from version 3.4 to the latest version. This process also updated mysql. Today I received an email from my host telling my my database is too big, and I have a current size of 761 MB and reached the limit of 400 MB. How can I reduced the database size? Never had this problem before. Any advice would be appreciated. Link to comment Share on other sites More sharing options...
MADMAN32395 Posted May 4, 2017 Share Posted May 4, 2017 who wants to bet it was the utf8mb4 conversion tables? Link to comment Share on other sites More sharing options...
ASTRAPI Posted May 4, 2017 Share Posted May 4, 2017 Converting to the latest version the database uses utf8mb4 and that make the database bigger so it is normal. If you have a limitation for 400MB for your database then you must look for a bigger plan on the current host or get a new host Link to comment Share on other sites More sharing options...
MADMAN32395 Posted May 4, 2017 Share Posted May 4, 2017 1 minute ago, ASTRAPI said: Converting to the latest version the database uses utf8mb4 and that make the database bigger so it is normal. If you have a limitation for 400MB for your database then you must look for a bigger plan on the current host or get a new host possible duplicate tables after conversion? I know I did when I converted, backed up and deleted the temporary tables it created. I just don't recall what exactly they were labeled as Link to comment Share on other sites More sharing options...
Bluto Posted May 4, 2017 Share Posted May 4, 2017 Might also be tables from old plugins which can be deleted. Link to comment Share on other sites More sharing options...
Rhett Posted May 4, 2017 Share Posted May 4, 2017 1 hour ago, MADMAN32395 said: possible duplicate tables after conversion? I know I did when I converted, backed up and deleted the temporary tables it created. I just don't recall what exactly they were labeled as Yes currently duplicate tables are created, check your database to see if this is the case, if so and your upgrade has completed fine, you can remove the old_ tables. Link to comment Share on other sites More sharing options...
Jamer Posted May 4, 2017 Author Share Posted May 4, 2017 Thank you for all replies. Can someone please provide me with a list of tables that are no longer needed? Also any tips on how to prevent spider logs etc? Link to comment Share on other sites More sharing options...
SJ77 Posted May 11, 2017 Share Posted May 11, 2017 Old tables have a special prefix (can't remember at this point what it is) orig? also check error log table. I've had issues leading to that table growing gigantic. If this is the issue you can fix whatever is causing the errors then truncate the table edit: yup Link to comment Share on other sites More sharing options...
SJ77 Posted May 11, 2017 Share Posted May 11, 2017 Double post. Oops Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.