On Tue, 10 Apr 2012 12:24:47 +0100 "Karl E. Jorgensen" <karl.jorgen...@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. -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/20120411103641.192bd...@shiva.selfip.org
