Get Paid to Participate - up to $1 per post!     Twitter     Facebook     Google+
Hosting Discussion
 

forgot password?



Reply


Old
  Post #1 (permalink)   08-15-2007, 05:28 PM
HD Master
 
Join Date: Mar 2007
Location: B.C, Canada
Posts: 363

Status: Harry is offline
I had a odd question about Cpanel. Everyone knows once you login you're able to view how big your mysql database is, however, I've noticed during backups the cpanel size seems to be off, usually by a bit. Today I got another backup and the cpanel shows 124MB, yet when I downloaded it, the actual sql file was only 94MB.. Usually I've noticed a SMALL different, but that's a fairly large gap.

So I guess my questions is how accurate is cpanel really, with space, bandwidth, mysql etc.. on the default cpanel login page?
 
 
 


Old
  Post #2 (permalink)   08-16-2007, 08:03 AM
HD Newbie
 
Join Date: Aug 2007
Location: Houston, TX
Posts: 13
Send a message via AIM to cPanelDavidG

Status: cPanelDavidG is offline
Quote:
Originally Posted by Harry
I had a odd question about Cpanel. Everyone knows once you login you're able to view how big your mysql database is, however, I've noticed during backups the cpanel size seems to be off, usually by a bit. Today I got another backup and the cpanel shows 124MB, yet when I downloaded it, the actual sql file was only 94MB.. Usually I've noticed a SMALL different, but that's a fairly large gap.

So I guess my questions is how accurate is cpanel really, with space, bandwidth, mysql etc.. on the default cpanel login page?
We've had a lengthy discussion about this on our own forums. Essentially, what it boils down to is that determining the actual size of some databases is not an exact science. As of right now, the software over-estimates the amount of disk space occupied by a InnoDB MySQL Database.

That's why MySQL disk usage currently is not counted towards a user's disk quota. The developers are working on a more reliable way of determining the disk usage of all types of MySQL databases and once that is done, then it is likely MySQL disk usage will be counted towards a user's quota.
__________________
_____________
David Grega
Technical Sales Representative
cPanel, Inc.
 
 
 


Old
  Post #3 (permalink)   08-16-2007, 04:30 PM
HD Master
 
Join Date: Mar 2007
Location: B.C, Canada
Posts: 363

Status: Harry is offline
Quote:
Originally Posted by cPanelDavidG
We've had a lengthy discussion about this on our own forums. Essentially, what it boils down to is that determining the actual size of some databases is not an exact science. As of right now, the software over-estimates the amount of disk space occupied by a InnoDB MySQL Database.

That's why MySQL disk usage currently is not counted towards a user's disk quota. The developers are working on a more reliable way of determining the disk usage of all types of MySQL databases and once that is done, then it is likely MySQL disk usage will be counted towards a user's quota.
ah, thanks for the clear up. I was always wondering about it. I do remember back in the day Cpanel didn't include MYSQL quote in the control panel. Then on their next version they did and now still do.

Thanks for clearing it up though, because I was wondering about that backup.
 
 
 
Reply

Thread Tools

New Post New Post   Old Post Old Post
Posting Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Sponsored By: