Step 1 : SSH to the server using the Putty Step 2: login to mysql by typing mysql -p (if you dont know password try below command ) mysql -ucron -p1234 Step 3 : select the asterisk database by typing use asterisk step 4: Run the below command to check total disk occupied by asterisk database SELECT table_schema AS "asterisk", ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size (MB)" FROM information_schema.TABLES GROUP BY table_schema; Step 5 : Run the below command to check disk space consumed by each table in asterisk database SELECT table_name AS "Table", ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)" FROM information_schema.TABLES WHERE table_schema = "asterisk" ORDER BY (data_length + inde...
Comments
Post a Comment