From c1bbd2a6e6cd20b983027ac25dea1316c666737d Mon Sep 17 00:00:00 2001
From: Silvio Rhatto <rhatto@riseup.net>
Date: Wed, 15 Aug 2012 19:20:56 -0300
Subject: Fixing Out of Resource Problem with MySQL (Errcode: 24) (2)

---
 manifests/subsystems/database.pp | 10 ++++++++++
 1 file changed, 10 insertions(+)

diff --git a/manifests/subsystems/database.pp b/manifests/subsystems/database.pp
index 7b5398f..f5ae446 100644
--- a/manifests/subsystems/database.pp
+++ b/manifests/subsystems/database.pp
@@ -10,6 +10,16 @@ class database {
     content => "mysql soft nofile 24000\nmysql hard nofile 32000\n",
   }
 
+  # Avoid Errcode: 24
+  file { '/etc/mysql/conf.d/mysqld_open_files_limit.cnf':
+    ensure  => present,
+    owner   => root,
+    group   => root,
+    mode    => 0644,
+    content => "[mysqld]\nopen-files-limit = 5000\n",
+    notify  => Service['mysql'],
+  }
+
   # Database definitions
   define instance($password, $ensure = 'present', $privileges = 'all') {
     mysql_database { "$name":
-- 
cgit v1.2.3