MyHosti - International hosting-center Help

Русский English
  • Дома
  • FAQ
  • Administration VDS/Server
  • Database servers
  • MySQL
  • Optimize MySQL settings using MySQLTuner

Категории

  • Domain names
  • Shared/Reselling hosting
  • Administration VDS/Server
  • SSL certificates
  • Software
  • Other
Optimize MySQL settings using MySQLTuner

MySQLTuner is a utility that analyzes the statistics of MySQL and issue recommendations for optimizing MySQL server settings.

First you need to install the utility.

Debian/Ubuntu:

apt-get install mysqltuner

CentOS:

yum install mysqltune

For a more accurate granting of the necessary recommendations to optimize MySQL with MySQLTuner must run for at least 24 hours.

For using the utility, run the command:

mysqltuner

Recommendations for optimization you need to make in configuration file of MySQL.

The location of the configuration file my.cnf:

Debian/Ubuntu

/etc/mysql/my.cnf

CentOS:

/etc/my.cnf

After making changes to the file my.cnf need to restart MySQL server:

Debian/Ubuntu:

/etc/init.d/mysql restart

CentOS:

/etc/init.d/mysqld restart
© MyHosti International, 2013-2020

International hosting center. "MyHosti" works only with the checked methods. In our interests development of your website and growth of its profitability. We watch our reputation and we always equal hopes which on us are laid.

Компания
  • About us
  • Blog
  • Shares
  • FAQ
  • Payment
  • Vacancy
  • Customer Support
Информация
  • Data-center
  • Service programs
  • Documents
  • Status network
  • Services
Поиск статей
€ $ ₽
Яндекс.Метрика
службы мониторинга серверов Uptime по данным Ping-Admin.Ru - сервиса мониторинга доступности сайтов
HostDB.ru - портал о хостинге и хостинг-провайдерах