mysql hanging? win2000, PHP, apache2

[pgj69]

Having a problem with a website running on win2000 Pro. It will just hang-up sometimes for huge amounts of time, never shuts down, just seems PHP is not able to find a connection and will sit there for up to a couple of minutes. This happened before upgrading to apache2 also. the mysql is version 3.23.46 and php is 4.3. I have tried to find a website that could help explain some optimization settings for mysql and php with win2000 and haven't really had any luck. the website that is running is 99.9% used over a lan, it is used for company customer information and employees. Not sure where to begin to look for bottlenecks. The same version of apache also hosts an html based website that runs flawlessly, so not sure if apache is the problem, it never reports an error when the hangs occur.

would like to find some suggestions on where to look for problems or optimizing techniques.

Thanks
Paul James

 

[pgj69]

Here's a current runtime status

This MySQL server has been running for 4 days, 1 hours, 56 minutes and 6 seconds. It started up on Feb 03, 2003 at 06:46 AM.

Server traffic: These tables show the network traffic statistics of this MySQL server since its startup.

Traffic ø per hour
Received 0 Bytes 0 Bytes
Sent 0 Bytes 0 Bytes
Total 0 Bytes 0 Bytes

Connections ø per hour %
Failed attempts 397,269 4,056.46 88.84 %
Aborted 118 1.20 0.03 %
Total 447,190 4,566.19 100,00 %

Query statistics: Since its startup, 191,997 queries have been sent to the server.
Query type ø per hour %

More status variables
Variable Value
Created tmp disk tables 13734
Created tmp tables 20278
Created tmp files 288
Delayed insert threads 0
Delayed writes 0
Delayed errors 0
Flush commands 1
Handler delete 110
Handler read first 940
Handler read key 571993
Handler read next 3498
Handler read prev 0
Handler read rnd 422356
Handler read rnd next 11517120
Handler update 1968
Handler write 67406
Key blocks used 7764
Key read requests 1040558
Key reads 2870
Key write requests 43717
Key writes 1711
Max used connections 100
Not flushed key blocks 0
Not flushed delayed rows 0
Open tables 12
Open files 21
Open streams 0
Opened tables 3463
Select full join 6
Select full range join 0
Select range 2
Select range check 0
Select scan 28761
Slave running OFF
Slave open temp tables 0
Slow launch threads 0
Slow queries 2
Sort merge passes 144
Sort range 9
Sort rows 422356
Sort scan 14089
Table locks immediate 75188
Table locks waited 8
Threads cached 0
Threads created 447189
Threads connected 8
Threads running 1

 

[pgj69]

And here are the mysql variables:

Variable Value
back log 50
basedir C:\mysql\
binlog cache size 32768
character set latin1
character sets latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5
concurrent insert ON
connect timeout 5
datadir C:\mysql\data\
delay key write ON
delayed insert limit 100
delayed insert timeout 300
delayed queue size 1000
flush OFF
flush time 1800
have bdb NO
have gemini NO
have innodb NO
have isam YES
have raid NO
have openssl NO
init file
interactive timeout 28800
join buffer size 131072
key buffer size 8388600
language C:\mysql\share\english\
large files support ON
log OFF
log update OFF
log bin OFF
log slave updates OFF
log long queries OFF
long query time 10
low priority updates OFF
lower case table names 1
max allowed packet 1048576
max binlog cache size 4294967295
max binlog size 1073741824
max connections 100
max connect errors 10
max delayed threads 20
max heap table size 16777216
max join size 4294967295
max sort length 1024
max user connections 0
max tmp tables 32
max write lock count 4294967295
myisam max extra sort file size 256
myisam max sort file size 2047
myisam recover options 0
myisam sort buffer size 8388608
net buffer length 16384
net read timeout 30
net retry count 10
net write timeout 60
open files limit 0
pid file C:\mysql\data\MSServer.pid
port 3306
protocol version 10
record buffer 131072
record rnd buffer 131072
query buffer size 0
safe show database OFF
server id 0
slave net timeout 3600
skip locking ON
skip networking OFF
skip show database OFF
slow launch time 2
socket MySQL
sort buffer 2097144
sql mode 0
table cache 64
table type MYISAM
thread cache size 0
thread stack 65536
transaction isolation READ-COMMITTED
timezone Central Standard Time
tmp table size 33554432
tmpdir C:\WINNT\TEMP\
version 3.23.46-nt
wait timeout 28800