mercredi 3 décembre 2014

Need help in increasing maximum table size


Two of the tables vb_post, vb_profilevisitor getting corrupted again and again.


The hosting company suggested the following:



Looks like the problem is that the .MYD table was converted to a .TMD table as per the below article:


http://ift.tt/1yat7Pc


".TMD basically a temparory file of .MYD. it gets converted into .TMD if the data size of the table has exceeded the actual size of the data. in that case you can alter the table and increase the MAX size of the table."


We renamed the table back to the .MYD extension, but please check on the MAX size of the the table.



May i know how to do it. I want to change for two tables,



vb_post
vb_profilevisitor


This is my present values in database:



vb_profilevisitor: present Rows: 11995 Avg_row_length: 15

Max_data_length: 64424509439 vb_post: present Rows: 1325242

Avg_row_length: 1514 Max_data_length: 281474976710655



Can I alter it and increase the maximum table size with the following.



ALTER TABLE `vb_profilevisitor` MAX_ROWS=98281474976710655 AVG_ROW_LENGTH=1000000000;
ALTER TABLE `vb_post` MAX_ROWS=98281474976710655 AVG_ROW_LENGTH=1000000000;


Need quick replies.





Aucun commentaire:

Enregistrer un commentaire