tag:blogger.com,1999:blog-84828345693861434802023-11-15T06:02:07.528-08:00Computer TipsMAhttp://www.blogger.com/profile/15647592837919229742noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-8482834569386143480.post-73360673248824391002014-07-12T09:36:00.002-07:002014-07-13T18:41:10.835-07:00MySQL Database Table Size<pre>
Query MySQL table sizes
SELECT table_name AS "Tables",
round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB"
FROM information_schema.TABLES
WHERE table_schema = "$DBNAME" AND (data_length + index_length) > $SIZE
ORDER BY (data_length + index_length) DESC;
Show filesystem status
sudo file -s /dev/xvdf
sudo mount /dev/xvdf /backup
sudo apt-get install php5-gd php5-mysql
</pre>MAhttp://www.blogger.com/profile/15647592837919229742noreply@blogger.com0