max connection

Hello,

I have mySQL server over OS: Linux, CPU: AMD Athlon™ XP 1800+, RAM: 768 MB, HDD: ST340014A / 7200 rpm.

How much is max value on max_connection, because 100 is not enough.

regards,

Depends on the purpose. For a web application, 100 connections is more than you will ever need. For applications that keep an active connection it might not be enough.

Hello,

web application, but 100 is not absolute enough.

regards,

Then optimization should be your objective rather than increasing the max connections.

Hello,

What have for optimization? I have only 1 insert in script.

Problem is that application that make http request make more from 100 in sec… cool:

Can someone to say me is possible to increase max_connection with this parameters on server.

regards,

Yes you can easily increase that to more. But again, you don’t want that.

This will help you
http://www.omh.cc/mycnf/