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.

crashing db after a few days

Discussion in 'Database Discussions' started by alone_lover, Dec 2, 2015.

  1. alone_lover

    alone_lover Member

    Joined:
    Dec 2, 2015
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi Dear
    I have a big problem with my ded server
    usage of ram increases every day and after a few days I get database error ((databases crash))
    I think there is an account in our server and it causes the problem
    note : I changed the config & server ,so problem relates to users but I dont know which user?!!
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Could you let us know the current contents of your /etc/my.cnf file? Have you tried running a MySQL tuner application?

    Thank you.
     
    alone_lover likes this.
  3. alone_lover

    alone_lover Member

    Joined:
    Dec 2, 2015
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    thanks for helping
    this is the contents of that:
    Code:
    [mysqld]
    innodb_file_per_table=1
    innodb_buffer_pool_size=10G
    innodb_buffer_pool_instances=10
    default-storage-engine=MyISAM
    max_allowed_packet=1024M
    query_cache_size = 10G
    query_cache_type=1
    thread_cache_size = 384
    join_buffer_size=500G
    max_connections=2000
    local-infile=0
    table_cache= 524288
    table_open_cache=524288
    open_files_limit = 200000
    tmp_table_size=256M
    max_heap_table_size=256M
    wait_timeout=10
    --
    
    no nothing.
     
    #3 alone_lover, Dec 2, 2015
    Last edited by a moderator: Dec 3, 2015
  4. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,146
    Likes Received:
    34
    Trophy Points:
    48
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hello,

    Please try to optimize your mysql with the MySQL tuner application and monitor mysql process with " mysqladmin proc" command, With this command you will get current mysql process list. Also check your mysql error logs and let us know what exact error are you getting in logs file when you are facing such issues.
     
    alone_lover likes this.
  5. alone_lover

    alone_lover Member

    Joined:
    Dec 2, 2015
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I used that commad but I didnt see any issues.
    yesterday the Memory Used was :(9,777,116 of 32,836,372) but now it is (11,777,116 of 32,836,372)
    If it goes in this way after a few weeks all of ram will be used !
    what would you reccomend to solve this problem?!
    thanks.
     
  6. alone_lover

    alone_lover Member

    Joined:
    Dec 2, 2015
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    sir
    now I restart mysql the memory usage :(4,805,816 of 32,836,372)
    but I see an error in result of restarting mysql
    151201 7:21:28 [Warning] /usr/sbin/mysqld: Forcing close of thread 392839 user: 'eximstats'
     
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page