On Tue, 10 Apr 2012 12:24:47 +0100 "Karl E. Jorgensen" <[email protected]> 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. -- To UNSUBSCRIBE, email to [email protected] with a subject of "unsubscribe". Trouble? Contact [email protected] Archive: http://lists.debian.org/[email protected]
