[BliNeR-KeY]

Originally Posted by Dave

Do you have a slow query log? Refer to https://rtcamp.com/tutorials/mysql/slow-query-log/ for more information on how to configure it. Then just look for the /var/log/mysql/mysql-slow.log file.

ADD Oo my cfg.

dhis is my.cnf

[client]
port		= 3306
socket		= /var/run/mysqld/mysqld.sock





[mysqld_safe]
socket		= /var/run/mysqld/mysqld.sock
nice		= 0

[mysqld]



user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir		= /usr
datadir = /var/lib/mysql
tmpdir		= /tmp
lc-messages-dir	= /usr/share/mysql
skip-external-locking



bind-address = 127.0.0.1



key_buffer = 384M
max_allowed_packet = 2G
thread_cache_size = 8


myisam-recover         = BACKUP






query_cache_limit	= 1M
query_cache_size = 32M





















expire_logs_days	= 10
max_binlog_size         = 100M
innodb_file_per_table = 1
thread_concurrency = 8
myisam_sort_buffer_size = 64M
read_rnd_buffer_size = 8M
read_buffer_size = 2M
sort_buffer_size = 2M
table_cache = 512
big-tables





slow-query-log = 1
slow-query-log-file = /var/log/mysql/mysql-slow.log
long_query_time = 1
log-queries-not-using-indexes















[mysqldump]
quick
quote-names
max_allowed_packet	= 1073741824

[mysql]


[isamchk]
key_buffer = 256M
write_buffer = 2M
read_buffer = 2M
sort_buffer_size = 256M





!includedir /etc/mysql/conf.d/

dhis is my log 5-10 min. pls download

pls check my.cnf is set good or problem with my.cnf