0

I am new in Magento 2.2 and facing MySql slow queries issue.I want to know how to use/install MySqltuner in Magento 2. And where is the location of my.cnf file?

Need help to fix this issue.

Thanks

Improve this question
1
  • Please post complete TEXT report from mysqltuner.pl (perl script) for assistance with my.cnf [mysqld] section tuning suggestions.
    – Wilson Hauck
    Oct 21, 2019 at 17:00

1 Answer 1

Reset to default
0

Below are some main Magento2 MySQL Recommeded Configurations.

  • Magento2 requires Above MySQL 5.6.x.
  • Magento2 version 2.1.x and later are compatible with MySQL 5.7.x.
  • Magento2 uses MySQL database triggers to improve database access during reindexing.
  • If you expect to import large numbers of products into Magento, you can increase the value for max_allowed_packet that is larger than the default, 32MB.

For more details Refer this devdocs link - https://devdocs.magento.com/guides/v2.3/install-gde/prereq/mysql.html

Location of my.cnf File are: 

/etc/my.cnf
/etc/mysql/my.cnf
$MYSQL_HOME/my.cnf
[datadir]/my.cnf
~/.my.cnf
Improve this answer
2
  • How to go in etc location?
    – Shoaib Saleem
    Sep 19, 2019 at 12:48
  • Use SSH connection for your OS and cd /etc to 'change directories to destination needed. Use mysqltuner.com for download of PERL script to run mysqltuner.pl to retrieve analysis of your instance information to assist with tuning. All reommendations to be EVALUATED. Some could be WRONG.
    – Wilson Hauck
    Sep 30, 2019 at 21:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.