Solved

MySQL database usage

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
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…

813 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

15 Experts available now in Live!

Get 1:1 Help Now