MySQL Forums
Forum List  »  Quality Assurance

bug about Key_blocks_not_flushed=18446744073709551615
Posted by: kelvin chou
Date: May 09, 2011 10:15PM

Dears:
when I insert 2000 records and check the key_buffer statys .The status messages is blow,is it possible a bug ? And my Key_blocks_unused is zero,will it effect insert performance? :
mysql> show status like 'key%';
+------------------------+--------+
| Variable_name | Value |
+------------------------+--------+
| Key_blocks_not_flushed | 18446744073709551615 |
| Key_blocks_unused | 0 |

mysql> select version();
+------------+
| version() |
+------------+
| 5.1.56-log |

mysql> show variables like '%key%';
+--------------------------+----------------------+
| Variable_name | Value |
+--------------------------+----------------------+
| delay_key_write | ALL |
| foreign_key_checks | ON |
| have_rtree_keys | YES |
| key_buffer_size | 536870912 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| max_seeks_for_key | 18446744073709551615 |
| ssl_key | |

Options: ReplyQuote


Subject
Views
Written By
Posted
bug about Key_blocks_not_flushed=18446744073709551615
2404
May 09, 2011 10:15PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.