THe reason I am asking this question is that I want to make sure if some of my queries will use more memory than that of query\_cache\_limit. Some people suggusted using 'show table status like 'table\_name'. I think it is not relevant to this question. Thanks.