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

electric

• September 12, 2017 21:00

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!

• 

  24x7server

  • September 13, 2017 05:25

  Hi, Try the below plugin and see if that provides any cPanel user interface as you wanted. cPanel App Catalog :: WatchMySQL

  0
• 

  electric

  • September 13, 2017 05:50

  I actually already have that plugin. It does not provide any end-user interface in their cpanel. (It works great for admins, though!)

  0
• 

  cPanelMichael

  • September 13, 2017 18:17

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

  
  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:
  mysql MySQL> SHOW PROCESSLIST;
  Thank you.

  0
• 

  electric

  • September 13, 2017 19:29

  
  mysql MySQL> SHOW PROCESSLIST;
  

  
  Can this be executed from a cpanel page that I create myself? (Can I run that as a mysql query using PHP or something?)

  0
• 

  cPanelMichael

  • September 13, 2017 20:14

  Can this be executed from a cpanel page that I create myself? (Can I run that as a mysql query using PHP or something?)

  
  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.

  0

Please sign in to leave a comment.