Skip navigation links

MySQL Forums :: Performance :: Poor performance of MySQL 5.5


Advanced Search

Re: Poor performance of MySQL 5.5
Posted by: Matteo Canella ()
Date: June 09, 2011 05:36AM

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

Options: ReplyQuote


Subject Views Written By Posted
Poor performance of MySQL 5.5 7797 Matteo Canella 05/23/2011 04:43AM
Re: Poor performance of MySQL 5.5 2835 Rick James 05/24/2011 08:14AM
Re: Poor performance of MySQL 5.5 3080 Matteo Canella 05/25/2011 04:10AM
Re: Poor performance of MySQL 5.5 3208 Rick James 05/25/2011 10:40AM
Re: Poor performance of MySQL 5.5 2082 Merlotti Nicola 05/31/2011 07:15AM
Re: Poor performance of MySQL 5.5 1808 Rick James 05/31/2011 09:03AM
Re: Poor performance of MySQL 5.5 1621 Matteo Canella 05/31/2011 11:15AM
Re: Poor performance of MySQL 5.5 2141 Matteo Canella 06/03/2011 01:44AM
Re: Poor performance of MySQL 5.5 1318 Matteo Canella 06/03/2011 02:20AM
Re: Poor performance of MySQL 5.5 2168 Rick James 06/03/2011 09:33AM
Re: Poor performance of MySQL 5.5 1651 Nicola Merlotti 06/03/2011 11:25AM
Re: Poor performance of MySQL 5.5 2492 Matteo Canella 06/09/2011 05:36AM
Re: Poor performance of MySQL 5.5 1464 Nicola Merlotti 06/03/2011 11:38AM
Re: Poor performance of MySQL 5.5 1278 Rick James 06/03/2011 07:13PM
Re: Poor performance of MySQL 5.5 1196 Vladislav Vaintroub 06/11/2011 07:30PM
Re: Poor performance of MySQL 5.5 1088 Vladislav Vaintroub 06/11/2011 07:32PM
Re: Poor performance of MySQL 5.5 1373 Matteo Canella 06/12/2011 10:09AM
Re: Poor performance of MySQL 5.5 1142 Jerry Richart 06/15/2011 01:08PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.