maria-discuss team mailing list archive

[Gabriel Sosa <sosagabriel@xxxxxxxxx>]

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@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxxxxxxxx
> 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