Calculate table size and index size in Mysql

By -
Calculate table size and index size in Mysql


mysql> SELECT  table_name,`engine`
,ROUND(data_length/1024/1024,2) total_size_mb,
ROUND(index_length/1024/1024,2) total_index_size_mb, table_rows
FROM   information_schema.TABLES
WHERE  table_schema = 'SalesDB'
ORDER BY 3;
SalesDB -- Database name


total_size_mb -- Total size in MB 




query result




 table_name engine total_size_mb total_index_size_mb table_rows 


 Customers InnoDB 0.45 0.11 1257 


 Invoices InnoDB 1.73 1.21 12785 

 







































Comments











Post a Comment






























Popular posts from this blog









IrfanView : Simple Windows graphic viewer







By







-














Image







IrfanView is a very fast, small, compact and innovative FREEWARE (for non-commercial use)  graphic viewer for Windows 9x, ME, NT, 2000, XP, 2003 , 2008, Vista, Windows 7.    (click here for IrfanView EULA )   It is designed to be simple for beginners and powerful for professionals.   IrfanView seeks to create unique, new and interesting features, unlike some other  graphic viewers, whose whole "creativity" is based on feature cloning, stealing of ideas and whole dialogs from ACDSee and/or  IrfanView! (for example: XnView has been stealing/cloning features and whole dialogs from IrfanView, for 10+ years).  IrfanView was the first Windows graphic viewer WORLDWIDE with Multiple (animated)  GIF support.  One of the first graphic viewers WORLDWIDE with Multipage TIF support.  The first graphic viewer WORLDWIDE with Multiple ICO support.        Some IrfanView features :        Many supported file formats (click here  the list of formats )   Multi language support   Thumbnail/previe








Read more










MySQL Cluster Overview







By







-














Image







16.1. MySQL Cluster Overview   MySQL Cluster  is a technology that enables clustering of in-memory databases in a shared-nothing system. The  shared-nothing architecture enables the system to work with very  inexpensive hardware, and with a minimum of specific requirements  for hardware or software.   MySQL Cluster is designed not to have any single point of failure.  In a shared-nothing system, each component is expected to have its  own memory and disk, and the use of shared storage mechanisms such  as network shares, network file systems, and SANs is not recommended  or supported.   MySQL Cluster integrates the standard MySQL server with an in-memory  clustered storage engine called NDB  (which stands for “ N etwork  D ata B ase ”). In our  documentation, the term NDB  refers to  the part of the setup that is specific to the storage engine,  whereas “ MySQL Cluster ” refers to the combination of  one or more MySQL servers with the NDB  storage engine.   A MySQL Cluster consists of a








Read more















By







-















Grants         privileges to MySQL user    CREATE USER  'root'@'localhost' IDENTIFIED BY 'pass';  pass : enter your password   Grant full rights  GRANT ALL ON *.* TO 'root'@'localhost';   more info  http://dev.mysql.com/doc/refman/5.1/en/grant.html   








Read more