vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Is there any way to make SQL database size small? (https://vborg.vbsupport.ru/showthread.php?t=315712)

ozzy47 11-30-2014 11:36 AM

Yes you can do that for your attachments and avatars.

For attachments, https://www.vbulletin.com/docs/html/...rage_db_to_fs1

For avatars, http://www.vbulletin.com/docs/html/userpics_db2fs

TBH if your host is crying about the size of the DB, you need to get a better host.

Dave 11-30-2014 11:41 AM

Also sometimes when you uninstall plugins they don't delete all tables and data off the database. You should check each table in the database and see if they were ever used by an old mod.

ozzy47 11-30-2014 11:42 AM

This is true, but I would not attempt that unless you know exactly what you are doing. :)

kh99 11-30-2014 12:18 PM

It's probably the attachments, but if you have phpMyAdmin you can go to the list of tables and sort them by size (by clicking on the 'size' column), then if you see any other tables that are large and it's not obvious what it is, it would give you something to look in to.

Also if you move attachments to the file system, that's something that you'd have to back up separately. If you lost everything you could download the vb files and restore your database, but if you didn't have a backup of the attachments and avatars files they would be lost.

Lynne 11-30-2014 04:48 PM

I'd just like to add that before you do *anything* to your database, take a database backup. If you move the attachments out of the database and something goes wrong, you will want to have that database backup!

ozzy47 11-30-2014 04:48 PM

I would have to say you are right, attachments can eat a good amount of DB space. :)


All times are GMT. The time now is 01:49 AM.

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.02060 seconds
  • Memory Usage 1,716KB
  • 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)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)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