Re: remote mysql is too slow

["J. Bakshi" <bakshi12@gmail.com>]

On Tue, 10 Apr 2012 12:24:47 +0100
"Karl E. Jorgensen" <karl.jorgensen@nice.com> wrote:

<snap>

>
> > 
> > > # free -m
> > >              total       used       free     shared    buffers     cached
> > > Mem:          7986       7913         73          0        224       6133
> > > -/+ buffers/cache:       1554       6431
> > > Swap:         3813          0       3813
> > 
> > Shows 8G of ram.  Good.  Shows no swap used.  Also good.  (But not
> > necessarily bad if some swap is used.  So if you see some swap being
> > used that isn't necessarily a problem.)
> 
</snap>

> 
> Mostly good. Yes. But 6133 Mb Cached is not what I would expect - this
> indicates that the linux kernel is doing the caching - rather than
> MySQL. And the MySQL cache for this stuff is (almost) always more
> efficient.
> 
> If you use InnoDB tables, you can increase innodb_buffer_pool to e.g.
> 4Gb more.
> 

I did, but them mysqltuner warned me that the max memory usage is dangerously high
and I need to install more physical memory. So I reduce it to 2G.

> If are using MyISAM tables, increase key_buffer_size (affects caching of
> indexes) and probably others - I don't use MyISAM tables much...
> 

Yes, I have MyISAM tables. And provided 250M to key_buffer_size.