direct admin auto restart mysql

R

rmxs

Verified User
Joined
Jan 14, 2007
Messages
133
hello..

i have one problem..

i have 2 servers with direct admin install on both of them.

one its my webserver and the other its mysql server (i have direct admin to mysql server because i have some small html sites and the users need manage it)

the problem now comes from mysql server that every 500-600 secs restart mysql service.
i remove the line from status file that sayz directadmin restart services and seems to restart again.the strainge its not that restart mysql when its down byt restart mysql when its up and running.

i know that restart mysql and all this its from direct admin because when i stop da mysql uptime its ok

Uptime: 2107
Threads: 1
Questions: 24555
Slow queries: 1
Opens: 285
Flush tables: 1
Open tables: 272
Queries per second avg: 11.654

when i start da its no more than 500-600 secs

i search for cronjob byt i dont fint something in common places (if you wont reccoment me from were or how can i found all the crons)

i thing when my site connect from the remote server to mysql server and my site lose connection or someone stop the connection or something like this da things that mysql have problem and restart it..


can someone help me if there is solution?

thanks
 
You may have to setup mysql to log to a logfile or even put it in debug mode to find out what is causing it.

Do you see alot of mysql restart in /var/log/directadmin/system.log
 
yes every about 5-7 mins



LOGS

Number of processes running now: 0
080222 21:40:07 mysqld restarted
080222 21:40:08 [Warning] Asked for 196608 thread stack, but got 126976
080222 21:40:08 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 4
mysqld process hanging, pid 15746 - killed
080222 21:48:06 mysqld restarted
080222 21:48:06 [Warning] Asked for 196608 thread stack, but got 126976
080222 21:48:06 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 5
mysqld process hanging, pid 25925 - killed
080222 21:56:06 mysqld restarted
080222 21:56:06 [Warning] Asked for 196608 thread stack, but got 126976
080222 21:56:06 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 5
mysqld process hanging, pid 22374 - killed
080222 22:12:52 mysqld restarted
080222 22:12:52 [Warning] Asked for 196608 thread stack, but got 126976
080222 22:12:52 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 0
080222 22:20:07 mysqld restarted
080222 22:20:07 [Warning] Asked for 196608 thread stack, but got 126976
080222 22:20:07 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 4
mysqld process hanging, pid 3933 - killed
080222 22:28:09 mysqld restarted
080222 22:28:09 [Warning] Asked for 196608 thread stack, but got 126976
080222 22:28:09 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 3
080222 22:40:07 mysqld restarted
080222 22:40:08 [Warning] Asked for 196608 thread stack, but got 126976
080222 22:40:08 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)
080222 22:40:09 [Note] /usr/sbin/mysqld: Normal shutdown

080222 22:40:09 [Note] /usr/sbin/mysqld: Shutdown complete

080222 22:40:09 mysqld ended

080222 22:40:10 mysqld started
080222 22:40:10 [Warning] Asked for 196608 thread stack, but got 126976
080222 22:40:10 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 4
mysqld process hanging, pid 30602 - killed
080222 22:48:18 mysqld restarted
080222 22:48:18 [Warning] Asked for 196608 thread stack, but got 126976
080222 22:48:18 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 4
mysqld process hanging, pid 19545 - killed
080222 23:00:48 mysqld restarted
080222 23:00:48 [Warning] Asked for 196608 thread stack, but got 126976
080222 23:00:48 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 7
mysqld process hanging, pid 7712 - killed
080222 23:08:49 mysqld restarted
080222 23:08:49 [Warning] Asked for 196608 thread stack, but got 126976
080222 23:08:49 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 4
mysqld process hanging, pid 15546 - killed
080222 23:16:48 mysqld restarted
080222 23:16:48 [Warning] Asked for 196608 thread stack, but got 126976
080222 23:16:48 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 3
mysqld process hanging, pid 11592 - killed
080222 23:24:50 mysqld restarted
080222 23:24:50 [Warning] Asked for 196608 thread stack, but got 126976
080222 23:24:50 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 4
mysqld process hanging, pid 28476 - killed
080222 23:32:48 mysqld restarted
080222 23:32:48 [Warning] Asked for 196608 thread stack, but got 126976
080222 23:32:48 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 4
mysqld process hanging, pid 23987 - killed
080222 23:40:48 mysqld restarted
080222 23:40:48 [Warning] Asked for 196608 thread stack, but got 126976
080222 23:40:48 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 3
mysqld process hanging, pid 28445 - killed
080222 23:56:47 mysqld restarted
080222 23:56:47 [Warning] Asked for 196608 thread stack, but got 126976
080222 23:56:47 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 4
mysqld process hanging, pid 24530 - killed
080223 00:04:07 mysqld restarted
080223 0:04:07 [Warning] Asked for 196608 thread stack, but got 126976
080223 0:04:07 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 4
mysqld process hanging, pid 20037 - killed
080223 00:12:07 mysqld restarted
080223 0:12:07 [Warning] Asked for 196608 thread stack, but got 126976
080223 0:12:07 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 1
mysqld process hanging, pid 3182 - killed
080223 00:31:27 mysqld restarted
080223 0:31:27 [Warning] Asked for 196608 thread stack, but got 126976
080223 0:31:28 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
080223 0:31:28 [ERROR] Do you already have another mysqld server running on port: 3306 ?
080223 0:31:28 [ERROR] Aborting

080223 0:31:29 [Note] /usr/sbin/mysqld: Shutdown complete

080223 00:31:29 mysqld ended

080223 00:32:04 mysqld started
080223 0:32:04 [Warning] Asked for 196608 thread stack, but got 126976
080223 0:32:04 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 5
mysqld process hanging, pid 7556 - killed
080223 00:40:07 mysqld restarted
080223 0:40:07 [Warning] Asked for 196608 thread stack, but got 126976
080223 0:40:07 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 6
mysqld process hanging, pid 22348 - killed
080223 00:48:07 mysqld restarted
080223 0:48:08 [Warning] Asked for 196608 thread stack, but got 126976
080223 0:48:08 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 4
mysqld process hanging, pid 27660 - killed
080223 00:56:06 mysqld restarted
080223 0:56:06 [Warning] Asked for 196608 thread stack, but got 126976
080223 0:56:06 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 6
mysqld process hanging, pid 23875 - killed
080223 01:04:09 mysqld restarted
080223 1:04:09 [Warning] Asked for 196608 thread stack, but got 126976
080223 1:04:09 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 0
080223 01:12:07 mysqld restarted
080223 1:12:07 [Warning] Asked for 196608 thread stack, but got 126976
080223 1:12:07 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 0
080223 02:00:12 mysqld restarted
080223 2:00:20 [Warning] Asked for 196608 thread stack, but got 126976
080223 2:00:21 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)
080223 03:49:34 mysqld started
080223 3:49:34 [Warning] Asked for 196608 thread stack, but got 126976
080223 3:49:34 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)
A mysqld process already exists at Sat Feb 23 03:49:35 EST 2008

Number of processes running now: 0
080223 04:20:06 mysqld restarted
080223 4:20:07 [Warning] Asked for 196608 thread stack, but got 126976
080223 4:20:07 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 0
080223 04:32:11 mysqld restarted
080223 4:32:11 [Warning] Asked for 196608 thread stack, but got 126976
080223 4:32:11 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 27
mysqld process hanging, pid 26585 - killed
080223 04:40:07 mysqld restarted
080223 4:40:07 [Warning] Asked for 196608 thread stack, but got 126976
080223 4:40:07 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 18
mysqld process hanging, pid 19551 - killed
080223 04:48:08 mysqld restarted
080223 4:48:09 [Warning] Asked for 196608 thread stack, but got 126976
080223 4:48:11 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

Number of processes running now: 19
mysqld process hanging, pid 16342 - killed
080223 04:56:08 mysqld restarted
080223 4:56:08 [Warning] Asked for 196608 thread stack, but got 126976
080223 4:56:08 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)
Click to expand...
now with da off its up

Uptime: 9083
Threads: 1
Questions: 235757
Slow queries: 2
Opens: 343
Flush tables: 1
Open tables: 308
Queries per second avg: 25.956


how can i put it to debug mode or how can i check y restarted from da
 
Last edited:
rmxs said:
hello..

i have one problem..

i have 2 servers with direct admin install on both of them.

one its my webserver and the other its mysql server
Click to expand...

I thought that if you had 2 servers, 1 for DA and the other servicing mysql that only one box needed DA installed. The other box should only have mysql installed.
 
More than likely you will have to start the server without it forking into the background so that you can watch what is going on.

You will have to edit the /etc/init.d/mysql file and add --debug to the command line. Then temporarly remove > /dev/null & from the end of the command line. If you are unfamiliar with this or uncomfortable then you probably should consult a professional to look at your server.
 
the problem mayve comes from mysql because the restarts its every 8 mins...

PHP: 
Number of processes running now: 0
080223 22:08:50  mysqld restarted
080223 22:08:50 [Warning] Asked for 196608 thread stack, but got 126976
080223 22:08:50 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 0
080223 22:16:46  mysqld restarted
080223 22:16:46 [Warning] Asked for 196608 thread stack, but got 126976
080223 22:16:47 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 5
mysqld process hanging, pid 26015 - killed
080223 22:24:48  mysqld restarted
080223 22:24:48 [Warning] Asked for 196608 thread stack, but got 126976
080223 22:24:48 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 5
mysqld process hanging, pid 26419 - killed
080223 22:32:46  mysqld restarted
080223 22:32:47 [Warning] Asked for 196608 thread stack, but got 126976
080223 22:32:47 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 5
mysqld process hanging, pid 22344 - killed
080223 22:40:47  mysqld restarted
080223 22:40:47 [Warning] Asked for 196608 thread stack, but got 126976
080223 22:40:48 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 4
mysqld process hanging, pid 22420 - killed
080223 22:48:47  mysqld restarted
080223 22:48:47 [Warning] Asked for 196608 thread stack, but got 126976
080223 22:48:47 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 4
mysqld process hanging, pid 26335 - killed
080223 22:56:47  mysqld restarted
080223 22:56:47 [Warning] Asked for 196608 thread stack, but got 126976
080223 22:56:47 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 4
mysqld process hanging, pid 18327 - killed
080223 23:04:46  mysqld restarted
080223 23:04:46 [Warning] Asked for 196608 thread stack, but got 126976
080223 23:04:46 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 3
mysqld process hanging, pid 19993 - killed
080223 23:12:47  mysqld restarted
080223 23:12:47 [Warning] Asked for 196608 thread stack, but got 126976
080223 23:12:47 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 0
080223 23:20:45  mysqld restarted
080223 23:20:45 [Warning] Asked for 196608 thread stack, but got 126976
080223 23:20:45 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 3
mysqld process hanging, pid 16356 - killed
080223 23:28:46  mysqld restarted
080223 23:28:46 [Warning] Asked for 196608 thread stack, but got 126976
080223 23:28:46 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 3
mysqld process hanging, pid 11661 - killed
080223 23:36:45  mysqld restarted
080223 23:36:45 [Warning] Asked for 196608 thread stack, but got 126976
080223 23:36:45 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 3
mysqld process hanging, pid 9428 - killed
080223 23:44:47  mysqld restarted
080223 23:44:47 [Warning] Asked for 196608 thread stack, but got 126976
080223 23:44:47 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 3
mysqld process hanging, pid 15882 - killed
080223 23:52:49  mysqld restarted
080223 23:52:49 [Warning] Asked for 196608 thread stack, but got 126976
080223 23:52:49 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 4
mysqld process hanging, pid 10089 - killed
080224 00:00:49  mysqld restarted
080224  0:00:49 [Warning] Asked for 196608 thread stack, but got 126976
080224  0:00:49 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 4
mysqld process hanging, pid 12073 - killed
080224 00:08:47  mysqld restarted
080224  0:08:47 [Warning] Asked for 196608 thread stack, but got 126976
080224  0:08:47 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 4
mysqld process hanging, pid 22471 - killed
080224 00:16:46  mysqld restarted
080224  0:16:46 [Warning] Asked for 196608 thread stack, but got 126976
080224  0:16:46 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 0
080224 00:32:47  mysqld restarted
080224  0:32:47 [Warning] Asked for 196608 thread stack, but got 126976
080224  0:32:47 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 4
mysqld process hanging, pid 32701 - killed
080224 00:40:48  mysqld restarted
080224  0:40:48 [Warning] Asked for 196608 thread stack, but got 126976
080224  0:40:48 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 4
mysqld process hanging, pid 23773 - killed
080224 00:48:46  mysqld restarted
080224  0:48:46 [Warning] Asked for 196608 thread stack, but got 126976
080224  0:48:46 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 0
080224 00:56:48  mysqld restarted
080224  0:56:48 [Warning] Asked for 196608 thread stack, but got 126976
080224  0:56:48 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 4
mysqld process hanging, pid 22479 - killed
080224 01:04:48  mysqld restarted
080224  1:04:48 [Warning] Asked for 196608 thread stack, but got 126976
080224  1:04:48 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 4
mysqld process hanging, pid 21648 - killed
080224 01:12:47  mysqld restarted
080224  1:12:47 [Warning] Asked for 196608 thread stack, but got 126976
080224  1:12:47 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 3
mysqld process hanging, pid 23554 - killed
080224 01:20:46  mysqld restarted
080224  1:20:46 [Warning] Asked for 196608 thread stack, but got 126976
080224  1:20:46 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 5
mysqld process hanging, pid 22297 - killed
mysqld process hanging, pid 9590 - killed
mysqld process hanging, pid 9590 - killed
080224 01:28:48  mysqld restarted
080224  1:28:48 [Warning] Asked for 196608 thread stack, but got 126976
080224  1:28:48 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 0
080224 01:52:46  mysqld restarted
080224  1:52:46 [Warning] Asked for 196608 thread stack, but got 126976
080224  1:52:47 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 5
080224 02:04:50  mysqld restarted
080224  2:04:50 [Warning] Asked for 196608 thread stack, but got 126976
080224  2:04:50 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 5
mysqld process hanging, pid 19866 - killed
080224 02:13:00  mysqld restarted
080224  2:13:02 [Warning] Asked for 196608 thread stack, but got 126976
080224  2:13:05 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 0
080224 02:20:07  mysqld restarted
080224  2:20:07 [Warning] Asked for 196608 thread stack, but got 126976
080224  2:20:08 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 0
080224 02:28:05  mysqld restarted
080224  2:28:05 [Warning] Asked for 196608 thread stack, but got 126976
080224  2:28:05 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 0
080224 02:36:07  mysqld restarted
080224  2:36:07 [Warning] Asked for 196608 thread stack, but got 126976
080224  2:36:07 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 0
080224 02:44:04  mysqld restarted
080224  2:44:04 [Warning] Asked for 196608 thread stack, but got 126976
080224  2:44:04 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 0
080224 02:52:06  mysqld restarted
080224  2:52:06 [Warning] Asked for 196608 thread stack, but got 126976
080224  2:52:06 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 0
080224 03:00:04  mysqld restarted
080224  3:00:04 [Warning] Asked for 196608 thread stack, but got 126976
080224  3:00:04 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 0
080224 03:08:04  mysqld restarted
080224  3:08:04 [Warning] Asked for 196608 thread stack, but got 126976
080224  3:08:04 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 0
080224 03:16:07  mysqld restarted
080224  3:16:07 [Warning] Asked for 196608 thread stack, but got 126976
080224  3:16:07 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 0
080224 03:24:06  mysqld restarted
080224  3:24:06 [Warning] Asked for 196608 thread stack, but got 126976
080224  3:24:06 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 0
080224 03:48:06  mysqld restarted
080224  3:48:06 [Warning] Asked for 196608 thread stack, but got 126976
080224  3:48:06 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 5
080224 03:56:07  mysqld restarted
080224  3:56:07 [Warning] Asked for 196608 thread stack, but got 126976
080224  3:56:07 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 1
mysqld process hanging, pid 29707 - killed
080224 04:08:08  mysqld restarted
080224  4:08:08 [Warning] Asked for 196608 thread stack, but got 126976
080224  4:08:08 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 7
mysqld process hanging, pid 17429 - killed
080224 04:20:08  mysqld restarted
080224  4:20:08 [Warning] Asked for 196608 thread stack, but got 126976
080224  4:20:08 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 0
080224 04:28:09  mysqld restarted
080224  4:28:09 [Warning] Asked for 196608 thread stack, but got 126976
080224  4:28:09 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Number of processes running now: 5
mysqld process hanging, pid 13564 - killed
080224 04:36:06  mysqld restarted
080224  4:36:06 [Warning] Asked for 196608 thread stack, but got 126976
080224  4:36:06 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

Only mysql run on this machine right now
 
seems than mysql restarts every 8 mins...

i have vps its possible the admin of the server to set auto restart for services in all server every x time?
 
You must log in or register to reply here.
Back
Top