[ Date Index ]
[ Thread Index ]
[ <= Previous by date /
thread ]
[ Next by date /
thread => ]
[LUG] msql tweaks
- To: "list@xxxxxxxxxxxxx" <list@xxxxxxxxxxxxx>
- Subject: [LUG] msql tweaks
- From: Matt Stevenson <mrmstevenson@xxxxxxxxx>
- Date: Tue, 15 Sep 2015 13:44:31 +0100
- Delivered-to: dclug@xxxxxxxxxxxxxxxxxxxxx
- Dkim-signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=dcglug.org.uk; s=1428397562; h=Sender:Content-Type:List-Subscribe:List-Help:List-Post:List-Unsubscribe:List-Id:Reply-To:Subject:To:From:Message-ID:Date:MIME-Version; bh=KeG30T8i9EAXcvjl3yPFPC+Gqi/mQsz27EwLGy3riqc=; b=kCVhIJhd4pAg8UTdTvSmF/YNkGmGpeW7sluTk8PiJGpwsadsCXPm+j5fa0W8fHdE2ByjfiTtwSCterQJVSrR3LMkxjV1jPLu9Jy+ENxPeIbnv19eDkyJooBHSPjhTL3C3sCjSR7Oit5HcVXG+hVgGXruNtLSYrTevDu3OpyrxOY=;
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=HcDZst4ERt1Xxsc/y66sumAQ5HCWd6pJM2z9PnU/cJw=; b=tSby2ooOkdhVTbv/yk11kjLqtyuZT/DYjyBwfsr2Ch/Qtfjq2XLJeAnMl09bDcvKby oBOypLc2l9J+Ns2UjI3+GGN/z+iB0GNcqR6GXpfyCGoMFqY4pM+FCelbUCbfjlX6E0a7 wpyOZQfLDZOm8okdyccXpZPlS8KMTColAk92ITjNASLbu/8hNroOJCh0q/Prf1aEWGLB G461WsDv0eDrpyAo+Y0l3eowa5DMhbYIqlp/2aQgFenIuNcmtyUR7f7Aeht30g+GQQ/i UCmQ4nIEf8YccMuPlzHqfIJoYfnsLnVlaD6unJRAE15AGaRvIuvauaHQoyvNEA5d0xGM qlXA==
Hi
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% +
Just thought Iâd ask before doing any tweaks.
Regards
Matt
--
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/listfaq
