![]() |
Mysql Server crashes all couple of minutes. The process is killing mysql, please someone help me. Top Process %CPU 351 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/server.thegenius.ws.pid --skip-external-locking --port3306 --socket/var/lib/mysql/mysql.sock I have to days trying to solve this problem and I can not. I sent email to support and he told me that it is no problem on the server, I was asked to contact the holder of the vBulletin them to verify and optimize the tables... Someone knows why this happens? Below is my my.cnf, and my server config Quote: port = 3306 socket = / var / lib / mysql / mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = / var / lib / mysql / mysql.sock skip-locking # key_buffer = 312M key_buffer = 128M max_allowed_packet = 1M # table_cache = 20000 table_cache = 2048 sort_buffer_size = 1M read_buffer_size = 4M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 16M # Try number of CPU's * 2 for thread_concurrency thread_concurrency = 8 # max_user_connections = 4000 # max_connections = 10000 max_connections = 1000 long_query_time = 5 log-slow-queries = / var / log / slow-sql.log max_heap_table_size = 16M tmp_table_size = 64M Quote: DC Softlayer Quad Core Xeon 5320 Clovertown 4 GB Ram HD 400GB SCSI 100 Mbps And I am also receiving many sql errors on my email. Quote: mysql_connect () [<a href='function.mysql-connect'> function.mysql-connect ]: Can not connect to local MySQL server through socket '/ var / lib / mysql / mysql.sock' ( 11) / home / thege / public_html / forum / includes / class_core.php on line 311 Please help me. Regards |
الساعة الآن 07:45 AM |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.5.2 TranZ By
Almuhajir