Re: Improuve my DB performances on server
Some things to think about ...
15 full table scans/sec is a lot with everything else that's going on. You need to look at those queries with Explain. Post the Explain result with Show Create Table for each.
116 queries/sec on a box that's also servicing 100 Java connections is getting busy. Have you considered moving the db to a dedicated local *Nix server?
Seems to be rotating InnoDB logs too often, have you tried growing Innodb log file size?
Subject
Written By
Posted
Re: Improuve my DB performances on server
June 09, 2014 04:49PM
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.