MySQL memory usage

tanveer · 12-20-2015, 10:58 PM

Hi all,

I am running a mySQL database version 5.6 and the system has 128GB ram in it. it has 8GB of swap space.

Now mySQL seems like eaten up 5G of swap out of 8G. Is there any query which will show which table/query might ate that and not releasing.
In what cases mySQL tends to use swap space even though so much RAM is available.

btw, tmp_table_size is not set.

Thanks in advance.

aizkorri · 12-21-2015, 08:25 AM

How is your my.cnf file configured?

You might have to reduce "max_connections", sometimes it is not a table but the connection pool that is eating memory.

tanveer · 12-21-2015, 08:13 PM

how to find that out that connection pool is eating memory?

I know mysql is using swap but need to find out how its using that and where its getting located/allocated.

will try max_connection by reducing.

aizkorri · 12-22-2015, 08:42 AM

check also:
http://www.tocker.ca/2014/03/10/conf...al-memory.html

tanveer · 12-23-2015, 08:17 PM

Thanks all for replying .

chrism01 · 12-23-2015, 10:50 PM

It might also be worth a quick look into https://dev.mysql.com/doc/refman/5.7...query-log.html