The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

New /tmp folder fails...

Discussion in 'cPanel Developers' started by schoeps, Apr 15, 2008.

  1. schoeps

    schoeps Well-Known Member

    Joined:
    Sep 22, 2004
    Messages:
    51
    Likes Received:
    0
    Trophy Points:
    6
    can someone please report this to bugzilla? I dont have the infos...

    It seems with a fresh WHM install, a /tmp mount point is created at 250 megs or so. Problem is that mysql is defaulted to that area to do operations like "repair" or "optimize". Therefore, if you db > than 250 megs, you will fill the tmp folder, which will never empty. If the database is bieng accessed by users, they will be held as "waiting". If you have a big site, they will gobble up all your sql connections. Since this problem does not resolve itself, you need to force it closed, marking the db as unusable since its flagged for repair. I think the old WHM used to just use the disk, no temp area.

    so if you have a big DB, up the size of that temp file or pay the price ;)

    Bri
     
  2. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    This loopback temp mount is only created if /tmp or /var/tmp is not already a separate partition.

    MySQL can also be configured to use a different location than /tmp or /var/tmp. Please read http://dev.mysql.com/doc/refman/5.0/en/temporary-files.html for details.
     
Loading...

Share This Page