The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
|||
|
|||
Need help in increasing maximum table size
Two of the tables vb_post, vb_profilevisitor getting corrupted again and again.
**********************hosting peoples sugggestions**************** Looks like the problem is that the .MYD table was converted to a .TMD table as per the below article: http://www.raskas.be/blog/2008/04/08...and-tmd-files/ ".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. **********************hosting peoples sugggestions**************** May i know how to do it. I want to change for two tables, vb_post vb_profilevisitor This is my present values in databse 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. |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|