Re: Doubts tuning MySQL Percona Server 5.5

2014-07-07 Thread Johan De Meersman
- Original Message - > From: "Antonio Fernández Pérez" > Subject: Re: Doubts tuning MySQL Percona Server 5.5 > ​I was checking MySQL performance ... Sometimes my database could be working > slow. I have some queries that spend 9-10 seconds updating some columns by

Re: Doubts tuning MySQL Percona Server 5.5

2014-07-06 Thread Antonio Fernández Pérez
​Hi, I was checking MySQL performance ... Sometimes my database could be working slow. I have some queries that spend 9-10 seconds updating some columns by primary key. I'm not sure if is a data base problem ... Moreover, I have checked tuning scripts and appear these variables. Good sentence!

Re: Doubts tuning MySQL Percona Server 5.5

2014-07-05 Thread Johan De Meersman
I'm missing something rather essential in your mail... are you actually experiencing performance problems, or are you just looking at variables and randomly deciding you don't like their value? Always remember the golden rule: if it ain't broken, don't fix it. On July 4, 2014 8:00:31 PM CEST,

Doubts tuning MySQL Percona Server 5.5

2014-07-04 Thread Antonio Fernández Pérez
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 62