Solved

MySQL database usage

Posted on 2012-04-04
4
265 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 78

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 78

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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

687 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