List:General Discussion« Previous MessageNext Message »
From:"J. Bakshi" <joydeep.bakshi Date:April 9 2012 9:56am
Subject:Re: Remote mysql too slow
View as plain text  
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
Thread
Remote mysql too slowJ. Bakshi9 Apr
  • Re: Remote mysql too slowReindl Harald9 Apr
    • Re: Remote mysql too slowJ. Bakshi9 Apr
      • Re: Remote mysql too slowReindl Harald9 Apr
        • Re: Remote mysql too slowJ. Bakshi9 Apr
          • Re: Remote mysql too slowReindl Harald9 Apr
            • Re: Remote mysql too slowJ. Bakshi9 Apr
  • Re: Remote mysql too slowJohnny Withers9 Apr
    • Re: Remote mysql too slowNoel Butler9 Apr