Our MySQL database on our VB4 forum is a bit larger than we'd like. Some of the larger tables:-
searchcore_text = 223.7MB
post = 173MB
postindex = 154MB
filedata = 44.9MB
postedithistory = 37.5MB
vbstopforumspam_log = 22.4MB
Now, we've moved avatars and CSS etc to the file system, so I'm confused why filedata is so large (which is where I thought it held such things)?
Any suggestions to reduce some of these larger files (or others) down would be most appreciated!?
searchcore_text = 223.7MB
post = 173MB
postindex = 154MB
filedata = 44.9MB
postedithistory = 37.5MB
vbstopforumspam_log = 22.4MB
Now, we've moved avatars and CSS etc to the file system, so I'm confused why filedata is so large (which is where I thought it held such things)?
Any suggestions to reduce some of these larger files (or others) down would be most appreciated!?
Comment