Solved

MySQL database usage

Posted on 2012-04-04
4
255 Views
Last Modified: 2012-08-13
Hi,

I am using a shared hosting for mysql and the databases are enlarging 0,5 MB per day.

1. What is the optimum size of the database? 10MB, 50MB or 500MB? Since I can chunk the database to smaller ones but I don't want to create a lot because of maintenance issues.
2. In mysql cpanel there is a limit of 50MB for file size to import. Is this a criteria?
4. Some tables are very big. 1 of the 20 tables has the 70% of the data volume. Is this a problem?
0
Comment
Question by:tyuret
  • 2
4 Comments
 
LVL 76

Assisted Solution

by:arnold
arnold earned 350 total points
Comment Utility
The amount of space the database takes within the filesystem is not a determinative as to whether the database setup is optimal.
It all depends what is in the data. I.e. storing binary data such as files, images, etc in the database versus within the filesystem would to be an indication that it might not be optimal design. Files, binary data should be stored within the filesystem while the path should be stored in the databaase/filename.
0
 

Author Comment

by:tyuret
Comment Utility
So if  responds to queries fast enough, it is not important  to have  let's say 1GB size?
0
 
LVL 76

Expert Comment

by:arnold
Comment Utility
No, the database should be organized to maximize info while minimize space utilization on the lie system.  You should have access to phpmyadmin which may help you further tune the performance by suggesting addition of indexes, and/or resolve issues with long running queries every so often. Etc.
0
 
LVL 20

Accepted Solution

by:
virmaior earned 150 total points
Comment Utility
Arnold is exactly right.  There is no way to judge whether a database is well-designed just based on its size.  

On one level, tyuret's comment is exactly right -- as long as it is querying fast enough, it works.

But really the question is whether the data is organized in an optimal way for the application. At a basic level, don't repeatedly store a string value. Instead, reference it by an integer to another table.

Where partitioning starts to matter is for giant applications where the data to be desired is going to be segmented (i.e. most searches in Japanese would go to a Japanese-language DB vs. Chinese to a Chinese one).
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost every time LOAD DATA INFILE comes to the rescue. Here we will try to understand some of the very common scenarios for loading data …
Both Easy and Powerful How easy is PHP? http://lmgtfy.com?q=how+easy+is+php (http://lmgtfy.com?q=how+easy+is+php)  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now