[ Date Index ]
[ Thread Index ]
[ <= Previous by date /
thread ]
[ Next by date /
thread => ]
Re: [LUG] msql tweaks
- To: "list@xxxxxxxxxxxxx" <list@xxxxxxxxxxxxx>
- Subject: Re: [LUG] msql tweaks
- From: Matt Stevenson <mrmstevenson@xxxxxxxxx>
- Date: Tue, 15 Sep 2015 14:38:33 +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:References:In-Reply-To:MIME-Version; bh=mgM7acOXzg/RvJgGxSeLcxnVojKCDmmeHuuBBrpiQ/o=; b=kalfbtYg38G7vXqU5x1eZiVSPEHfSmZUsHXl8kSUuBJARobzrniVdVzEjHY/svFyXllM6N62fi+5ecoh8Ap7Gc18hlo0Q/GlfxgUuluvPF3j7uFylhPrNOsHnZ5Jg4jFgNW8T5yfyiVjOrZwFmaIRdT8A5J0NpDawHG+1yvXQgw=;
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=NiePdugRyS6qvgQX+9aly7/bYr5LN2Q+WB7CAXX/nwk=; b=V3c6fzlfYWII6wb+hYp99Rh+EbL3DqtfZCIyDTicvbFJ15abUSyVH8NvWPxbGcyeLj rAvfZ14ILlExtrQbOOu5e+o6ZdlIanvptsjh94K5ZwDWuvsqNl6a3lY6v8VLVtYc1jqc SzqtwUaoN9JlHFgk2vtvhcWI2MhVEVasiHul7U6FnIiGYESu3hxCrI6ozdVQl2P22g/T JGDS6Di6iqODYjsEhbZ+r1b8mZ4XQYJL++18FtqM5Uk+a7mEmu1DzUo7qOh/iQZ4KeEF iJsxbY2lvOCw2y46OUAF64gCSrAugo8Ds2J4YcIUsFkzzbBj97jfaICd8q6AstgYBgNq ygtQ==
Hi Stinga
Your signature :-D impressive, and thanks for the tip Iâll watch those developers for sure.
On Tuesday, September 15, 2015, stinga <stinga+dcglug@xxxxxxxxxxxxx> wrote:
> 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
>
--
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/listfaq
