MySQL Forums :: General :: max_open_files error


Advanced Search

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 mysql 08/15/2006 03:53PM
Re: max_open_files error amit varde 04/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.