D&C GLug - Home Page

[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] msql tweaks

 

On 15/09/15 13:44, Matt Stevenson wrote:
For those DBA’s among this list, about performance tweaks with mySQL.
Do you manually edit /etc/my.cnf or use a tool like http://mysqltuner.com/

I am monitoring mySQL processes since upgrading to 5.6 and memory is 2GB and CPU increase crept up by 50% +

Have used scripts and then hand tweak.

Usually found it is better to look a the god awful code/db schemas the devs have come up with... :-) like missing indexes, or indexes on a million row column that is either Y or N or the smart dev who trys to everything in the DB... etc,etc.

--
'ooroo

Stinga...(:)-)
---------------------------------------------------
Email: stinga+dclug@xxxxxxxxxxxxx   o
You need only two tools.        o /////
A hammer and duct tape. If it    /@   `\  /) ~
doesn't move and it should use  >  (O)  X<  ~  Fish!!
the hammer. If it moves and      `\___/'  \) ~
shouldn't, use the tape.           \\\
---------------------------------------------------


--
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/listfaq