• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login

MySQL connections problem

Scheduled Pinned Locked Moved
FOG Problems
2
2
1.2k
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • F
    frank8290
    last edited by Aug 24, 2012, 8:12 PM

    [INDENT][SIZE=2]I know we aren’t supposed to cross post, but my last thread was [/SIZE]buried[SIZE=2] by spam.[/SIZE][/INDENT]
    [INDENT]We have a main fog server and 9 storage nodes distributed across our school district. Recently we started getting “unable to connect to database” errors on the web interface. I determined the cause of this was that we were maxing out our connection to the MySQL database, so i increased it from 150 to 350 max connections, and we maxed that out too. I have now increased it to 500 max connections, but i am wondering if this is normal. How many connection per storage node should i expect?

    It takes a while for the connections to increase, so im also wondering if there could be a problem with the connections not closing like they should. If anyone has a few storage nodes I would like to know how many connections you have to your database at any give time after running for a few days.

    Thank you,

    -Frank[/INDENT]

    1 Reply Last reply Reply Quote 0
    • C
      chad-bisd Moderator
      last edited by Aug 28, 2012, 5:26 AM

      SPAM was removed. Please revert to your other post in General. Thanks.


      If you would like to make a donation to the Fog project, please do so [U][COLOR=#0000ff][URL='http://sourceforge.net/dona…

      1 Reply Last reply Reply Quote 0
      • 1 / 1
      1 / 1
      • First post
        2/2
        Last post

      143

      Online

      12.0k

      Users

      17.3k

      Topics

      155.2k

      Posts
      Copyright © 2012-2024 FOG Project