How to I show the size of data and index of a Mysql database table

I'm looking to optimize the database and expire old records. Before I do this, I want to measure the effectiveness. So I'm looking to produce these values before and after the procedure.

asked 23 Apr '12, 15:28

fox's gravatar image

fox ♦♦
800162527
accept rate: 37%


I use this

SHOW TABLE STATUS LIKE 'tblname'
link

answered 01 May '12, 09:44

LostHero's gravatar image

LostHero
89091320
accept rate: 61%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×5
×1
×1
×1
×1

Asked: 23 Apr '12, 15:28

Seen: 797 times

Last updated: 01 May '12, 09:44

powered by OSQA