Re: PK Space calculation for table with composite key as PK
Posted by: S.M. Gopinath
Date: December 11, 2023 08:28AM

Pls try:

select database_name, table_name, index_name, stat_value*@@innodb_page_size
from mysql.innodb_index_stats where stat_name='size';

Options: ReplyQuote


Subject
Written By
Posted
Re: PK Space calculation for table with composite key as PK
December 11, 2023 08:28AM


Sorry, only registered users may post in this forum.

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.