PDA

View Full Version : Convert vbulletin to html? Solution to heavy mysql writing?


postcd
05-20-2014, 03:01 PM
Hello,

i have issue with mysql which writing alot of data to disk, mysql config appears to be optimised.
here is more about that: http://www.dbforums.com/mysql/1701717-mysql-write-too-much-data-disk.html

DB is 8gb in size around

total 7.8G
-rw-rw---- 1 mysql mysql 2.4G May 20 18:03 post.MYD
-rw-rw---- 1 mysql mysql 1.5G May 20 18:03 post.MYI
-rw-rw---- 1 mysql mysql 638M May 7 18:15 guestviews.MYD
-rw-rw---- 1 mysql mysql 606M May 20 18:02 postlog.MYD
-rw-rw---- 1 mysql mysql 336M May 7 18:21 moderatorlog.MYD
-rw-rw---- 1 mysql mysql 281M May 17 15:14 moderatorlog.MYI
-rw-rw---- 1 mysql mysql 252M May 20 18:02 postparsed.MYD
-rw-rw---- 1 mysql mysql 227M May 17 15:12 guestviews.MYI
-rw-rw---- 1 mysql mysql 181M May 20 18:02 tagthread.MYI

and the forum is quite a crap without big value. So i think about closing it and turing it into html somehow? Please is there any easy tool or process to do it?

Zachery
05-20-2014, 06:11 PM
there isn't a guestviews table by default, you should probably disable that addon.

But, there isn't a way to turn your site into html easily.

tbworld
05-20-2014, 06:24 PM
Move your attachments to the file system and stop worrying about it. :) The corporate board I oversee is extremely active and the database by your standards is huge. As long as the system is setup right for resources, performance has really not been an issue.

Did you state somewhere what issues you were having?