向各位大侠求助!!!
我现在开发一套安防系统,数据库用的MySQL InnoDB,C++做业务,现在是在高并发的情况下,两三天就会出现MySQL shutdown的情况,系统平台和大概情况如下介绍:
数据库服务器:8CPU,2G内存,HP服务器,单独运行MySQL server。操作系统:windows server2003,数据库版本:MySQL5.1.49(InnoDB)
运行情况:在实施过程中,这套系统在设备数2000-3500的时候,不会出现任何问题,但设备数超过4000后,运行2-3天就会出现我们的系统连接不上MySQL的情况,这时去查看数据库当前的链接数为95个,而数据库最大允许的最大数据库链接数为800个,去查看MySQL的.err文件,里面提示MySQL shutdown的信息和数据库线程强制关闭的信息。
大体情况就如此,向各位大虾请教了,在线等ing!
我现在开发一套安防系统,数据库用的MySQL InnoDB,C++做业务,现在是在高并发的情况下,两三天就会出现MySQL shutdown的情况,系统平台和大概情况如下介绍:
数据库服务器:8CPU,2G内存,HP服务器,单独运行MySQL server。操作系统:windows server2003,数据库版本:MySQL5.1.49(InnoDB)
运行情况:在实施过程中,这套系统在设备数2000-3500的时候,不会出现任何问题,但设备数超过4000后,运行2-3天就会出现我们的系统连接不上MySQL的情况,这时去查看数据库当前的链接数为95个,而数据库最大允许的最大数据库链接数为800个,去查看MySQL的.err文件,里面提示MySQL shutdown的信息和数据库线程强制关闭的信息。
大体情况就如此,向各位大虾请教了,在线等ing!
100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 3786 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 3713 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 3710 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 3708 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 3703 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 3695 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 3692 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 3691 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 3690 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 3674 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 3627 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 3614 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 3613 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 3612 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 3609 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 3608 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 3606 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 3604 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 3460 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 3442 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 3380 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 3372 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 3371 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 3325 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 3004 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2895 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2892 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2886 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2880 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2877 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2870 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2867 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2866 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2864 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2861 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2860 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2859 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2858 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2857 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2855 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2854 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2853 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2852 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2851 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2850 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2848 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2847 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2846 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2845 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2844 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2843 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2841 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2840 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2838 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2836 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2835 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2833 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2832 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2831 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2830 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2829 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2823 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2817 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2813 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2809 user: 'root'100825 15:18:06 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 2808 user: 'root'100825 15:18:06 InnoDB: Starting shutdown...
100825 15:18:09 InnoDB: Shutdown completed; log sequence number 0 2992440970
100825 15:18:09 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete
100825 15:18:10 InnoDB: Started; log sequence number 0 2992440970
100825 15:18:10 [Note] Event Scheduler: Loaded 0 events
100825 15:18:10 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.49-community' socket: '' port: 3306 MySQL Community Server (GPL)
100827 13:42:43 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Normal shutdown100827 13:42:43 [Note] Event Scheduler: Purging the queue. 0 events
100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 577 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 576 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 569 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 566 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 565 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 559 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 554 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 551 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 542 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 539 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 493 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 440 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 437 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 435 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 379 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 332 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 331 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 298 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 297 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 296 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 123 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 91 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 90 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 88 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 86 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 82 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 80 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 78 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 75 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 68 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 67 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 66 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 65 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 63 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 62 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 60 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 58 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 57 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 54 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 53 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 52 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 49 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 43 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 42 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 40 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 39 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 37 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 36 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 35 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 34 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 32 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 31 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 30 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 27 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 26 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 25 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 24 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 23 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 22 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 19 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 18 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 17 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 16 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 15 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 13 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 12 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 10 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 7 user: 'root'100827 13:42:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 4 user: 'root'100827 13:42:45 InnoDB: Starting shutdown...
100827 13:42:50 InnoDB: Shutdown completed; log sequence number 1 547381165
100827 13:42:50 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete100827 13:42:58 [Note] Plugin 'FEDERATED' is disabled.
100827 13:42:58 InnoDB: Started; log sequence number 1 547381165
100827 13:42:58 [Note] Event Scheduler: Loaded 0 events
100827 13:42:58 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.49-community' socket: '' port: 3306 MySQL Community Server (GPL)