The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL DB size shows 0 Mb in cPanel

Discussion in 'Database Discussions' started by sinys_85, Jul 19, 2010.

  1. sinys_85

    sinys_85 Member

    Joined:
    Jan 28, 2010
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Hello.
    Yesterday I have a some problem. When I logged to my cPanel >> Databases >> MySQL databases I see that the size all of my DB is show"n by 0 Mb :eek:
    It"s wrong and I have found a fix for that.

    1) Edit /var/cpanel/cpanel.config

    Change:

    disk_usage_include_sqldbs=0

    to

    disk_usage_include_sqldbs=1

    Then run the following:

    /scripts/update_db_cache

    This may take a few minutes if you have a ton of users with databases, but after this, you should see the database disk usage show up accurately in cPanel.
     
  2. Sofia

    Sofia Registered

    Joined:
    Jan 21, 2011
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1

    Issue is not fixed :(
    Still I am getting the same error while creating a new database.

    Regards,
    Sofia
     
  3. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,475
    Likes Received:
    202
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    What is the error?
     
  4. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    On 11.26 machines, if you are using MySQL 4.0 or MySQL 4.1, cPanel > MySQL Databases area will not display the disk usage. This does work for MySQL 4 and 5 on 11.28 machines, though, which should be the default version on all tiers unless your machine hasn't been automatically updated recently. (MySQL 4 was added for "Include databases in disk usage calculations" per internal case #42912.)

    Also, it is far easier to just update this setting in WHM > Tweak Settings area over editing the /var/cpanel/cpanel.config file manually:

    WHM > Tweak Settings > Include databases in disk usage calculations

    Then save the area.
     
  5. harishk

    harishk Registered

    Joined:
    Jan 29, 2011
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    I've WHM 11.28.64 CENTOS 5.5 i686 standard on lisbon box with Mysql 4, but the cPanel is still showing the mysql database size 0. Please see the below response, from one of your staff members, who advised us to upgrade the mysql 4 to mysql 5, but as per your post, I guess there is no need to do so. can you please advise ?

    ======================
    cPanel Ticket # 1182502

    Hello

    In order to support space calculations on MySQL, you need to make sure you run at least MySQL 5.0 as the SQL code to generate space calculations isn't available on MySQL 4.1.Please let us know if you need anything else.


    --
    Gary Stanley
    FreeBSD/Linux Technical Analyst II
    cPanel

    ======================
     
    #5 harishk, Jan 29, 2011
    Last edited: Jan 29, 2011
  6. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Hello,

    Please re-reply to the ticket and quote the internal case number I quoted in the ticket (42912) where it was indicated in our system that MySQL 4 should now be included (and why in 11.28 it doesn't have a message stating MySQL 4 isn't supported for that specific option any longer).

    I've also asked another technician to review the ticket, but replying to it in case you don't get a response back tonight would be helpful.

    Thank you.
     
  7. harishk

    harishk Registered

    Joined:
    Jan 29, 2011
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    I've replied the ticket.

    Thanks
     
  8. coderiser

    coderiser Member

    Joined:
    Jan 31, 2011
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    1
    check your database mapping
     
Loading...

Share This Page