tag:blogger.com,1999:blog-17155656.post115903814873848526..comments2023-04-06T12:09:13.895+02:00Comments on db4free.net blog: New information_schema viewsMarkus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-17155656.post-1159236741653466752006-09-26T04:12:00.000+02:002006-09-26T04:12:00.000+02:00Giuseppe: your query looks perfectly correct, but ...Giuseppe: your query looks perfectly correct, but when I run it I always get a key cache efficiency of NULL (although e.g. key_reads is 116 and key_read_requests is 10121, so there's no division by zero or something like that).<BR/><BR/>Ronald: my happiness that I can access all these values by queries exceeds my sorrow that I have to deal with two tables instead of one ;-).Markus Popphttps://www.blogger.com/profile/15355530354397508921noreply@blogger.comtag:blogger.com,1999:blog-17155656.post-1159047980129282082006-09-23T23:46:00.000+02:002006-09-23T23:46:00.000+02:00Great! That's what I have been waiting for very lo...Great! That's what I have been waiting for very long!<BR/>Calculating performance formulas is also easier with these tables:<BR/><BR/>select<BR/> @key_reads := (<BR/> select variable_value<BR/> from INFORMATION_SCHEMA.GLOBAL_STATUS<BR/> where VARIABLE_NAME = 'Key_reads') as key_reads,<BR/> @Key_read_requests := (<BR/> select variable_value<BR/> from INFORMATION_SCHEMA.GLOBAL_STATUS<BR/> where VARIABLE_NAME = 'Key_read_requests') as key_read_requests,<BR/> 100 - ((@key_cache/@Key_read_requests)*100) as `key cache efficiency`\G<BR/>*************************** 1. row ***************************<BR/> key_reads: 41959.0000000<BR/> key_read_requests: 8161031.0000000<BR/>key cache efficiency: 99.742716330816535400000000000000Giuseppe Maxiahttps://www.blogger.com/profile/15801583338057324813noreply@blogger.com