kippesp
Tue 26th Nov '02, 4:20am
How would I use the info in the .err file created in the MySQL data area?
Right now, mine has many lines with "lock: [some number]" and various status info. What should I do to reduce these "errors?"
key_cache status:
blocks used: 15582
not flushed: 0
w_requests: 3250188
writes: 2824182
r_requests: 1938425023
reads: 2225392
handler status:
read_key: 424145468
read_next: 2137862277
read_rnd 446413708
read_first: 1337100
write: 388911457
delete 584731
update: 3490073
Table status:
Opened tables: 1685
Open tables: 1024
Open files: 1216
Open streams: 0
Right now, mine has many lines with "lock: [some number]" and various status info. What should I do to reduce these "errors?"
key_cache status:
blocks used: 15582
not flushed: 0
w_requests: 3250188
writes: 2824182
r_requests: 1938425023
reads: 2225392
handler status:
read_key: 424145468
read_next: 2137862277
read_rnd 446413708
read_first: 1337100
write: 388911457
delete 584731
update: 3490073
Table status:
Opened tables: 1685
Open tables: 1024
Open files: 1216
Open streams: 0