List:General Discussion« Previous MessageNext Message »
From:Mikhail Berman Date:April 20 2007 3:51pm
Subject:Could someone explain
View as plain text  
Dear List,
 
We are running:
 
mysql> status
--------------
mysql  Ver 14.12 Distrib 5.0.27, for unknown-freebsd6.0 (i386) using
readline 5.0

 
Could someone explain the meaning  or give us brief explanation of the
following entries in err file on MySQL server:
 
==================================================================
Status information:
 
Current dir: /mysql/mysql_data/data/
Running threads: 1  Stack size: 196608
Current locks:
lock: 0xac9623c:
 
lock: 0xac8da3c:
 
lock: 0xac60a3c:
 
lock: 0xac5aa3c:
 
lock: 0xac54a3c:
 
lock: 0xac47a3c:
 
lock: 0xac4423c:
 
lock: 0xac3d23c:
 

Key caches:
default
Buffer_size:     268435456
Block_size:           1024
Division_limit:        100
Age_limit:             300
blocks used:           895
not flushed:             0
w_requests:              3
writes:                  1
r_requests:         185177
reads:                 895
 

handler status:
read_key:          116
read_next:       98382
read_rnd             0
read_first:          3
write:              96
delete               3
update:              0
 
Table status:
Opened tables:         14
Open tables:            8
Open files:            21
Open streams:           0
 
Alarm status:
Active alarms:   1
Max used alarms: 1
Next alarm time: 28799
=============================================
 
Best Regards,
 
Mikhail Berman

Thread
Could someone explainMikhail Berman20 Apr