Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
techwiki:aws [2020/03/30 03:37]
ying [Website request not responding]
techwiki:aws [2020/03/30 03:40] (current)
ying [Website Cant Do Editing and Disk is Full]
Line 282: Line 282:
 // (for bitnami: sudo /​opt/​bitnami/​ctlscript.sh restart apache) // (for bitnami: sudo /​opt/​bitnami/​ctlscript.sh restart apache)
 </​code>​ </​code>​
 +    - check C: check mysql database folder
 +      - login mysql (for bitnami, same as main app pass) <​code>​mysql -u root -p</​code>​
 +      - check database size <code sql>
 +SELECT table_schema AS "​Database", ​
 +ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size (MB)" ​
 +FROM information_schema.TABLES ​
 +GROUP BY table_schema;​
 +</​code>​
 +      - check each database'​s table size <code sql>
 +SELECT table_name AS "​Table",​
 +ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)"
 +FROM information_schema.TABLES
 +WHERE table_schema = "​database_name"​
 +ORDER BY (data_length + index_length) DESC;
 +</​code>​
 +      - type quit to exit mysql
 +