From: "J. Bakshi" <joydeep.bakshi
Date: April 9 2012 9:56am
Subject: Re: Remote mysql too slow
List-Archive: http://lists.mysql.com/mysql/227146
Message-Id: <20120409152607.6c5d2189@shiva.selfip.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

On Mon, 09 Apr 2012 11:47:01 +0200
Reindl Harald <h.reindl@stripped> wrote:

> 
> 
> Am 09.04.2012 10:57, schrieb J. Bakshi:
> > 
> >  Hello,
> >  
> >  I have been provided a muscular linux server to use as a Mysql server
> >  in our organization. The server is located just beside the web server
> >  and within the same network. This dedicated server has 8GB RAM, i5 processors
> >  and running mysql as service. No apache, php ..... nothing. All resources are
> >  dedicated to mysql only.
> 
> generally this depends on your network connection
> and yow your queries are written
> 
> keep in mind that only connect has 15-20% overhead
> compared with a unix socket and if your network is
> too slow you notice latency more and more
> 
> additionally your queries have more impact
> if you have usually very small results by optimized queries
> this makles the db-server himslef possibly better suited
> but keep in mind taht your querie himself must over the wire
> 
> > I run the mysqltuner directly on the remote mysql server; and here is the
> > result
> 
> [OK] Key buffer size / total MyISAM indexes: 2.0G/268.5M
> [!!] InnoDB data size / buffer pool: 3.6G/8.0M
> 
> why are you wasting 2GB of RAM fpr key_buffer while
> your innodb_buffer_pool is way to small?
> ______________________
> 

Could you suggest the optimized settings ?

Thanks