- 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
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!
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,
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