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]
