Solved

MySQL database usage

Posted on 2012-04-04
4
257 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 77

Assisted Solution

by:arnold
arnold earned 350 total points
ID: 37805651
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
ID: 37806019
So if  responds to queries fast enough, it is not important  to have  let's say 1GB size?
0
 
LVL 77

Expert Comment

by:arnold
ID: 37806401
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
ID: 37819356
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi (http://code.openark.org/blog/mysql/on-restoring-a-single-table-from-mysqldump) had suggested a “sed” way, I actually shell …
Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API (https://www.maxmind.com/en/geolite2-developer-package). …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

867 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

21 Experts available now in Live!

Get 1:1 Help Now