× English Section!

We will be more than happy to help you with problems related to our services and products. Please feel free to write it down as clear as possible

Slow performance of the MySQL on Plesk server

Περισσότερα
5 Χρόνια 5 Μήνες πριν - 5 Χρόνια 5 Μήνες πριν #36 από infogate
Slow performance of the MySQL on Plesk server δημιουργήθηκε από infogate
Symptoms
  • Server is slow due to high CPU usage caused by the "mysql" process.

  • According to this KB article there are multiple slow queries.

  • Websites that are using MySQL databases operate slow.

  • Database dump takes too much time to complete.

General Troubleshooting

1. Connect to the Plesk server via SSH or RDP.

2. Open the MySQL configuration file my.cnf or my.ini in any text editor. Locations of the file are:
- for CentOS/RHEL:
/etc/my.cnf
- for Debian/Ubuntu:
/etc/mysql/my.cnf
- For Windows:
%plesk_dir%Databases\MySQL\my.ini

3. Add the following directives under the [mysqld] section or increase the values if these directives are already defined:
innodb_buffer_pool_size=1024M
query_cache_size=64M

4. Save the changes and close the file.

5. Restart the MySQL service:
- for CentOS/RHEL:
# service mysqld restart
-for Debian/Ubuntu:
# service mysql restart
-for Windows:
Open Task Manager > Services and restart MySQL56 (or MySQL51) service:


6. Analyze and optimize all tables in all databases:
- for Linux:
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqlcheck -uadmin --optimize --all-databases
- for Windows:
%plesk_dir%\MySQL\bin\mysqlcheck.exe -uadmin -P3306 --optimize --all-databases


The best possible way to start your online marketing : fspirits.com/go/leadsleap-home
Explode Your Web Site Traffice: fspirits.com/go/sparktraffic
Start your affiliate journey here: fspirits.com/go/olsp-academy
Best Solution To Create Videos: fspirits.com/go/create-studio-pro
Best Solution To Create Graphics: fspirits.com/go/clickdesigns
Smart Chat Automation: fspirits.com/go/chatterpal
Multi-Purpose Video Maker: fspirits.com/go/avatar-builder
Multi-Purpose Video Creator: fspirits.com/go/video-creator
AI Human Spokesperson Videos: fspirits.com/go/humanpal

Last edit: 5 Χρόνια 5 Μήνες πριν by infogate.

Παρακαλούμε Σύνδεση ή Δημιουργία λογαριασμού για να συμμετάσχετε στη συζήτηση.

Περισσότερα
5 Χρόνια 5 Μήνες πριν - 5 Χρόνια 5 Μήνες πριν #37 από infogate
Απαντήθηκε από infogate στο θέμα Slow performance of the MySQL on Plesk server
Παρακαλούμε συνδεθείτε για να δείτε τις απαντήσεις


The best possible way to start your online marketing : fspirits.com/go/leadsleap-home
Explode Your Web Site Traffice: fspirits.com/go/sparktraffic
Start your affiliate journey here: fspirits.com/go/olsp-academy
Best Solution To Create Videos: fspirits.com/go/create-studio-pro
Best Solution To Create Graphics: fspirits.com/go/clickdesigns
Smart Chat Automation: fspirits.com/go/chatterpal
Multi-Purpose Video Maker: fspirits.com/go/avatar-builder
Multi-Purpose Video Creator: fspirits.com/go/video-creator
AI Human Spokesperson Videos: fspirits.com/go/humanpal

Last edit: 5 Χρόνια 5 Μήνες πριν by infogate.

Παρακαλούμε Σύνδεση ή Δημιουργία λογαριασμού για να συμμετάσχετε στη συζήτηση.

Χρόνος δημιουργίας σελίδας: 0.065 δευτερόλεπτα
Powered by Kunena Φόρουμ