Troubleshooting slow performance of the MySQL on Plesk server

Follow

Comments

12 comments

  • Avatar
    Hany Mesbah Gadalla

    I received the below when I tried to restart the service

    Redirecting to /bin/systemctl restart mysqld.service
    Failed to restart mysqld.service: Unit not found.

  • Avatar
    Bulat Tsydenov

    @Hany Mesbah Gadalla, Hi! your case is being investigated in a support ticket already. Let's continue the discussion in the ticket.

  • Avatar
    Hany Mesbah Gadalla

    Hi Bulat,

    The problem has been solved. You have to remove the space before and after the equal sign (example below). Please update the page.

    innodb_buffer_pool_size=1024M
    query_cache_size=64M

    Thank You

  • Avatar
    Alexandr Tumanov

    @Hany Mesbah Gadalla, thanks for the note. Updated.

  • Avatar
    Atthawut Prathumrat

    Link for  Professional Service team cannot access :)

  • Avatar
    Ivan Postnikov

    @Atthawut Prathumrat

    Hi!
    The link is updated. Thank you for notice)

  • Avatar
    Raheel Ansari

    CentOS doesn't have my.cnf directives in /etc/my.cnf. What directory is the correct location for my.cnf on CentOS running mariadb which is its default database server.

  • Avatar
    Ivan Postnikov

    Hello @Raheel,

    What is the version of CentOS you are using?

    I have double-checked it in the test environment, the default location for my.cnf file on CentOS 7 and CentOS 6 with MariaDB is /etc/my.cnf.

    Open it in any text editor and add the following directives under the [mysqld] section:

    innodb_buffer_pool_size=1024M
    query_cache_size=64M

  • Avatar
    Raheel Ansari

    I added the directives mentioned in this post and it worked. Thank you for that but it didn't resolve the issue I was having which I thought was related to mysql. Turns out the reason behind it was the open_basedir directive for php. 

  • Avatar
    Ivan Postnikov

    Hello @Raheel,

    Thank you for letting us know.

    If you need assistance, feel free to submit a ticket to us.

    As I can see, in the past, we have already had a couple from you.

  • Avatar
    Yogesh Gangurde (Edited )

    I have used following steps solved my problem thank you so much

     

    The problem has been solved. You have to remove the space before and after the equal sign (example below). Please update the page.

    innodb_buffer_pool_size=1024M
    query_cache_size=64M

    Thank You

  • Avatar
    Alisa Kasyanova

    @Yogesh Gangurde
    You are right, there should be no additional spaces in these directives. Glad to know that you have figured it out!

Please sign in to leave a comment.

Have more questions? Submit a request