问题:tomcat还是mysql

03-07-22 kitta

最近有些问题,让我一头雾水,搞不清楚,还请高手赐教!

真的很急,项目款因为这个一直下不来,我都快哭了!

先谢谢各位了!

我用jsp tomcat mysql搭了个站,可是运行一段时间后就会出现问题!

出现以下log:

------------------------------------------------------------

2003-07-22 02:24:38 StandardWrapperValve[default]: Servlet.service() for servlet default threw exception

java.net.SocketException: Connection reset

2003-07-22 04:43:07 StandardWrapperValve[jsp]: Servlet.service() for servlet jsp threw exception

org.apache.jasper.JasperException: Stream closed

2003-07-22 04:43:17 ApplicationDispatcher[] Servlet.service() for servlet jsp threw exception

org.apache.jasper.JasperException: Broken pipe

-------------------------------------------------------------

有时候mysql还会出现下面的东西,是锁表?

-------------------------------------------------------------

Status information:

Current dir: /var/lib/mysql/

Current locks:

lock: 8440164:

lock: 844329c:

lock: 848e52c:

lock: 8441d24:

lock: 842cfcc:

lock: 8404d94:

lock: 8402dec:

lock: 8400e1c:

lock: 83ff73c:

lock: 83e6b1c:

key_cache status:

blocks used: 20

not flushed: 0

w_requests: 27

writes: 32

r_requests: 36784

reads: 20

handler status:

read_key: 14441

read_next: 21007

read_rnd 4136

read_first: 612

write: 9

delete 1

update: 15

Table status:

Opened tables: 17

Open tables: 11

Open files: 21

Open streams: 0

Status information:

Current dir: /var/lib/mysql/

Current locks:

lock: 8440164:

lock: 844329c:

lock: 848e52c:

lock: 8441d24:

lock: 842cfcc:

lock: 8404d94:

lock: 8402dec:

lock: 8400e1c:

lock: 83ff73c:

lock: 83e6b1c:

key_cache status:

blocks used: 20

not flushed: 0

w_requests: 27

writes: 32

r_requests: 36784

reads: 20

handler status:

read_key: 14441

read_next: 21007

read_rnd 4136

read_first: 612

write: 9

delete 1

update: 15

Table status:

Opened tables: 17

Open tables: 11

Open files: 21

Open streams: 0