MySQL Forums
Forum List  »  General

max_open_files error
Posted by: mysql
Date: August 15, 2006 03:53PM

I have 4 mysql servers running the same OS (centos 4.2) and the same mysql version (5.0.24). However, 1 server gives the following warning:
Changed limits: max_open_files: 1024 max_connections: 1014 table_cache: 64
and will not have more than 1014 max connections. Is this a bug or a linux issue? I need more connections for this server.

The only difference, this server is running selinux, whereas the other are not. The my.cnf is getting read in and all other features and functions appear to be working fine.

I was also getting the same issue when running MySQL ver 4.2.

Any direction would be appreciated.

This conf file works fine on the other servers:
[mysqld]
socket=/var/lib/mysql/mysql.sock
datadir=/var/lib/mysql

key_buffer = 256M
max_allowed_packet = 8M
table_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size= 16M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
max_connections = 2500

skip-slave-start
log-bin
server-id = 323
master-host = 10.0.3.13
master-user = ***
master-password = ***

[mysql.server]
user=mysql

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Is this the right post for discussing such an issue?

Thanks!

Options: ReplyQuote


Subject
Written By
Posted
max_open_files error
August 15, 2006 03:53PM
April 24, 2009 12:09PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.