Sadece hata veren satırları ekleyeceğim buraya, çözümü için birşeyler denedim fakat düzelmediler. Sorunum CPU %150lerde oluyor ve işlem bitince de düşmüyor
SLOW QUERIES
The slow query log is
NOT enabled.
Current long_query_time = 2.000000 sec.
You have
0 out of
570998 that take longer than 2.000000 sec. to complete
Your long_query_time seems to be fine
BINARY UPDATE LOG
The binary update log is
NOT enabled.
You will not be able to do point in time recovery
See
http://dev.mysql.com/doc/refman/10.3...-recovery.html MAX CONNECTIONS
Current max_connections = 151
Current threads_connected = 2
Historic max_used_connections = 6
The number of used connections is
3% of the configured maximum.
You are using less than 10% of your configured max_connections. Lowering max_connections could help to avoid an over-allocation of memory See "MEMORY USAGE" section to make sure you are not over-allocating No InnoDB Support Enabled! QUERY CACHE
Query cache is enabled
Current query_cache_size = 16 M
Current query_cache_used = 403 K
Current query_cache_limit = 1 M
Current Query cache Memory fill ratio = 2.46 %
Current query_cache_min_res_unit = 2 K
Query Cache is 23 % fragmented
Run "FLUSH QUERY CACHE" periodically to defragment the query cache memory If you have many small queries lower 'query_cache_min_res_unit' to reduce fragmentation. Your query_cache_size seems to be too high. Perhaps you can use these resources elsewhere MySQL won't cache query results that are larger than query_cache_limit in size