Hello, I was wondering whether someone could tell me something about my query-cache statistics (MySQL 4.0.22):
Qcache queries in cache 4479 Qcache inserts 37392 Qcache hits 56994 Qcache lowmem prunes 0 Qcache not cached 24 Qcache free memory 9448968 Qcache free blocks 502 Qcache total blocks 9604 It seems to me, that the inserts/hits ratio is a bit off; meaning, I expect a good cache performance to be one where "inserts" is low vs. a high "hits". Is that assessment right? Also, it seems my "Qcache free memory" is pretty high; but I left it that way because I do not seem to have a whole lot of "Qcache free blocks". Would decreasing the allocated qcache memory also decrease the amount of free blocks? Thanks, - Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]