Important: This page is using cookies (cookies). Using this website without turning off cookies in browser, means that you agree for using it.
Buy Now! Features Downloads

Earn with us!

If you would like to start earning money with vBET join to Affiliate Program.
Results 1 to 4 of 4

Thread: Fall Connection

  1. #1
    Member
    Join Date
    Dec 2009
    Posts
    51

    Default Fall Connection

    Text automatically translated from: Italian to: English
    Translated text
    I still have many connection errors drop with this message:

    mysql_connect () [function.mysql-connect <a href='function.mysql-connect'> </ a>]: Too many connections
    / Home / school / domains / scuo.la / public_html / includes / class_core.php on line 311


    We have tried to disable the scheduled task to clean the cache, but the errors continued. Among the various threads I have a very long, it may be that, at the time of translation, the cause of everything?
    Original text

  2. #2
    Michał Podbielski (vBET Staff) vBET's Avatar
    Join Date
    Oct 2009
    Posts
    3,037

    Default

    Please change your mysql configuration and allow for more connections.

    Possible reasons:
    1. More traffic because of translated content.
    2. Translated content takes little more time to generate

    In booth cases main reason is that right now you have more concurrent users on your server. More that connections which you allow. So please set bigger amount of possible mysql connections, or set lower amount of apache threads (clients will wait in queue). 2nd solution will make your response time bigger.

    Please note that in case of PHP, mysql connections are automatically closed when request is served. vBET is not creating new connections if there is active one. So each opened connection means one request which is during evaluation. If you note that you have less active apache threads that opened connections then you can suspect something wrong. At this moment it is OK and it is only configuration issue. Please let us know if it appears to be something else.

  3. #3
    Member
    Join Date
    Dec 2009
    Posts
    51

    Default

    Text automatically translated from: Italian to: English
    Translated text
    which of these three values have to try to decrease?
    MinSpareThreads MaxSpareThreads ThreadsPerChild
    Original text

  4. #4
    Michał Podbielski (vBET Staff) vBET's Avatar
    Join Date
    Oct 2009
    Posts
    3,037

    Default

    Here is official mysql manual about 'too many connections' issue
    MySQL :: MySQL 5.1 Reference Manual :: B.5.2.7 Too many connections

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •