mysql size optimisation ? list of modules needs ?
How to optimise mysql size for mutualized servers ? Is there a ressource somewhere that lists modules kbytes needs ? Advise request.
Hello,
I am on my first site creation. I have taken a mutualized server (1Gb, 1Gbps/month, 5Mb mysql). The mysql database is limited to 5 Mb only, and it is nearly full though it is still offline.
Here are the modules I have installed & enabled :
Poormanscron, Content translation, Forum, Ping, Locale, Poll, Profile, Search, Tracker, Trigger, Path, Color, Database logging, Help, Menu, Comment, Taxonomy, Update status, Capcha, Math CAPTCHA, Text CAPTCHA, CAPTCHA Pack, Notify, Block user messages, Statistics, Statistics Advanced Settings, Google Analytics, Facebook Connect, Fbconnect Profile, Twitter, Views, Advanced Forum, Privatemsg, User Points, User Points Contributed modules, Role exempt, User to User Points, Userpoints Admin Email, Userpoints Badges, Userpoints Comments per Type
Userpoints No Negative, Userpoints Page Views, Userpoints Retroactive, Userpoints role, Userpoints rules integration, Votingpoints, User Stats, User titles, Ignore User, Wysiwyg API, tinymce, Live, Quote, Smileys, Signatures for Forums, abuse, Subscriptions, Content Subscriptions, Subscriptions Mail, Taxonomy Subscriptions, Author Pane, Invite, Token, Token actions, Rules, Rules Administration UI, Rules Scheduler, Content Access, Auto Assign role, Translations/2 languages.Is there a link somewhere that list typical disk consumption per module in the mysql database, or some calculator that takes into account the overall configuration, where we can simulate, optimize, and make decisions ?
If not, what do you advise to me ? My need is for a politics forum, with a welcome page, annexe pages, donate and support payment buttons, projects pages, and some restricted areas. I choose a priori forum instead of blog since it looks more orginized, but I want to make it user friendly with wysiwyg and points management. I need stats to try to make it popular, and probably a few other modules like Meta Tags, Page Title, Titles rewrite, SEO checklist, Pathauto, Automatic NodeTitles.
Am I condamned to have a dedicated server ? Is there some optimisations possible in mysql database ? Compression is already active on the server.
.
You don't need a dedicated server by any means but 5MB is very small. You should be able to find a shared account that gives you more than that.
Sorry I don't know the answer to your actual question. I haven't paid that much attention to how big my databases are.
Michelle
---
I'm looking for folks to help me out by posting in my Coulee Region forums. You don't need to live in the area; there's plenty of general forums. But please, no Drupal support questions. :)
No need for a dedicated server
There is nothing available to do what you are asking, but you should not have to worry about that at this stage either. See http://drupal.org/node/286625 for some information on optimizing drupal and mysql. Also down load YSlow. It's a yahoo app that can be made a part of Firefox. Yslow will tell you how fast your site is or for that matter any site and what you can do to improve it.
I run a website with over 40 contributed modules and over 300 stories and blog posts. My database is about 8MB. This is small but it has lots of content and I get about 1,100 unique visitors a day. I use http://www.hotdrupal.com/. I have a Plus Plan at ~$15 a month. There are other less expensive plans too and you can change plans as you grow They will help you move your site from your existing host, set up and are very reliable. Send them an email and ask for Steve Brown. Ask him how he optimizes the MYSQL databases.
There are plenty of other choices. Do your home work.