vb.org Archive
Page 1 of 3 1 23
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   General Hosting/Server Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=197)
-   -   How to free up some SQL space (https://vborg.vbsupport.ru/showthread.php?t=133153)

Shazz 12-03-2006 08:55 PM
How to free up some SQL space
 
I use 1and1 hosting...
With the gay 100 MB SQL storage
And im starting to worry that im going to run out, what would be the best way to free up some?
Ive moved my attachments to file system if that did anything...

I have arcade scores saved to the SQL database, Im not sure how much that sucks up but any ideas?

Dismounted 12-04-2006 08:42 AM
Get a new host? :D

Shazz 12-04-2006 12:52 PM
Do I have any other choices besides that ? :(

Ziki 12-04-2006 01:22 PM
Sure.Delete some members :D

Shazz 12-04-2006 01:26 PM
Quote:
Originally Posted by Ziki (Post 1131586)
Sure.Delete some members :D
LOL
yea thats a nice solution, as well as prune every post and thread(blank site) :hurt:

Do custom avatars store on the SQL database as well?
I wonder what else could get off the database to free up some room like I did with attachments -.-

peterska2 12-04-2006 04:25 PM
custom avatars and profile pics are stored in the db by default although you can change them to be stored in the file system along with sig pics. Make sure you set the customavatars, customprofilepics, and signaturepics folder to 777 before changing the settings in the ACP though.

Shazz 12-04-2006 09:48 PM
Quote:
Originally Posted by peterska2 (Post 1131699)
custom avatars and profile pics are stored in the db by default although you can change them to be stored in the file system along with sig pics. Make sure you set the customavatars, customprofilepics, and signaturepics folder to 777 before changing the settings in the ACP though.
Doing that now, hope that makes a difference. Thanx for your input perterska :)

khmh06 12-11-2006 04:38 AM
You can del the words table but your search tool will be not work corectly

Adrian Schneider 12-11-2006 04:39 AM
empty the postparsed table and/or get a new host. 100mb is nothing :(

Shazz 12-11-2006 01:33 PM
Threads: 336, Posts: 1,003, Members: 317

Used Storage Space
9.16 MB

With attachments and avys on file system :D


All times are GMT. The time now is 06:41 AM.
Page 1 of 3 1 23
Show 40 post(s) from this thread on one page

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.01250 seconds
  • Memory Usage 1,727KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete