MySQL Forums
Forum List  »  Performance

Mysql keep restarting
Posted by: newbie Shai
Date: February 15, 2011 11:01PM

Dear All,
I have dedicated machine with 32G Ram and 16cpus and only running mysql.Below is my top during the day which is peak time and below is also the mysql config file. What I notice in between sometimes there is quite a number restarts happening. I dont get it why when I have so much of dedicated resources why does mysql goes down? Any reason for it? I am also looking into the slow query but I do have enough resources right?

Top.

top - 12:54:21 up 1 day, 23:31, 2 users, load average: 2.36, 2.00, 2.34
Tasks: 278 total, 3 running, 275 sleeping, 0 stopped, 0 zombie
Cpu(s): 2.0%us, 0.8%sy, 0.0%ni, 94.6%id, 0.2%wa, 0.6%hi, 1.8%si, 0.0%st
Mem: 33009800k total, 22447692k used, 10562108k free, 200920k buffers
Swap: 35061752k total, 0k used, 35061752k free, 18498676k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
3011 mysql 20 0 9899m 1.8g 4148 R 127.3 5.8 105:13.53 mysqld
8763 root 20 0 14876 1176 776 R 2.0 0.0 0:00.01 top
1 root 20 0 4080 856 608 S 0.0 0.0 0:01.58 init

My.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-innodb
skip-bdb
max_connections = 1000
key_buffer = 8192M
myisam_sort_buffer_size = 64M
join_buffer_size = 32M
read_buffer_size = 2M
sort_buffer_size = 4M
table_cache = 2048
thread_cache_size = 32
wait_timeout = 200
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 4096M
query_cache_size = 1G
query_cache_type = 1
server-id=1283835628
log-bin=mysql-bin
log-error=mysql-bin.err
binlog_do_db=fms,sms
log-slow-queries = /var/log/mysql/mysql-slow.log
long_query_time = 10
log-queries-not-using-indexes
log_warnings = 2

[mysqld_safe]
err-log=/var/log/mysqld.log
open_files_limit = 10000

[mysqldump]
quick
max_allowed_packet = 16M

[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

[mysql.server]
#user=mysql

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql keep restarting
4436
February 15, 2011 11:01PM
1839
February 16, 2011 08:42AM
2130
February 16, 2011 12:30PM
1850
February 16, 2011 01:59PM
2059
February 16, 2011 08:47PM
1777
February 17, 2011 08:45AM
1490
February 17, 2011 09:15AM
2255
February 17, 2011 06:45PM
1348
February 18, 2011 08:44PM
1307
February 19, 2011 08:21AM
1488
February 19, 2011 11:24AM
1385
February 20, 2011 09:47PM
1449
February 21, 2011 10:19AM
1837
February 21, 2011 09:07AM
1328
February 21, 2011 10:24AM
1300
February 21, 2011 11:49AM
1322
February 21, 2011 02:16PM
1488
February 21, 2011 06:01PM
3439
February 22, 2011 01:05AM
1607
February 22, 2011 07:34AM
2242
February 22, 2011 01:49PM
1493
February 22, 2011 03:47PM
1632
February 22, 2011 04:04PM
1390
February 22, 2011 09:55AM
1341
February 22, 2011 01:26PM
1383
February 22, 2011 03:59PM
1354
February 22, 2011 04:12PM
1343
February 22, 2011 09:49PM
1320
February 23, 2011 01:08AM
1323
February 23, 2011 08:51AM
1636
February 23, 2011 08:11AM
1618
February 23, 2011 08:31AM
1430
February 23, 2011 09:59AM
1492
February 23, 2011 01:45PM
1358
February 23, 2011 10:12PM
1419
February 24, 2011 01:37PM
1466
February 24, 2011 03:16PM
1340
February 25, 2011 08:03PM
1507
February 25, 2011 08:32PM
1124
February 26, 2011 01:38AM
1564
February 26, 2011 12:23PM
1283
February 27, 2011 11:37PM
1243
March 01, 2011 06:16PM
1291
March 01, 2011 08:12PM
1225
March 01, 2011 09:10PM
1536
March 02, 2011 11:51AM
1302
March 02, 2011 11:59AM
1239
March 10, 2011 11:15PM
1225
March 11, 2011 10:12AM
1278
March 12, 2011 10:45AM
1320
March 12, 2011 11:53PM
1237
March 13, 2011 05:19AM
1286
March 16, 2011 12:35AM
1228
March 16, 2011 08:00AM
1395
March 16, 2011 09:07AM
1290
March 16, 2011 08:48PM
1298
March 17, 2011 12:06PM
1927
March 22, 2011 09:49PM
1404
March 26, 2011 10:54AM
1205
March 26, 2011 02:55PM
1341
March 27, 2011 04:33AM
1259
March 27, 2011 01:28PM
1347
March 27, 2011 09:14PM
1337
March 28, 2011 12:19AM
1285
March 28, 2011 10:05AM
1587
February 23, 2011 09:09AM
1718
February 23, 2011 01:17PM
1418
February 23, 2011 01:20PM
1536
February 23, 2011 09:12AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.