PDA

View Full Version : The MySQL .err file


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

eva2000
Tue 26th Nov '02, 5:37am
Originally posted by kippesp
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 submit a support ticket at http://www.vbulletin.com/members/support_form.php and provide more lines/info from the error file.... what you got there isn't enough to go on