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.

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:
    1
    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:
    1
    Hi

    nobody can help me on this one?
     
  3. madaboutlinux

    madaboutlinux Well-Known Member

    Joined:
    Jan 24, 2005
    Messages:
    1,052
    Likes Received:
    2
    Trophy Points:
    38
    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.
     
  4. blogmaster2003

    Joined:
    Sep 16, 2004
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    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