number of opened tables is increasing rapidly after sometime.
MariaDB [(none)]> show global status like 'open%';
+--------------------------+--------+
| Variable_name | Value |
+--------------------------+--------+
| Open_files | 6 |
| Open_streams | 0 |
| Open_table_definitions | 1200 |
| Open_tables | 1200 |
| Opened_files | 791203 |
| Opened_plugin_libraries | 0 |
| Opened_table_definitions | 788523 |
| Opened_tables | 807692 |
| Opened_views | 0 |
+--------------------------+--------+
9 rows in set (0.00 sec)
MariaDB [(none)]> show global status like 'up%';
+---------------------------+-------+
| Variable_name | Value |
+---------------------------+-------+
| Update_scan | 200 |
| Uptime | 2028 |
| Uptime_since_flush_status | 2028 |
how global status like '%conn%';
+-----------------------------------------------+-------+
| Variable_name | Value |
+-----------------------------------------------+-------+
| Aborted_connects | 2 |
| Connection_errors_accept | 0 |
| Connection_errors_internal | 0 |
| Connection_errors_max_connections | 0 |
| Connection_errors_peer_address | 0 |
| Connection_errors_select | 0 |
| Connection_errors_tcpwrap | 0 |
| Connections | 151 |
| Max_used_connections | 13 |
| Performance_schema_session_connect_attrs_lost | 0 |
| Slave_connections | 0 |
| Slaves_connected | 0 |
| Ssl_client_connects | 0 |
| Ssl_connect_renegotiates | 0 |
| Ssl_finished_connects | 0 |
| Threads_connected | 12 |
| wsrep_connected | OFF |
+-----------------------------------------------+-------+
select count(*) from information_schema.tables;
+----------+
| count(*) |
+----------+
| 1986 |
+----------+
Can anyone suggest how to investigate why the opened tables count is increasing so rapidly and how to resolve this issue?