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
