Merhaba aşağıdaki gibi kullanın bir. Ekstra olarakta slow query aktif edin. Birkaç gün sorun yaşatan sorguları takip edin.

Slow query için aşağıdaki kodu kullanıyorum. Birkaç gün sonra sonuçları alınca kaldırın

slow_query_log = 1
slow_query_log_file =/var/lib/mysql/mysql-slow.log
long_query_time = 5

[mysqld]
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-name-resolve
tmp_table_size = 512M
max_heap_table_size = 512M
table_open_cache = 5000
performance_schema = OFF
key_buffer_size = 512M
innodb_buffer_pool_size = 6G
innodb_log_file_size = 1G
innodb_buffer_pool_instances = 8
innodb_thread_concurrency = 0
innodb_read_io_threads = 8
innodb_write_io_threads = 8
innodb_io_capacity = 1000
max_connections = 500
max_allowed_packet = 128M
wait_timeout = 180
query_cache_type = 0
query_cache_size = 0
log_warnings = 2
log-error=/var/log/mariadb/mariadb.log
log_queries_not_using_indexes = 1
slow_query_log = 1
slow_query_log_file =/var/lib/mysql/mysql-slow.log
long_query_time = 5
symbolic-links = 0

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

!includedir /etc/my.cnf.d