MariaDB Does the performance bug for table_cache exist on the MariaDB that Centmimod uses?

Best to ask MariaDB folks about the internals but that bug as updated patch further down the page and explains it in detail and it's only MyISAM table specific and does NOT affect InnoDB tables. Best to test for yourself and see where your optimal table_open_cache number is at for your specific database table size and work load. How you test is also left up to you. Centmin Mod by default raises MySQL max open file limits to 65536 compared to default 1024 so to be able to handle more open tables as well.

The percona blog comments by Rick James suggest MySQL 5.6.8 didn't have the patch so could be either later MySQL >5.6.8 added it or they had different work arounds in code to fix it or they haven't patched it yet.

However, Percona 5.1,5.5 and 5.6 have committed the patch i think https://bugs.launchpad.net/percona-server/ bug/1038940 so there's a chance MariaDB which takes some code from Percona has it too. Diffs for Percona 5.5 https://i132250861.restricted.launc...22.txt?token=d537f0e29e608a429fb658539d3d2f67 and Percona 5.6 https://i132267832.restricted.launc...22.txt?token=fdc553ba35b0b621e8be1b0fed9cc215

http://lists.mysql.com/commits/121507

 

line 26 and 27 of https://github.com/centminmod/centminmod/blob/master/inc/nginx_install.inc#L27 sets it. Forgot I raised the limit in .07 from 65536 to 262144

The default in /etc/my.cnf is set artificially lower though at open_files_limit=8192 but can be raised to 262144 if need be due to my tweaks

Max open files = 8192 set in /etc/my.cnf

checking to see if that's the case

Code:

mysqladmin var | tr -s ' ' | grep open_files_limit
| open_files_limit | 8192 |

Code:

cat /proc/$(cat /var/lib/mysql/*.pid)/limits

Limit                     Soft Limit           Hard Limit           Units 
Max cpu time              unlimited            unlimited            seconds
Max file size             unlimited            unlimited            bytes 
Max data size             unlimited            unlimited            bytes 
Max stack size            524288               524288               bytes 
Max core file size        0                    unlimited            bytes 
Max resident set          unlimited            unlimited            bytes 
Max processes             3094211              3094211              processes
Max open files            8192                 8192                 files 
Max locked memory         65536                65536                bytes 
Max address space         unlimited            unlimited            bytes 
Max file locks            unlimited            unlimited            locks 
Max pending signals       3094211              3094211              signals
Max msgqueue size         819200               819200               bytes 
Max nice priority         0                    0                
Max realtime priority     0                    0                
Max realtime timeout      unlimited            unlimited            us    

 

no need to increase leave as is