I've got the following output of the free -m command screenshot
So as far as I understand, 6501MB is available for using. The problem is that I have a cron job executing some SQL and I've noticed that if the job takes more memory then the "free" value in the first line (1154 mb), the sql server crashes. Why does that happen if it should be 6.5 GB available?
ps the first line free value was about 500 MB before, I've decreased the mysql innodb buffer pool size and it's became 1200. So apparently the job had taken more then 500 mb when the crash happened. Anyway that fact is that is seems that the job can only use the free mem from the first line, if it's insufficient, the job crashes.
Could you guys help me please?