crashing db after a few days

[alone_lover]

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]

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]

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.

 

[24x7server]

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]

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.

 

[alone_lover]

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'

 

[cPanelMichael]

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.