Not the answer you need?
Register and ask your own question!

max connection

tonpettonpet EntrantCurrent User Role Beginner
Hello,

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

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

regards,

Comments

  • gmousegmouse Mod Squad Inactive User Role Beginner
    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.
  • tonpettonpet Entrant Current User Role Beginner
    Hello,

    web application, but 100 is not absolute enough.

    regards,
  • gmousegmouse Mod Squad Inactive User Role Beginner
    Then optimization should be your objective rather than increasing the max connections.
  • tonpettonpet Entrant Current User Role Beginner
    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,
  • gmousegmouse Mod Squad Inactive User Role Beginner
    Yes you can easily increase that to more. But again, you don't want that.
  • perconauserperconauser Contributor Current User Role Beginner
    This will help you
    http://www.omh.cc/mycnf/
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.