----- Original Message ----- > Hi @ all again,
> one final thought while my ArchMgr still validates its database: I > have compared my MySQL Status output with a running SPECTRUM > installation with DDM up and doing what it should. I have seen that > on my new machine there is a "key_blocks_unused" counter constantly > decreasing while the "key_rad" parameter is growing: > mysql> show STATUS LIKE "%key%"; > +------------------------+--------+ > | Variable_name | Value | > +------------------------+--------+ > | Com_assign_to_keycache | 0 | > | Com_preload_keys | 0 | > | Com_show_keys | 0 | > | Handler_read_key | 0 | > | Key_blocks_not_flushed | 0 | > | Key_blocks_unused | 220989 | <--- > | Key_blocks_used | 8565 | > | Key_read_requests | 8565 | > | Key_reads | 8565 | > | Key_write_requests | 0 | > | Key_writes | 0 | > +------------------------+--------+ > 11 rows in set (0,00 sec) > In my running DDM environment, this counter is zero: > mysql> show STATUS LIKE "%key%"; > +------------------------+------------+ > | Variable_name | Value | > +------------------------+------------+ > | Com_assign_to_keycache | 0 | > | Com_preload_keys | 0 | > | Com_show_keys | 0 | > | Handler_read_key | 0 | > | Key_blocks_not_flushed | 222 | > | Key_blocks_unused | 0 | <----- > | Key_blocks_used | 7170 | > | Key_read_requests | 2465816151 | > | Key_reads | 18893015 | > | Key_write_requests | 412673691 | > | Key_writes | 79520576 | > +------------------------+------------+ > 11 rows in set (0,00 sec) > Could it be that this is my indicator when to expect an end to this > mess? The zero value in the running DDM means the key cache is exhausted. See http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html#statvar_Key_blocks_unused . Basically, key_blocks_unused + key_blocks_used would equal the key cache configured. Comparing the 2 tables, the running DDM has used 7170 blocks and the key cache has peaked , the other DDM (which I assume is the one running the recovery checks) has used 8565 block s and still has to spare - it's not using too much of the 'key_cache' at the moment. I wouldn't say that key_blocks_unused decreasing would mean anything when the system is running the checks. regards, -- Cristi Mitrana --- To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected]
