Comment 4 for bug 1170103

Revision history for this message
Valerii Kravchuk (valerii-kravchuk) wrote : Re: Possible memory leak in Percona Server 5.5.30-30.2

Based on these:

Connections 92344
Created_tmp_disk_tables 147778
Created_tmp_tables 464737
Uptime_since_flush_status 16608

6 connections per second is made to your system, in average:

mysql> select 92334/16608;
+-------------+
| 92334/16608 |
+-------------+
| 5.5596 |
+-------------+
1 row in set (0.67 sec)

up to 200+ of them runs concurrently:

Max_used_connections 203

and they use temporary tables a lot, 28 per second:

mysql> select 464737/16608;
+--------------+
| 464737/16608 |
+--------------+
| 27.9827 |
+--------------+
1 row in set (0.00 sec)

and even while you let them to be up to 500M in memory, some seems too big and are created on disk:

mysql> select 147778/16608;
+--------------+
| 147778/16608 |
+--------------+
| 8.8980 |
+--------------+
1 row in set (0.00 sec)

9 per second, in average.

So, I'd say up to 8G of memory could easily be used by implicit temporary tables only. Is this enough to explain OOM in your case?

Please, send the output of:

free
ps aux | grep mysqld

also.