crashing db after a few days

alone_lover

• December 02, 2015 02:56

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?!!

• 

  cPanelMichael

  • December 02, 2015 17:54

  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.

  0
• 

  alone_lover

  • December 02, 2015 18:18

  thanks for helping this is the contents of that:
  [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.

  0
• 

  24x7server

  • December 03, 2015 06:57

  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.

  0
• 

  alone_lover

  • December 03, 2015 16:44

  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.

  0
• 

  alone_lover

  • December 03, 2015 18:02

  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'

  0
• 

  cPanelMichael

  • December 03, 2015 18:15

  That error message simply indicates a forced close for the eximstats user. You may find the following thread helpful for tuning MySQL: mysqlmymonlite.sh server stats gathering tool for cPanel Server Thank you.

  0

Please sign in to leave a comment.