I suggest you ...

MYSQL Performance Tuning and Monitoring

t would be a good idea to have an SQL section where users can run optimization scripts like MYSQLTUNER etc and enter suggestioned changes in a GUI that directly change the mysql.conf directly and correctly.

An ability to monitor performance and tweak would be ideal, making the task of SQL performance monitoring and tweaking far easier.

Also optimize commands and other tasks could be run for this panel.

as well as optimize and the ability to add it to cron for weekly or monthly.

168 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

H.K shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

6 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    Add an option to monitor external MySQL databases within Plesk and receive notifications

  • H50K commented  ·   ·  Flag as inappropriate

    ^^^Yes, please...

    And by the way do you perform joins without indexes ?

  • Webmeister commented  ·   ·  Flag as inappropriate

    Please add MySQL tuning, especially for modern hardware with 32 or 64 GB memory and 4 to 8 cores and fast SSD or NVMe drives. Thanks!

  • Rudy commented  ·   ·  Flag as inappropriate

    It would be a good idea to be able to make some tunings to mysql configuration (my.cnf) as happens with php directives .

  • William Thompson commented  ·   ·  Flag as inappropriate

    I like the feature to monitor the web log to see file execution as they come in and the PHP errors. It would be nice to have a similar tool to see the sql queries come in and see if there are any errors.

Feedback and Knowledge Base