Seriously, can anyone help me out here? I've searched the list and
I've searched around the Internet. I've found other people reporting a
similar entry into their log files, but no one answered them either.
I've read up on a few things, and I have a feeling that this error is
related to some threading bug/error, but I'm not quite sure. Another
thing to note, is it seems that the slave server is getting
simultaneously issued a 'flush tables' for each entry shown below.
Here is a part of a status command:
Uptime: 1 day 21 hours 36 min 51 sec
Threads: 1 Questions: 2739695 Slow queries: 0 Opens: 1 Flush
tables: 1358804 Open tables: 1 Queries per second avg: 16.684
Additionally, I've set up one of my other servers as a slave, and I do
not have the same problems as this slav. Same version of mysql
(untared from the same file even), so I'm sure that the problem is not
starting from the master. The only difference between the two slave
servers is the OS. The slave that is 'broken' is on Mac OS X 10.3
Server and the one that works is Mac OS X 10.1 Server.
On Dec 01, 2003, at 03:42, Chris Waskowich wrote:
One of my server is a slave to another. The slave server's host.err
file is getting filled with blocks like this:
Status information:
Current dir: /usr/local/mysql/var/
Running threads: 0 Stack size: 65536
Current locks:
lock: 82268c:
key_cache status:
blocks used:15
not flushed: 0
w_requests: 0
writes: 0
r_requests: 0
reads: 0
handler status:
read_key:0
read_next: 0
read_rnd 0
read_first: 0
write: 0
delete 0
update: 0
Table status:
Opened tables: 0
Open tables:0
Open files: 4
Open streams: 0
Alarm status:
Active alarms: 1
Max used alarms: 1
Next alarm time: 3600
Does anyone know what this stuff is and how I would stop it from being
written?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
