Troubleshooting slow performance of the MySQL on Plesk server

Follow

Comments

8 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

Please sign in to leave a comment.

Have more questions? Submit a request