vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   (How to?) Database Oversized (https://vborg.vbsupport.ru/showthread.php?t=142332)

alaliga 03-17-2007 08:51 PM
(How to?) Database Oversized
 
Hello ...

Please Anywho may help me to reduce my Database size? its now about (125 MB) is there is any way to reduce this size by any way .. with out efficting the numbers of users posts and all forum numbers ( Registred Users - Number of all posts and like that ) ???

Advanced Thanks

orth 03-17-2007 09:45 PM
Maybe you could try pruning some logs in the db.

Go into your AdminCP and for each of your Control Panel Log, Scheduled Task Log and Moderator Log under the "Statistics & Logs" block, run a Prune using your desired settings.

alaliga 03-18-2007 01:33 PM
@orth Thanks

I've do what you say .. but that not effictes with the database size ... after what you say thenI do optimize then repair the size reduced to 128.4 MB ...

Any Other Sulution?

NOTE: The database was work with phpBB 2.0 .. Converted to VB .

Advanced Thanks

Zia 03-18-2007 03:59 PM
turning of the FULL TEXT SEARCH //might help some times...

like:
6/7 month ago our db size was 62MB. when we trun on the full text search on.DB size reduced to 48MB.

dont will work for u or not.

Zachery 03-18-2007 04:00 PM
Your best bet is to find a host who does not have such silly restrictions on the databases you have.


All times are GMT. The time now is 04:59 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00918 seconds
  • Memory Usage 1,708KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)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