日期:2014-05-16  浏览次数:20746 次

请问我的mysql状态健康吗?请专家帮我看看,谢谢。
程序语言是java,使用了数据库连接池,一共有三台服务器对该数据库服务器进行连接,运行2天左右就会出现错误,错误内容为:com.mysql.jdbc.exceptions.MySQLTimeoutException: Statement cancelled due to timeout or client request

数据库的状态情况如下(连接IP进行了处理):


*************************** 1. row ***************************
  Type: InnoDB
  Name: 
Status: 
=====================================
120504 1:10:26 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 26 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 114373 1_second, 114372 sleeps, 10378 10_second, 10693 background, 10693 flush
srv_master_thread log flush and writes: 115265
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 8733, signal count 8790
Mutex spin waits 3197, rounds 5875, OS waits 132
RW-shared spins 8430, rounds 251786, OS waits 8389
RW-excl spins 4, rounds 6444, OS waits 211
Spin rounds per wait: 1.84 mutex, 29.87 RW-shared, 1611.00 RW-excl
------------
TRANSACTIONS
------------
Trx id counter A5088
Purge done for trx's n:o < A506E undo n:o < 0
History list length 2904
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 648, OS thread handle 0x7fbebda63700, query id 375737 127.0.0.1 root
show engine innodb status
---TRANSACTION A5059, not started
MySQL thread id 647, OS thread handle 0x7fbebd54f700, query id 375680 *.73.*.* asdktj34_sdfjssg
---TRANSACTION A5076, not started
MySQL thread id 646, OS thread handle 0x7fbebd89c700, query id 375679 *.73.*.* asdktj34_sdfjssg
---TRANSACTION A5081, not started
MySQL thread id 645, OS thread handle 0x7fbebd07c700, query id 375718 *.*.*.141 asdktj34_sdfjssg
---TRANSACTION A507E, not started
MySQL thread id 644, OS thread handle 0x7fbebd13f700, query id 375713 *.*.*.141 asdktj34_sdfjssg
---TRANSACTION A5079, not started
MySQL thread id 643, OS thread handle 0x7fbebd612700, query id 375717 *.*.*.141 asdktj34_sdfjssg
---TRANSACTION A5001, not started
MySQL thread id 642, OS thread handle 0x7fbebd306700, query id 375716 *.*.*.141 asdktj34_sdfjssg
---TRANSACTION A5024, not started
MySQL thread id 641, OS thread handle 0x7fbebcf37700, query id 375734 *.*.*.141 asdktj34_sdfjssg
---TRANSACTION A4E83, not started
MySQL thread id 640, OS thread handle 0x7fbebd284700, query id 374450 *.*.*.143 asdktj34_sdfjssg
---TRANSACTION A4FBA, not started
MySQL thread id 639, OS thread handle 0x7fbebd180700, query id 375248 *.*.*.143 asdktj34_sdfjssg
---TRANSACTION A5073, not started
MySQL thread id 638, OS thread handle 0x7fbebd95f700, query id 375701 *.73.*.* asdktj34_sdfjssg
---TRANSACTION A506A, not started
MySQL thread id 637, OS thread handle 0x7fbebcffa700, query id 375690 *.73.*.* asdktj34_sdfjssg
---TRANSACTION A506F, not started
MySQL thread id 635, OS thread handle 0x7fbebd6d5700, query id 375691 *.73.*.* asdktj34_sdfjssg
---TRANSACTION A5069, not started
MySQL thread id 636, OS thread handle 0x7fbebda22700, query id 375681 *.73.*.* asdktj34_sdfjssg
---TRANSACTION A5074, not started
MySQL thread id 634, OS thread handle 0x7fbebccad700, query id 375669 *.*.*.143 asdktj34_sdfjssg
---TRANSACTION A507B, not started
MySQL thread id 633, OS thread handle 0x7fbebd243700, query id 375733 *.*.*.141 asdktj34_sdfjssg
---TRANSACTION A5087, not started
MySQL thread id 632, OS thread handle 0x7fbebd694700, query id 375735 *.*.*.141 asdktj34_sdfjssg
---TRANSACTION A507A, not started
MySQL thread id 630, OS thread handle 0x7fbebd5d1700, query id 375699 *.73.*.* asdktj34_sdfjssg
---TRANSACTION A5065, not started
MySQL thread id 631, OS thread handle 0x7fbebce33700, q