Mysql/Maria DB – Too many open files

Solution how to fix following error generated in /var/log/syslog by mysqld service on Ubuntu 16.04 with MariaDB 10.0.x:

If you see message above you probably reached default limits of mysqld service. To set open files parameter limit as unlimited, follow steps below:

  • Login as root:
  • Modify /etc/security/limits.conf:
  • And set mysql soft and hard limit for nofiles:
  • Save modified limits.conf and Reboot system:
  • Create mysql.service.d folder to customize startup parameters and create limits.conf file:
  • Into limits.conf insert following:
  • Save file and restart mysqld service:
  • Check new limits of mysqld process:
  • Desired state after change:
  • By default mariadb has following:

 

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: