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.

Possible for end-user to see all their active mysql processes?

Discussion in 'Database Discussions' started by electric, Sep 12, 2017.

  1. electric

    electric Well-Known Member

    Joined:
    Nov 5, 2001
    Messages:
    719
    Likes Received:
    3
    Trophy Points:
    318
    Similar to the "WHM-->SQL Services »Show MySQL Processes" functionality.

    Is it possible for the cpanel end-user to see a list of all their own MySQL processes?

    We sometimes have customers who have crazy mysql problems, and ability for them to see a list of their active mysql processes would be very helpful.

    Thanks!
     
    #1 electric, Sep 12, 2017
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,447
    Likes Received:
    56
    Trophy Points:
    28
    Location:
    India
    cPanel Access Level:
    Root Administrator
    #2 24x7server, Sep 13, 2017
  3. electric

    electric Well-Known Member

    Joined:
    Nov 5, 2001
    Messages:
    719
    Likes Received:
    3
    Trophy Points:
    318
    I actually already have that plugin. It does not provide any end-user interface in their cpanel.

    (It works great for admins, though!)
     
    #3 electric, Sep 13, 2017
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

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

    It's not possible in the cPanel UI, but they can access their account via SSH and run the following commands to see their active MySQL processes:

    Code:
    mysql
MySQL> SHOW PROCESSLIST;
    Thank you.
     
    #4 cPanelMichael, Sep 13, 2017
  5. electric

    electric Well-Known Member

    Joined:
    Nov 5, 2001
    Messages:
    719
    Likes Received:
    3
    Trophy Points:
    318
    Can this be executed from a cpanel page that I create myself?

    (Can I run that as a mysql query using PHP or something?)
     
    #5 electric, Sep 13, 2017
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,165
    Likes Received:
    1,371
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    This is unsupported, but I believe it's possible to use the "mysqli" PHP extension for this purpose per the comment listed at the bottom of the following document:

    PHP: mysql_list_processes - Manual

    Information on creating a cPanel plugin is available at:

    Guide to cPanel Plugins - Software Development Kit - cPanel Documentation

    Thank you.
     
    #6 cPanelMichael, Sep 13, 2017
(You must log in or sign up to post here.)
Loading...
Similar Threads - Possible user active
  1. electric

    Possible for end-user to see current processes?

    electric, Sep 5, 2017, in forum: CloudLinux
    Replies:
    1
    Views:
    61
    cPanelMichael
    Sep 6, 2017
  2. 000

    LOGS of TOMCAT into /home of each user, is possible?

    000, May 24, 2016, in forum: Security
    Replies:
    1
    Views:
    460
    cPanelMichael
    Jun 1, 2016
  3. Gher09

    Load emails from pst to server? Is it possible?

    Gher09, Sep 22, 2017 at 3:18 PM, in forum: E-mail Discussions
    Replies:
    2
    Views:
    24
    Gher09
    Sep 22, 2017 at 5:40 PM
  4. electric

    Possible to select different PHP versions for subdomains and folders?

    electric, Sep 9, 2017, in forum: CloudLinux
    Replies:
    2
    Views:
    83
    cPanelMichael
    Sep 12, 2017
  5. elis2

    Is merging partitions possible?

    elis2, Sep 3, 2017, in forum: General Discussion
    Replies:
    3
    Views:
    102
    24x7server
    Sep 6, 2017

Share This Page