MySQL Forums
Forum List  »  Performance

Re: Mysql : Completely strange performance behavior
Posted by: Rick James
Date: March 01, 2013 08:41PM

> Our plan was to plug the new beast as a slave of our current master to watch how it behaved.

That's a good first step.

> If we install Mysql server 5.5 with default cnf

No. Tune it.
http://mysql.rjweb.org/doc.php/memory

> How on earth slave state can increase performance 10x ?

Caching. (mainly key_buffer_size)

Jørgen, did you create a new login? Or did something get mangled with your name?

> restarting Mysql lead to bad perf. again.

Cold cache. 10x slowdown is typical.

> Strange isn't it ?

No. "Count the disk hits". (Once you understand how MySQL's caching works.)

> Maybe becoming slave influenced its execution plan ?

Many things can influence the EXPLAIN; sometimes even the phase of the moon. (OK, not literally.)

Options: ReplyQuote




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.