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.
Based on these:
Connections 92344 tmp_disk_ tables 147778 since_flush_ status 16608
Created_
Created_tmp_tables 464737
Uptime_
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.