Antonio Fernández Pérez Doubts tuning MySQL Percona Server 5.5
Jul 04, 2014; 20:00
Antonio Fernández Pérez
Doubts tuning MySQL Percona Server 5.5
Hi list,
I have some doubts adjusting some MySQL variables. ? I have checked MySQL status and maybe I should to increase some variables ....
For example: InnoDB log waits is 103; innodb_log_buffer_size is 8M --> Maybe the next best value could be 16M? Table cache hit rate is 12%; Open_tables is 627; table_open_cache is 1024 --> Maybe the next best value could be 2048? Key buffer hit rate is 93.7%; I have some queries that not using indexes .. join_buffer_size is 4M --> Next best value? Maybe 8M and then check it again?
That's all.
I hope your advices.
Regards,
Antonio.
Jul 05
Johan De Meersman Re: Doubts tuning MySQL Percona Server 5.5
Jul 05, 2014; 23:16
Johan De Meersman
Re: Doubts tuning MySQL Percona Server 5.5
Jul 07
Antonio Fernández Pérez Re: Doubts tuning MySQL Percona Server 5.5
Jul 07, 2014; 08:18
Antonio Fernández Pérez
Re: Doubts tuning MySQL Percona Server 5.5
Jul 07
Johan De Meersman Re: Doubts tuning MySQL Percona Server 5.5
Jul 07, 2014; 13:49
Johan De Meersman
Re: Doubts tuning MySQL Percona Server 5.5
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!