Re: Poor performance of MySQL 5.5

[Matteo Canella]

Now the server is very fast.

I installed MySQL 5.6
I turned off query_cache_size.
I turned off HT and NUMA.
I have examined the slow queries and I added a few indexes on some tables that needed them.

The total workload of processors is very low.

I think the problem is resolved.

I thank all those who have spoken in this forum.
Placed below the final configuration, if I can improve anything let me know.



[client]
port=3306
[mysql]
default-character-set=latin1
[mysqld]
port=3306
basedir="C:/Program Files/MySQL/MySQL Server 5.6/"
datadir="D:/MySQLDataFiles/Data/"
character-set-server=latin1
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=800
query_cache_size = 0K
table_cache=1520
tmp_table_size=125M
thread_cache_size=38
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=125M
key_buffer_size = 10M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_data_home_dir="D:/MySQLDataFiles/"
innodb_additional_mem_pool_size=32M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=16M
innodb_buffer_pool_size=2G
innodb_log_file_size=407M
innodb_thread_concurrency=34
query_cache_type = off
performance_schema = off
slow-query-log
long_query_time = 1
log-error = "D:/MySQLLog/Error/Error.log"
slow_query_log_file = "D:/MySQLLog/SlowQuery/SlowQuery.log"
skip-name-resolve