请教小弟我的mysql状态健康吗?请专家帮小弟我看看,多谢

请教小弟我的mysql状态健康吗?请专家帮小弟我看看,多谢

请问我的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

请教小弟我的mysql状态健康吗?请专家帮小弟我看看,多谢

相关文章:

你感兴趣的文章:

标签云: