MySQL Optimization

Hello, we are looking for someone who can review and optimize our current MySQL Server

We have a MySQL server that runs a phone system.

Sometimes it runs very slowly due to slow queries. Sometimes it runs very slowly because of locked tables due to some of the tables constantly optimizing.

First, we would like you to check the current performance and see what can be done to improve the speed of slow queries.

Second, I have a question about query_cache. I wonder if changing or raising this setting will help improve things. Also, what are the limits of how high query_cache can be raised?

our current version is: MySQL Version 10.1.48-MariaDB-0+deb9u2 x86_64

Please respond to this project by typing " I know MySQL" at the beginning of your message so that I know you have read it.

Kemahiran: MySQL, Linux, Apache, PHP, Pentadbiran Pangkalan Data

Tentang Klien:
( 30 ulasan ) East Waterford, United States

ID Projek: #34435781