MySQL Forums
Forum List  »  Performance

Max connections blocked lower than max_connections is set
Posted by: Adam Reynolds
Date: February 15, 2005 09:21AM

We are having an issue whereby our max_connections is set to 1500 but the database refuses to allow more than 1020 (probably 1024) connections.

We have tested several configurations on another server and have determined that removing the key_buffer line from my.cnf resolves the problem and allows 1500 connections. Putting it back reduces the maximum connections to 1020.

However we have only noticed this issue on a server running Red Hat Enterprise 3. Another server running the same version of MySQL (3.23.57) but installed with Red Hat 9 is OK.

In summary

RHE3 - key_buffer=1024M, max connections=1020
RH9 - key_buffer=1024M, max connections=1500
RHE3 - key_buffer=301M, max connections=1476
RHE3 - key_buffer=300M (or below), max connections=1500
RHE3 - key_buffer removed, max connections=1500

We have been running 1024M on another server for a long while with no problems.

Any ideas gratefully received

Options: ReplyQuote

Written By
Max connections blocked lower than max_connections is set
February 15, 2005 09:21AM

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.