Register Members List Search Today's Posts Mark Forums Read

Thread Tools
Old 20 May 2014, 16:01
postcd postcd is offline
Join Date: Feb 2012
Post Convert vbulletin to html? Solution to heavy mysql writing?


i have issue with mysql which writing alot of data to disk, mysql config appears to be optimised.
here is more about that:

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?
Reply With Quote
Old 20 May 2014, 19:11
Zachery's Avatar
Zachery Zachery is offline
Join Date: Jul 2002
Real name: Zachery Woods
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.
Looking for ImpEx?
Reply With Quote
Old 20 May 2014, 19:24
tbworld tbworld is offline
Join Date: Oct 2008
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?
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

New To Site? Need Help?

All times are GMT. The time now is 00:44.

Layout Options | Width: Wide Color: