求学至北方，混迹于南洋. 欢迎来到自由兰博的世界
show table size on mysql
- run this query to get the sizes of all tables in a mysql database:
sql show table status from `DBname`
- You can use this query to show the size of a table (although you need to substitute the variables first):
sql SELECT table_schema as `Database`, table_name AS `Table`, round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` FROM information_schema.TABLES ORDER BY (data_length + index_length) DESC;
Analysis
Here I took an example of weather data table. From method 2, I got a table size with 17.55 MB.
Through select count I obtain the row numbers 164164. Hence, the average size of each row is 112 Byte.
In case of we have 1000 devices collecting data per second, each device has 10 parameters we need to store. So we are going to handle 10 * 1000 * 24 * 60 * 60
864 Million rows. If multiply 112 Byte then total data size is 92.3 GB data per day.
2017年10月11日12:27:52 跟IT大佬曹政老师交流后，更新
朱渊博，特普通一人，渊为深，博为广，一直努力做一个有深度有广度的人。多混迹于Github, Stackoverflow, ITeye, 知乎, Linkedin 等地带。蹉跎中练就了一身码农好本领。 酷爱编程，但绝不宅。爱生活，爱思考，性情温和但充满激情，做事有主见，信奉读万卷书行万里路。 http://www.freerambo.com/about