Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

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.

SOLVED PHPMyadmin 4.6.x is slow to load

Discussion in 'Database Discussions' started by cachout58, Apr 28, 2017.

Tags:
  1. cachout58

    cachout58 Member

    Joined:
    Aug 10, 2016
    Messages:
    21
    Likes Received:
    2
    Trophy Points:
    3
    Location:
    Dl
    cPanel Access Level:
    Root Administrator
    Hi there !

    We have been facing severe phpmyadmin loading issues since whm upgrade to 64. Phpmyadmin 4.6.x seems to work very low inside cpanel whereas it works fine in whm. Any fixes ?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Internal case CPANEL-12760 is open to track reports of slowness with the new version of phpMyAdmin included with cPanel 64. I'll monitor the status of this case and update this thread with more information as it becomes available.

    Could you verify if you notice any difference when disabling "Use INFORMATION_SCHEMA to acquire MySQL disk usage" under the "SQL" tab in "WHM >> Tweak Settings"?

    Thank you.
     
  3. cachout58

    cachout58 Member

    Joined:
    Aug 10, 2016
    Messages:
    21
    Likes Received:
    2
    Trophy Points:
    3
    Location:
    Dl
    cPanel Access Level:
    Root Administrator
    Yes, we tried disabling that option and also tried various solutions provided by support like optimizing mysql settings like query cache and table_open_cache etc. Nothing seems to work. The old version of phpmyadmin works fine [ 4.1.x ] where the cpanel update was not done. It has been many days since we reported but no solution so far
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello @cachout58,

    I'll update this thread with more information on the status of internal case CPANEL-12760 as it becomes available.

    Thank you.
     
  5. cinusik

    cinusik Active Member

    Joined:
    Jul 31, 2003
    Messages:
    38
    Likes Received:
    1
    Trophy Points:
    158
    cPanel Access Level:
    Root Administrator
    Any update? As we receive lot of emails from our customers regarding very slow or even not loading phpMyAdmin.
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    The case is active, and we are investigating to determine if this is related to existing bugs with phpMyAdmin, however there's no time frame available on when we might release an update to address the issue. I'll update this thread as soon as more information is available.

    Thank you.
     
  7. cachout58

    cachout58 Member

    Joined:
    Aug 10, 2016
    Messages:
    21
    Likes Received:
    2
    Trophy Points:
    3
    Location:
    Dl
    cPanel Access Level:
    Root Administrator
    Hi,

    This has been pending for two months now. Any update ?
     
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello @cachout58,

    The development team responsible for this case is working on a change to streamline when database privilege updates are ran. This should help address the phpMyAdmin slowness issue. I'll update this thread again once we have a more definitive release time frame.

    Thank you.
     
  9. cachout58

    cachout58 Member

    Joined:
    Aug 10, 2016
    Messages:
    21
    Likes Received:
    2
    Trophy Points:
    3
    Location:
    Dl
    cPanel Access Level:
    Root Administrator
    Any update in this regard. We are unable to upgrade to latest cpanel version due to this issue.
     
  10. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    There's no update to report at this time, but I do see recent activity aimed at addressing the issue. I'll continue to monitor the internal case and update this thread with more information as it becomes available.

    Thank you.
     
  11. kdsuser

    kdsuser Registered

    Joined:
    Jul 24, 2017
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    bangalore
    cPanel Access Level:
    Reseller Owner
    Hi

    We have also facing the same issue and my customers are really suffering due to this. phpmyadmin is very important to manage mysql database. But now due to slowness all clients are leaving and preferring windows plesk control panel. we are facing several issues and business loss due to this phpmyadmin.Because of this we are also not able to upgrade to latest version of whm.
     
  12. cinusik

    cinusik Active Member

    Joined:
    Jul 31, 2003
    Messages:
    38
    Likes Received:
    1
    Trophy Points:
    158
    cPanel Access Level:
    Root Administrator
    Issue still not resolved. Can you tell us how much longer we have to wait for solution to this? Customers are really mad.
     
  13. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    To update, internal case CPANEL-12760 will help to alleviate the slowness incurred when a cPanel user accesses the phpMyAdmin page by ensuring the MySQL updateprivs function is no longer called unconditionally. There's no specific time frame to offer on the publication of this change (it should be in the next 64 maintenance release), but I'll update this thread again once it's released.

    Note this won't completely eliminate the issue, as a separate case (CPANEL-14601) is open to address the slowness incurred when a reseller accesses phpMyAdmin while logged into cPanel with the cPanel username and reseller password. I'll monitor that case and update this thread with more information as it becomes available.

    Thank you.
     
  14. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    To update, the resolution associated with CPANEL-12760 is planned for inclusion with cPanel 64.0.38 (this new build should be out soon). The full cPanel 64 change log is available at:

    64 Change Log - Change Logs - cPanel Documentation

    Thank you.
     
    #14 cPanelMichael, Aug 14, 2017
    Last edited: Sep 14, 2017
  15. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    In addition to the inclusion of CPANEL-12760 in cPanel version 64.0.38, we've also published the following case in cPanel version 66.0.22 to help address the slowness for users accessing phpMyAdmin while logged in with the account's username and password:

    Fixed case CPANEL-14998: Remove interstitial page updateprivs

    Additionally, internal case CPANEL-15796 in cPanel version 68 should alleviate slowness encountered when accessing phpMyAdmin using cPanel with the root or reseller password.

    Thank you.
     
  16. cinusik

    cinusik Active Member

    Joined:
    Jul 31, 2003
    Messages:
    38
    Likes Received:
    1
    Trophy Points:
    158
    cPanel Access Level:
    Root Administrator
    phpmyadmin in cPanel still slow, this update does not fixed the issue :( Customers still complaining.
     
  17. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Can you verify which version of cPanel is installed on this system? Note that in the event the slowness relates to access attempts to phpMyAdmin while logged in with the root or reseller password, internal case CPANEL-15796 in cPanel version 68 should alleviate that issue.

    Thank you.
     
  18. cinusik

    cinusik Active Member

    Joined:
    Jul 31, 2003
    Messages:
    38
    Likes Received:
    1
    Trophy Points:
    158
    cPanel Access Level:
    Root Administrator
    v66.0.23 on two servers. Issue reproduced on both of them. No reseller or root password used. Just regular user cPanel access - even small databases taking ages to load table lists, every operation taking 100 - 120 seconds. This leads to completely unusable phpmyadmin.
     
  19. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Could you verify if you notice any difference when disabling "Use INFORMATION_SCHEMA to acquire MySQL disk usage" under the "SQL" tab in "WHM >> Tweak Settings"? If not, feel free to open a support ticket so we can take a closer look.

    Thank you.
     
Loading...

Share This Page