Bug 1031750 - mysqld: max_connections reset to 214
mysqld: max_connections reset to 214
Status: CLOSED NOTABUG
Product: Fedora
Classification: Fedora
Component: mysql (Show other bugs)
18
Unspecified Unspecified
unspecified Severity unspecified
: ---
: ---
Assigned To: Honza Horak
Fedora Extras Quality Assurance
:
Depends On:
Blocks:
  Show dependency treegraph
 
Reported: 2013-11-18 12:02 EST by customercare
Modified: 2013-11-18 12:16 EST (History)
2 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2013-11-18 12:16:13 EST
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)

  None (edit)
Description customercare 2013-11-18 12:02:46 EST
Description of problem:

If the initial max_connections value inside my.cnf is too big,
mysql reverts to a fixed not helping default.

131118 17:45:58 [Warning] Changed limits: max_open_files: 1024  max_connections: 214  table_cache: 400

Version-Release number of selected component (if applicable):

mysql  Ver 14.14 Distrib 5.5.34, for Linux (i686) using readline 5.1

How reproducible:

Always.

Steps to Reproduce:

1.

my.cnf:

[mysqld]
...
max_connections = 2000
...

-------------------------------------------------
/etc/systemd/system/mysqld.service:

.include /usr/lib/systemd/system/mysqld.service
[Service]
LimitNOFILE=1000000

Actual results:

214 connections:

131118 17:45:58 [Warning] Changed limits: max_open_files: 1024  max_connections: 214  table_cache: 400


Expected results:

2000 connections.

################# Additional :

With max_connections=700 it's working.

This means to me, the systemd service file addition:

LimitNOFILE=1000000

does not have any effect. 

BTW: 

why isn't it possible to set more than 1 million open files  i.e. unlimited ?
Comment 1 customercare 2013-11-18 12:16:13 EST
My fault , sorry:

"systemctl daemon-reload" was missing.

Note You need to log in before you can comment on or make changes to this bug.