Thank you all for your replies... @Reindl thanks for pointing that out. Now, reading again the output of free -m and knowing that tokudb will try to get much as 50% of the server's memory, I will surely need to tweak some values since free + cached memory doesn't meet the need [root@db ~]# free -m total used free shared buffers cached Mem: 7840 7793 47 0 23 3572 -/+ buffers/cache: 4197 3642 Swap: 2047 1494 553 I will work on tweaking the tokudb_cache_size and the innodb_buffer_pool_size parameters, I will let you know from there. Thank you On Tue, Mar 3, 2015 at 6:47 PM, Reindl Harald <h.reindl@thelounge.net> wrote:
Am 03.03.2015 um 22:26 schrieb Gabriel Sosa:
using systemtap I got
[Tue Mar 3 18:48:46 2015] SIGKILL was sent to ps (pid:9763) by processes uid:0 [Tue Mar 3 18:49:46 2015] SIGKILL was sent to ps (pid:9824) by processes uid:0 *[Tue Mar 3 18:50:44 2015] SIGKILL was sent to mysqld (pid:7597) by mysqld uid:498* [Tue Mar 3 18:50:46 2015] SIGKILL was sent to ps (pid:9890) by processes uid:0 [Tue Mar 3 18:51:46 2015] SIGKILL was sent to ps (pid:9997) by processes uid:0 [Tue Mar 3 18:52:35 2015] SIGKILL was sent to cdm (pid:10045) by cdm uid:0
I saw this several times but I wasn't able to find (in this case) which process has the PID 498. @jocelyn, you are right...to tweaks at all for tokudb (my bad here), although I wasn't expecting such /naive/ approach, I mean, I could have not enable the tokudb plugin and all other tables using the other engines would work just fine (maybe just slow though)
free -m returns about 47M free...which isn't much...
you need to learn read the output
it don't matter how much is free, what matters is if the allocated memory is used, shared, buffers or even cache - cache don't matter because it is re-used if a application requests memory
until that happens a sane OS is using *100 %* of the available memory for caching - that below don't mean there are only 577 MB free, i can with no issue start a application requesting 4 GB ram because the 11086 MB cache can be re-used at every moment in time
[root@srv-rhsoft:~]$ free -m total used free shared buffers cached Mem: 15923 15345 577 239 1020 11086 -/+ buffers/cache: 3238 12684 Swap: 3025 6 3018
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
-- Gabriel Sosa Sometimes the questions are complicated and the answers are simple. -- Dr. Seuss