vb.org Archive - Convert vbulletin to html? Solution to heavy mysql writing?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - Convert vbulletin to html? Solution to heavy mysql writing? (https://vborg.vbsupport.ru/showthread.php?t=311532)

postcd

05-20-2014 03:01 PM

Convert vbulletin to html? Solution to heavy mysql writing?

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/170171...data-disk.html

DB is 8gb in size around

Quote:

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?

All times are GMT. The time now is 01:01 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01800 seconds Memory Usage 1,713KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: