On Mon, 09 Apr 2012 11:47:01 +0200 Reindl Harald <h.rei...@thelounge.net> 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql