MariaDB open_file limit can be increased ?
During past weeks I had several crashes in my server. When I contacted the support guys, they told me the open_files limit was exceeded for my MariaDB database server. Right now they have increased the open_files to 8000. Just for my confirmation I tested the open_files status,
Code:
show global status like 'open_files'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | Open_files | 2145 | +---------------+-------+ 1 row in set (0.00 sec)
My questions are..
1. Is there any relation between processlist and openfiles?
2. Can higher number of open_file cause issue to server stability?
3. What is the reason for the open_file value to get increased?
Thanks in advacne.