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 explain | Mikhail Berman | 20 Apr |