Announcement

Announcement Module
Collapse
No announcement yet.

max connection

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • max connection

    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,

  • #2
    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.

    Comment


    • #3
      Hello,

      web application, but 100 is not absolute enough.

      regards,

      Comment


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

        Comment


        • #5
          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,

          Comment


          • #6
            Yes you can easily increase that to more. But again, you don't want that.

            Comment


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

              Comment

              Working...
              X