Hi, can someone explain me about how to calculate a particular table size created in a mysql database ?

do u mean the file size of the table ?.. If it's you can query the details from information_schema tables. Consider the below example...

Let's assume that the database name is 'emp_database' and table name is 'emp_master'

--
SELECT table_schema,
table_name,
ROUND(data_length/1024/1024,2) total_size_mb
FROM information_schema.tables
WHERE table_name = 'emp_master' AND table_schema = 'emp_database';

---------------------------------------------
table_schema | table_name | total_size_mb
---------------------------------------------
emp_database | emp_master | 2.57

--

Check out this...

__________________
Keep smiling...