在mysql中找到记录所占用的空间 [英] find the space occupied by records in mysql

问题描述

我想找到数据库中记录所占用的空间.我有2000条记录.我需要在MySQL中找到Empid 4在数据库中占用的空间.

I want to find the space occupied by the records in database. I have 2000 records. I need to find how much space occupied by empid 4 in the database in mySQL.

请让我知道mySQL中的查询.

Please let me know the query in mySQL.

推荐答案

SHOW TABLE STATUS是

SHOW TABLE STATUS is the command you're looking for:

SHOW TABLE STATUS IN your_database LIKE 'yourtable';

您要查找的指标可能是Data_length或Avg_row_length.

The metric you're looking for may be either Data_length or Avg_row_length.

这篇关于在mysql中找到记录所占用的空间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！