mysql自动重启了

rongjun_cui

091212 19:53:30  mysqld restarted
091212 19:53:30  Warning: Asked for 196608 thread stack, but got 126976
091212 19:53:30  Warning: setrlimit couldn't increase number of open files to more than 1024 (request: 1049586)
091212 19:53:30  Warning: Changed limits: max_connections: 1000  table_cache: 64
091212 19:53:30  Can't start server: Bind on TCP/IP port: Address already in use
091212 19:53:30  Do you already have another mysqld server running on port: 3306 ?
091212 19:53:30  Aborting
091212 19:53:30  /usr/sbin/mysqld: Shutdown Complete
091212 19:53:30  mysqld ended
091213 18:36:47  mysqld started
091213 18:36:47  Warning: Asked for 196608 thread stack, but got 126976
091213 18:36:47  Warning: setrlimit couldn't increase number of open files to more than 1024 (request: 1049586)
091213 18:36:47  Warning: Changed limits: max_connections: 1000  table_cache: 64
091213 18:36:47  InnoDB: Started


091123 07:18:26  mysqld restarted
091123  7:18:26  Warning: Asked for 196608 thread stack, but got 126976
091123  7:18:26  Warning: setrlimit couldn't increase number of open files to more than 1024 (request: 1049586)
091123  7:18:26  Warning: Changed limits: max_connections: 1000  table_cache: 64
091123  7:18:26  Can't start server: Bind on TCP/IP port: Address already in use
091123  7:18:26  Do you already have another mysqld server running on port: 3306 ?
091123  7:18:26  Aborting
091123  7:18:26  /usr/sbin/mysqld: Shutdown Complete
091123 07:18:26  mysqld ended
091123 08:11:11  mysqld started
091123  8:11:11  Warning: Asked for 196608 thread stack, but got 126976
091123  8:11:11  Warning: setrlimit couldn't increase number of open files to more than 1024 (request: 1049586)
091123  8:11:11  Warning: Changed limits: max_connections: 1000  table_cache: 64
091123  8:11:11  InnoDB: Started

leoxqing

Can't start server: Bind on TCP/IP port: Address already in use
似乎LZ还有个mysqld进程在运行,ps -ef | grep mysql看看！

rongjun_cui

为什么会自动 restarted呢，当时出问题后我 ps -ef|grep mysql 没有mysql进程在运行呢，是自动restarted的，我想为什么会restarted

cenalulu

看看restart有没有规律，restart这条log之前有没有报错？

hironics

可能是mysql crash后，mysqld_safe导致的重新启动。而crash的原因可能包括（myisam文件崩溃等）。

你如果使用的是mysql5.0.51或5.1.14之前的版本，mysqld_safe会自动重启crash后的mysql。所以得到了你所说的现象。

ruochen

看你的log感觉是10天左右才重新启动的？
是不是os的一些limit参数设置需要修改下，请看下面的log信息
重点是open files、max_connections

091123  7:18:26  Warning: Asked for 196608 thread stack, but got 126976
091123  7:18:26  Warning: setrlimit couldn't increase number of open files to more than 1024 (request: 1049586)
091123  7:18:26  Warning: Changed limits: max_connections: 1000  table_cache: 64

rongjun_cui

Number of processes running now: 1
mysqld process hanging, pid 18415 - killed
091212 19:53:30  mysqld restarted
091212 19:53:30  Warning: Asked for 196608 thread stack, but got 126976
091212 19:53:30  Warning: setrlimit couldn't increase number of open files to more than 1024 (request: 1049586)
091212 19:53:30  Warning: Changed limits: max_connections: 1000  table_cache: 64
091212 19:53:30  Can't start server: Bind on TCP/IP port: Address already in use
091212 19:53:30  Do you already have another mysqld server running on port: 3306 ?
091212 19:53:30  Aborting
091212 19:53:30  /usr/sbin/mysqld: Shutdown Complete
091212 19:53:30  mysqld ended

Number of processes running now: 1
mysqld process hanging, pid 3002 - killed
091123 07:18:26  mysqld restarted
091123  7:18:26  Warning: Asked for 196608 thread stack, but got 126976
091123  7:18:26  Warning: setrlimit couldn't increase number of open files to more than 1024 (request: 1049586)
091123  7:18:26  Warning: Changed limits: max_connections: 1000  table_cache: 64
091123  7:18:26  Can't start server: Bind on TCP/IP port: Address already in use
091123  7:18:26  Do you already have another mysqld server running on port: 3306 ?
091123  7:18:26  Aborting
091123  7:18:26  /usr/sbin/mysqld: Shutdown Complete
091123 07:18:26  mysqld ended

rongjun_cui

[root@tt mysql]# ulimit -a
core file size          (blocks, -c) 0
data seg size           (kbytes, -d) unlimited
file size               (blocks, -f) unlimited
pending signals                 (-i) 1024
max locked memory       (kbytes, -l) 32
max memory size         (kbytes, -m) unlimited
open files                      (-n) 1024
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) 819200
stack size              (kbytes, -s) 10240
cpu time               (seconds, -t) unlimited
max user processes              (-u) 262144
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited

ruochen

看你下面的参数输出

root@localhostnone) 13:49:15>show variables like '%open%';
+-------------------+----------+
| Variable_name     | Value    |
+-------------------+----------+
| have_openssl      | DISABLED |
| innodb_open_files | 300      |
| open_files_limit  | 1024     |
+-------------------+----------+
3 rows in set (0.01 sec)

root@localhostnone) 13:49:22>show variables like '%max_conn%';
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| max_connect_errors | 10    |
| max_connections    | 100   |
+--------------------+-------+
2 rows in set (0.00 sec)

rongjun_cui

mysql> show variables like '%open%';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| have_openssl     | NO    |
| open_files_limit | 1024  |
+------------------+-------+
2 rows in set (0.00 sec)

mysql> show variables like '%max_conn%';
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| max_connections    | 1000  |
| max_connect_errors | 10    |
+--------------------+-------+
2 rows in set (0.00 sec)