Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

tmp folder 100% full

Discussion in 'General Discussion' started by blogmaster2003, May 4, 2010.

  1. blogmaster2003

    Joined:
    Sep 16, 2004
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    151
    Hi

    im running a dedicated server cent os 5 64bit with cpanel (latest release)

    Everyday my tmp folder is becoming full with several files:

    #sql_11f7_0.MYD
    #sql_11f7_0.MYI

    I think these files are temporary mysql files?

    So i think i should change some configuration in my temporary mysql folder?

    Or should i resize my tmp folder?

    Thank you
     
  2. blogmaster2003

    Joined:
    Sep 16, 2004
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    151
    Hi

    nobody can help me on this one?
     
  3. madaboutlinux

    madaboutlinux Well-Known Member

    Joined:
    Jan 24, 2005
    Messages:
    1,051
    Likes Received:
    2
    Trophy Points:
    168
    Location:
    Earth
    What is the size of /tmp directory?

    what is the size of the .MYI and .MYD files under /tmp?

    and were any changes made on the server since the files started creating under /tmp? what are the contents of /etc/my.cnf ?

    BTW, you cannot resize the existing partition unless it's a LVM partition which I am sure it is not. You have to create a virtual partition and mount the partition on /tmp.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. blogmaster2003

    Joined:
    Sep 16, 2004
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    151
    i already cleaned it, but i think tomorrow ill have more temp mysql files.

    Code:
    root@server1 [~/tmp]# df -h
    Filesystem            Size  Used Avail Use% Mounted on
    /dev/sda6             2.0G  475M  1.4G  26% /
    /dev/sda8             196G   12G  174G   7% /home
    /dev/sdb1             226G  5.6G  209G   3% /backup
    /dev/sda3             9.7G  4.2G  5.1G  45% /var
    /dev/sda2             9.7G  5.7G  3.5G  63% /usr
    /dev/sda1              99M   29M   65M  31% /boot
    tmpfs                 2.0G     0  2.0G   0% /dev/shm
    /usr/tmpDSK           2.0G   36M  1.8G   2% /tmp


    Code:
    root@server1 [~/tmp]# cat /etc/my.cnf
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    local-infile = 0
    skip-locking
    skip-bdb
    max_connections = 500
    key_buffer = 128M
    myisam_sort_buffer_size = 64M
    join_buffer_size = 1M
    read_buffer_size = 2M
    sort_buffer_size = 2M
    read_rnd_buffer_size = 2M
    table_cache = 1024
    record_buffer = 1M
    thread_cache_size = 128
    wait_timeout = 30
    connect_timeout = 10
    interactive_timeout = 10
    tmp_table_size = 64M
    max_heap_table_size = 64M
    max_allowed_packet = 16M
    max_connect_errors = 10
    query_cache_limit = 1M
    query_cache_size = 64M
    query_cache_type = 1
    thread_concurrency = 4
    
    [mysql.server]
    user=mysql
    
    [mysqld_safe]
    open_files_limit = 8192
    
    [mysqldump]
    quick
    max_allowed_packet = 100M
    
    [isamchk]
    key_buffer=64M
    sort_buffer=64M
    read_buffer=16M
    write_buffer=16M
    
    [myisamchk]
    key_buffer=64M
    sort_buffer=64M
    read_buffer=16M
    write_buffer=16M
    thx
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice