【TDengine 使用环境】
生产环境 /测试/ Poc/预生产环境
【TDengine 版本】3.3.2.0
【操作系统以及版本】ubuntu
【部署方式】非容器部署
【集群节点数】1
【集群副本数】0
【描述业务影响】磁盘增长太快
【问题复现路径/shan】使用宽表设计导致磁盘暴涨
【遇到的问题：问题现象及影响】实际查询表数据不多但是磁盘占用了 250G
【资源配置】
【报错完整截图】（不要大段的粘贴报错代码，论坛直接看报错代码不直观）
db stable Total_Size Total_Size_KiB Total_Tables Block_Rows Compression Total_Blocks Total_Filesets
mes_transound daas_curve_3a1ca6e05e28f9f6e53d085615b657bb 448881.78 KiB 448881.78 4458 1742756 20.34 % 741 111
mes_transound daas_curve_3a1ca6e05c8179eb4fd761f04ed07b3d 524208.88 KiB 524208.88 1312 2033117 11.87 % 1018 111
mes_transound iot_device_data_log 622618.89 KiB 622618.89 798 56274884 2.71 % 57177 111
mes_transound daas_curve_cols 1779.23 KiB 1779.23 789 192965 0.01 % 1411 111
mes_transound daas_curve_data_test 3428.81 KiB 3428.81 411 3386 7.42 % 24 111
mes_transound daas_curve_3a1bce9c7ee920efd16bc2450fd24d1a 350114.46 KiB 350114.46 127 1779993 17.35 % 678 111
mes_transound daas_curve_3a198c4cabd269da995173a39084deeb 236504.65 KiB 236504.65 104 543000 41.26 % 221 111
mes_transound daas_curve_3a172e6bc00b314499161d3a2c4b8f93 116155.05 KiB 116155.05 99 525163 30.08 % 253 111
mes_transound iot_device_status_log 23610.25 KiB 23610.25 82 8564607 3.14 % 31430 111
mes_transound equipment_output_log 29.26 KiB 29.26 69 16996 6.30 % 29 111
mes_transound daas_curve_3a172e7aefe65ce11160346ace6c64da 321504.29 KiB 321504.29 54 900879 40.03 % 308 111
mes_transound daas_curve_3a1b6184c2f557ad0b99cb9d94361124 338587.45 KiB 338587.45 48 781441 41.04 % 265 111
mes_transound daas_curve_3a172e5af434728ab0972534dd19130b 105338.01 KiB 105338.01 35 318161 29.20 % 165 111
mes_transound daas_curve_3a172e874c2cc8e93ba0f4b784fcc943 130731.14 KiB 130731.14 29 365031 40.17 % 134 111
mes_transound daas_curve_3a1895f5e74f5020d4c5b66780b115de 57919.35 KiB 57919.35 26 166024 39.13 % 85 111
mes_transound daas_curve_3a198794a062f52ec4f137831fc49f0d 146248.96 KiB 146248.96 25 335034 41.35 % 124 111
mes_transound daas_curve_3a1d2655cb0a48a9e43c4f733ce81742 196787.37 KiB 196787.37 23 509545 40.48 % 168 111
mes_transound daas_curve_3a1b6184c46dfb7d7a9e87e62025aaf1 63919.22 KiB 63919.22 22 146360 41.37 % 57 111
mes_transound daas_curve_3a209c53726cf94fd055c013abb6c86f 11068.57 KiB 11068.57 21 59987 25.09 % 52 111
mes_transound daas_curve_3a172e6f43c7a31cbd340b8e3be75313 125674.14 KiB 125674.14 20 348543 37.79 % 116 111
mes_transound daas_curve_3a1969302a876ec56e194a817251e738 243959.12 KiB 243959.12 20 669897 36.10 % 221 111
mes_transound daas_curve_3a1b6184c5d0763a0b93230e64958832 38094.56 KiB 38094.56 17 87640 43.09 % 45 111
mes_transound daas_curve_3a172e65a54e3553279ae2e7923d3c02 58169.57 KiB 58169.57 15 154977 42.10 % 53 111
mes_transound daas_curve_3a185daec2408330bce1b23fd49bb6c3 129486.40 KiB 129486.40 13 327653 36.89 % 110 111
mes_transound daas_curve_3a172e777ae5cda0551303a1fdf87bcd 29629.14 KiB 29629.14 11 80467 31.39 % 27 111
mes_transound daas_curve_3a1bfba4e6de6b2ec5c461ea27bb6e56 6242.60 KiB 6242.60 10 17338 40.38 % 14 111
mes_transound daas_curve_3a1ea8c9c059d500067468ce9d6f3f51 1389.26 KiB 1389.26 10 4412 26.15 % 10 111
mes_transound daas_curve_3a20633ea38b39319fd65a198fab2426 9131.06 KiB 9131.06 10 24477 41.84 % 18 111
mes_transound daas_curve_3a172e8402a9d00812cb32c8b115fd68 8894.08 KiB 8894.08 8 23262 38.80 % 19 111
mes_transound daas_curve_3a20eeb8321edfe8d4389339c6406fe4 1293.05 KiB 1293.05 7 7476 29.87 % 7 111
mes_transound daas_curve_3a172e23a77e7d1ebd47abefad6eb2d1 6451.61 KiB 6451.61 7 34568 28.74 % 14 111
mes_transound daas_curve_3a20633ea1cbbb099ebdfc91545f96b7 1093.46 KiB 1093.46 7 2516 48.74 % 9 111
mes_transound daas_curve_3a1fb502176fca5e1609146ea4a91376 29793.05 KiB 29793.05 7 143661 28.20 % 61 111
mes_transound daas_curve_3a2372055cd8c3b22bbd5e9d57efcc37 209.03 KiB 209.03 7 721 43.59 % 7 111
mes_transound daas_curve_3a172e595c17dfeeca56397b59ad1572 340.51 KiB 340.51 7 1414 38.47 % 7 111
mes_transound daas_curve_3a214afcc3a2c9df6e24fe1c3be90e18 540.97 KiB 540.97 6 1174 51.68 % 6 111
mes_transound daas_curve_3a2007d627dfdd7b78be9ff1b730c22e 7864.18 KiB 7864.18 6 22476 39.24 % 12 111
mes_transound daas_curve_3a21cd06449af9bde39155c3dc65d8a7 50778.38 KiB 50778.38 6 140726 40.47 % 40 111
mes_transound daas_curve_3a172e7cb44921a2ba8d5156bc908c68 5372.18 KiB 5372.18 5 13946 38.19 % 5 111
mes_transound daas_curve_3a172e89fe465b39f8b534ee3ce6a340 34586.73 KiB 34586.73 5 94900 34.52 % 29 111
mes_transound daas_curve_3a172e7a38665d7434f32a3707c846a1 10145.48 KiB 10145.48 5 26384 43.13 % 12 111
mes_transound daas_curve_3a172e83ff39bba88f335b0db06136d3 35806.10 KiB 35806.10 5 99212 36.63 % 33 111
mes_transound daas_curve_3a214afcc5879ae17ff1feaf6a61951c 453.21 KiB 453.21 5 979 51.92 % 4 111
mes_transound daas_curve_3a1efb9d92dade6c7fdcdb5b2234fa2e 3047.32 KiB 3047.32 5 6934 41.63 % 5 111
mes_transound daas_curve_3a1895f5e3e6e8c427c92240b93f35fd 38799.90 KiB 38799.90 5 106102 34.64 % 37 111
mes_transound daas_curve_3a187b9c8f912259f61e2764b7c0e0f5 25987.17 KiB 25987.17 4 62353 38.62 % 22 111
mes_transound daas_curve_3a1858c343530eec13f0ae3a2beece81 12485.98 KiB 12485.98 4 26980 43.84 % 15 111
mes_transound daas_curve_3a21ebecbb5bb656d6e5ecf874ae3651 12806.51 KiB 12806.51 4 27856 46.66 % 16 111
mes_transound daas_curve_3a1e6a58524edf3bbd2dd2bec65c045e 948.31 KiB 948.31 4 2454 43.34 % 4 111
mes_transound daas_curve_3a172e77e5e2fefb5562441113ac8650 19544.14 KiB 19544.14 4 52558 32.35 % 18 111
mes_transound daas_curve_3a172e79ba56b4c8dcbe9b245c454dd3 8683.50 KiB 8683.50 4 23630 34.05 % 10 111
mes_transound daas_curve_3a19985477c45f4dd9331d8037da181d 0.00 KiB 0.00 3 0 0.00 % 0 111
mes_transound daas_curve_3a221442a12b6b364648608cc64920d8 0.00 KiB 0.00 3 0 0.00 % 0 111
mes_transound daas_curve_3a172e895d1515c93f0f4fd775b4f93a 106.41 KiB 106.41 3 518 23.04 % 1 111
mes_transound daas_curve_3a2214429e24aa9550ddd0195f49dd80 0.00 KiB 0.00 3 0 0.00 % 0 111
mes_transound daas_curve_3a213bf7d9f8f7db3dafee02f052afcb 827.98 KiB 827.98 3 1725 45.47 % 3 111
mes_transound daas_curve_3a199854ae79e418e04a25a87ede4fc3 497.99 KiB 497.99 3 1389 40.21 % 3 111
mes_transound daas_curve_3a172e1a0e9340a7752df8a7348828fc 742.11 KiB 742.11 3 1983 41.97 % 3 57
mes_transound daas_curve_3a1ff71932e53156dcd21080d9209554 2223.24 KiB 2223.24 3 5076 41.49 % 3 111
mes_transound daas_curve_3a22a09815db343d4dcfbf9f0d838a02 1964.64 KiB 1964.64 3 9216 29.94 % 3 111
mes_transound daas_curve_3a1902d69bbbd93adc8cd421a51ad5bf 4494.29 KiB 4494.29 3 12078 41.73 % 6 111
mes_transound daas_curve_3a1956bb1e0bb4ae74649bd76bb2631a 10117.84 KiB 10117.84 3 27283 35.13 % 11 111
mes_transound daas_curve_3a1956b995af8fcdfd7efa1683350b1f 230.45 KiB 230.45 3 516 42.31 % 3 56
mes_transound daas_curve_3a217fc67b98ad07ee3a8b5a3518df9f 1249.67 KiB 1249.67 3 3344 34.63 % 3 56
mes_transound daas_curve_3a172e7a1049dc8e0b16598f828ff210 5521.21 KiB 5521.21 3 14968 41.37 % 6 111
mes_transound daas_curve_3a20e4da424318d43a5f18f4cb342e94 4929.53 KiB 4929.53 3 11223 41.61 % 8 111
mes_transound daas_curve_3a21998720760d1de73a370c1f582100 338.71 KiB 338.71 3 965 39.37 % 2 111
mes_transound daas_curve_3a172e8c71c8532ceb4dcd5073d1f507 399.24 KiB 399.24 2 987 38.32 % 1 111
mes_transound daas_curve_3a18c9de5064b4201313bd56e8c4b11e 2221.68 KiB 2221.68 2 5970 41.74 % 4 56
mes_transound daas_curve_3a172e824d01b2b82593f4857a0b6ea7 5706.97 KiB 5706.97 2 15995 33.06 % 5 57
mes_transound daas_curve_3a172e8825a104ae8c3cf6e0ad9d497d 828.22 KiB 828.22 2 2059 45.11 % 2 57
mes_transound daas_curve_3a172e791f617a96b6c2644b2a5f4663 3363.39 KiB 3363.39 2 8317 45.36 % 3 111
mes_transound daas_curve_3a172e6f21e92d854f61251b1ce593ab 845.28 KiB 845.28 2 2023 46.86 % 3 111
mes_transound daas_curve_3a239159c24944e92a3336c170f98a86 2104.49 KiB 2104.49 2 5572 42.36 % 4 111
mes_transound daas_curve_3a1ea8cd0694498365ad5cc8bab96946 0.00 KiB 0.00 2 0 0.00 % 0 56
mes_transound daas_curve_3a172e77e20f5a1ed18a84ef4e3cffc1 8606.45 KiB 8606.45 2 23455 31.92 % 8 111
mes_transound daas_curve_3a1efc0b774b03d5f056e761a973f92f 4347.18 KiB 4347.18 2 9575 37.71 % 4 57
mes_transound daas_curve_3a213bf7d7ec6b157dff1f4c6b8e0142 3298.37 KiB 3298.37 2 7514 43.51 % 4 56
mes_transound daas_curve_3a1d83084f7b80b1d8bdff1912b909cd 15721.08 KiB 15721.08 2 43407 40.62 % 13 111
mes_transound daas_curve_3a172e81eece3fef829fb255960d4e19 1076.46 KiB 1076.46 2 2846 42.42 % 2 111
mes_transound daas_curve_3a172e7ab010b14115b90694c3356089 1753.08 KiB 1753.08 2 4586 42.87 % 3 111
mes_transound daas_curve_3a172e77822b23f5cbbf270b1ef151e6 1762.79 KiB 1762.79 2 2935 59.54 % 23 111
mes_transound daas_curve_3a172e89cd2b20e38fe020e45b82f7a5 1163.37 KiB 1163.37 2 1948 59.20 % 15 111
mes_transound daas_curve_3a172e83fe4b483105da2a2737453b52 2097.62 KiB 2097.62 2 5720 41.13 % 3 111
mes_transound daas_curve_3a172e8002c2e31df7ee50654b06878f 7064.13 KiB 7064.13 2 16376 43.78 % 6 56
mes_transound daas_curve_3a172e8254a9fdda6a6e80d570ffd20c 4611.46 KiB 4611.46 2 10228 44.69 % 4 56
mes_transound daas_curve_3a1d5a961384fee6119d5e8b49ddb149 1358.60 KiB 1358.60 2 3680 41.41 % 2 57
mes_transound daas_curve_3a1efb9d95fad1fabacd8d026a5d2b5d 2753.74 KiB 2753.74 2 6134 44.50 % 4 56
mes_transound daas_curve_3a19e0ea8dd16ad735eca13b5ac566c2 0.00 KiB 0.00 2 0 0.00 % 0 56
mes_transound daas_curve_3a22ed6a26eda7aa05eee65e786828e0 2044.40 KiB 2044.40 2 5037 42.54 % 5 111
mes_transound daas_curve_3a172e807f9aff9aca205c58fa661aa6 3071.48 KiB 3071.48 2 6910 45.11 % 4 57
mes_transound daas_curve_3a172e7decea309d5ce7f6a437ed3d8d 1553.24 KiB 1553.24 2 3954 44.06 % 4 56
mes_transound daas_curve_3a1d8e156d863e613c0ef5d682c45493 1555.37 KiB 1555.37 1 4218 37.42 % 2 56
mes_transound daas_curve_3a19e0c57d65aaf7f7c86d9058b1614e 20098.71 KiB 20098.71 1 56584 39.84 % 18 57
mes_transound daas_curve_3a172e7ccac33d2b66a2900e7ece13d5 2073.56 KiB 2073.56 1 5479 42.45 % 2 56
mes_transound daas_curve_3a172e62ae0a3d9698ecfe906a211b4c 907.69 KiB 907.69 1 2513 40.51 % 1 57
mes_transound daas_curve_3a172e79bb10224cf7913779e53e8983 294.22 KiB 294.22 1 739 44.65 % 1 56
mes_transound daas_curve_3a19e0d0720d3b511b19ea0a9a7c918f 524.22 KiB 524.22 1 1327 44.31 % 1 56
mes_transound daas_curve_3a1e23a533d4ff3e47d80495de8ee447 573.62 KiB 573.62 1 1460 37.22 % 1 56
mes_transound daas_curve_3a216f0973c10bf7163f6a10619f5885 2182.83 KiB 2182.83 1 5838 35.42 % 3 56
mes_transound daas_curve_3a1c82663a1b79bcdda3776ed409bbe8 3282.17 KiB 3282.17 1 8075 45.59 % 3 57
mes_transound daas_curve_3a1ead4b42d3c70dd32ddbc360b30a05 0.00 KiB 0.00 1 0 0.00 % 0 57
mes_transound daas_curve_3a1ea8ca7ec645beb1f7d97d651abfc7 141.88 KiB 141.88 1 308 51.66 % 1 56
mes_transound daas_curve_3a172e75f961b86db10606bb8405e1fd 293.72 KiB 293.72 1 697 47.26 % 1 56
mes_transound daas_curve_3a172e883576e9e3333abd6f0330b1f7 4572.03 KiB 4572.03 1 12657 40.51 % 4 56
mes_transound daas_curve_3a172e87d1ef03ebee27cf5e9baceae1 321.81 KiB 321.81 1 805 44.84 % 1 57
mes_transound daas_curve_3a185c67dd41384143f57741d688c01f 0.00 KiB 0.00 1 0 0.00 % 0 56
mes_transound daas_curve_3a172e6f2eed628cd1dbb002e828f844 2098.28 KiB 2098.28 1 4440 43.79 % 2 56
mes_transound daas_curve_3a18c9de3d2f22babbca5db01cb286d1 2736.34 KiB 2736.34 1 7388 41.54 % 3 56
mes_transound daas_curve_3a21cc98c95f9692b7c65928e19e1486 15979.88 KiB 15979.88 1 43881 36.96 % 12 56
mes_transound daas_curve_3a172e31d14bad39c51044fd4dae96bd 739.16 KiB 739.16 1 1836 45.15 % 2 57
mes_transound daas_curve_3a1e6a3d122816e0e2f7d40bad1507d3 316.00 KiB 316.00 1 767 46.21 % 1 57
mes_transound daas_curve_3a172e74d56da87025e67bc3427af9c5 81.06 KiB 81.06 1 168 54.12 % 1 57
mes_transound daas_curve_3a172e7c81a5b1fb283121e3c58d07b8 1986.14 KiB 1986.14 1 5617 39.66 % 2 57
mes_transound daas_curve_3a221442beb77ace25907545aed2fb2b 54.15 KiB 54.15 1 107 56.76 % 1 56
mes_transound daas_curve_3a172e648687095e5e52751d22808040 158.92 KiB 158.92 1 341 52.27 % 2 57
mes_transound daas_curve_3a1ff33c7703c49854e2e6bb3a4640d6 866.48 KiB 866.48 1 1801 53.96 % 14 56
mes_transound daas_curve_3a221442bb67a81f1c1c2eade30f6344 0.00 KiB 0.00 1 0 0.00 % 0 57
mes_transound daas_curve_3a1e0e13ec699784efef42edd3628d07 6757.96 KiB 6757.96 1 14449 43.34 % 5 57
mes_transound daas_curve_3a172e7aacafe032cdfd9019767a37ee 111.25 KiB 111.25 1 244 51.14 % 1 56
mes_transound daas_curve_3a172e77f323f8a159e9d8b84cedded9 179.51 KiB 179.51 1 344 52.96 % 1 57
mes_transound daas_curve_3a1ea8c9db7dadc711ab7970687a36af 0.00 KiB 0.00 1 0 0.00 % 0 57
mes_transound daas_curve_3a1b618b2b14c1ae3782aea46ffe13cf 0.00 KiB 0.00 1 0 0.00 % 0 56
mes_transound daas_curve_3a1ea8c9d81f4fc311c332bb25edfd86 1858.54 KiB 1858.54 1 4442 43.85 % 3 56
mes_transound daas_curve_3a22a099b61bf52da6e9524c860a76df 610.05 KiB 610.05 1 1553 44.06 % 1 57
mes_transound daas_curve_3a19e0db15deb71bf7da1e24721250cf 0.00 KiB 0.00 1 0 0.00 % 0 56
mes_transound daas_curve_3a238d0f1e1ac1d80df95cf61f7152f9 2011.08 KiB 2011.08 1 5332 42.30 % 3 56
mes_transound daas_curve_3a172e6d40fecace000b6f011065185d 4696.94 KiB 4696.94 1 14865 35.44 % 4 57
link_gtl iot_device_data_log 1310719.34 KiB 1310719.34 2006 153264273 2.10 % 431936 112
link_gtl equipment_output_log 10517.59 KiB 10517.59 968 2410028 15.96 % 2982 112
link_gtl snapshot_3a197caf5e449d370dc013479587f7eb 22160.94 KiB 22160.94 180 127982 1.07 % 383 112
link_gtl iot_device_status_log 69592.71 KiB 69592.71 118 31638357 2.50 % 42380 112
link_gtl snapshot_e0331fed8a674e2abd02eea7a7c14816 19158.28 KiB 19158.28 92 108197 1.06 % 375 112
link_gtl snapshot_bdb8d34cddf7475aa337c2397bea4375 14473.25 KiB 14473.25 85 789938 7.27 % 455 112
link_gtl snapshot_3a197cb11552b30a8911e5431f703535 9279.92 KiB 9279.92 78 52483 1.09 % 191 112
link_gtl snapshot_3a197cb03fa49a73e41af38a096aad7f 25197.67 KiB 25197.67 74 141144 1.68 % 595 112
link_gtl snapshot_3a1c962a387e305dec4630560d5f09d5 9214.63 KiB 9214.63 68 39662 1.32 % 216 112
link_gtl snapshot_6ac1b8411f1c4d8bb31de2023f1e89a5 6643.67 KiB 6643.67 42 29087 2.31 % 179 112
link_gtl snapshot_3a1664ff834c0a10e92f84f3db054a5a 207.62 KiB 207.62 24 6961 1.77 % 37 112
link_gtl snapshot_e82d3ea395934f60a0f47cf0a89a2f4a 9883.49 KiB 9883.49 20 54136 1.13 % 187 112
link_gtl snapshot_3a1ed77f617a59c70bfeca371f4e1bf6 0.00 KiB 0.00 2 0 0.00 % 0 57
link_gtl snapshot_3a18e315e0c566fd6e69abfda37234e9 47.89 KiB 47.89 1 108 1.14 % 1 57
mes_grandview iot_device_data_log 29877.86 KiB 29877.86 45 2797044 2.62 % 1110 18
mes_grandview iot_device_status_log 558.77 KiB 558.77 9 354919 1.79 % 255 18
执行如下的命令，查看一下存储结构：
show table distributed 超级表名;
我这个版本好像不知道怎么定位哪一张表很大
这样信息显示不全，在后面加一个 \G
show table distributed 超级表名\G;
taos> show table distributed daas_curve_3a172e5af434728ab0972534dd19130b\G;
*************************** 1.row ***************************
_block_dist: Total_Blocks=[165] Total_Size=[105338.01 KiB] Average_size=[638.41 KiB] Compression_Ratio=[29.20 %]
*************************** 2.row ***************************
_block_dist: Block_Rows=[318161] MinRows=[102] MaxRows=[4096] AvgRows=[1928]
*************************** 3.row ***************************
_block_dist: Inmem_Rows=[0] Stt_Rows=[0]
*************************** 4.row ***************************
_block_dist: Total_Tables=[35] Total_Filesets=[111] Total_Vgroups=[2]
*************************** 5.row ***************************
_block_dist: --------------------------------------------------------------------------------
*************************** 6.row ***************************
_block_dist: 0300 ||||||| 14 (8.48%)
*************************** 7.row ***************************
_block_dist: 0500 ||| 5 (3.03%)
*************************** 8.row ***************************
_block_dist: 0700 |||||| 11 (6.67%)
*************************** 9.row ***************************
_block_dist: 0900 |||||| 11 (6.67%)
*************************** 10.row ***************************
_block_dist: 1100 |||||||||||||||||| 37 (22.42%)
*************************** 11.row ***************************
_block_dist: 1300 ||| 5 (3.03%)
*************************** 12.row ***************************
_block_dist: 1500 |
*************************** 13.row ***************************
_block_dist: 1700 | 2 (1.21%)
*************************** 14.row ***************************
_block_dist: 1900 || 3 (1.82%)
*************************** 15.row ***************************
_block_dist: 2100 |||||| 12 (7.27%)
*************************** 16.row ***************************
_block_dist: 2300 |||||| 12 (7.27%)
*************************** 17.row ***************************
_block_dist: 2500 | 2 (1.21%)
*************************** 18.row ***************************
_block_dist: 2700 |
*************************** 19.row ***************************
_block_dist: 2900 ||||||| 13 (7.88%)
*************************** 20.row ***************************
_block_dist: 3100 |
*************************** 21.row ***************************
_block_dist: 3300 |
*************************** 22.row ***************************
_block_dist: 3500 |
*************************** 23.row ***************************
_block_dist: 3700 |
*************************** 24.row ***************************
_block_dist: 3900 || 3 (1.82%)
*************************** 25.row ***************************
_block_dist: 4100 ||||||||||||||||| 35 (21.21%)
Query OK, 25 row(s) in set (0.013159s)
taos>
找几张数据量写入大的 超级表看看
taos> show table distributed daas_curve_3a1969302a876ec56e194a817251e738\G;
*************************** 1.row ***************************
_block_dist: Total_Blocks=[221] Total_Size=[243959.12 KiB] Average_size=[1103.89 KiB] Compression_Ratio=[36.10 %]
*************************** 2.row ***************************
_block_dist: Block_Rows=[669897] MinRows=[159] MaxRows=[4096] AvgRows=[3031]
*************************** 3.row ***************************
_block_dist: Inmem_Rows=[0] Stt_Rows=[174]
*************************** 4.row ***************************
_block_dist: Total_Tables=[20] Total_Filesets=[111] Total_Vgroups=[2]
*************************** 5.row ***************************
_block_dist: --------------------------------------------------------------------------------
*************************** 6.row ***************************
_block_dist: 0300 || 3 (1.36%)
*************************** 7.row ***************************
_block_dist: 0500 || 3 (1.36%)
*************************** 8.row ***************************
_block_dist: 0700 | 2 (0.90%)
*************************** 9.row ***************************
_block_dist: 0900 |
*************************** 10.row ***************************
_block_dist: 1100 |
*************************** 11.row ***************************
_block_dist: 1300 | 2 (0.90%)
*************************** 12.row ***************************
_block_dist: 1500 || 3 (1.36%)
*************************** 13.row ***************************
_block_dist: 1700 | 2 (0.90%)
*************************** 14.row ***************************
_block_dist: 1900 |
*************************** 15.row ***************************
_block_dist: 2100 ||| 6 (2.71%)
*************************** 16.row ***************************
_block_dist: 2300 ||| 8 (3.62%)
*************************** 17.row ***************************
_block_dist: 2500 |||||||||||||||||||||| 60 (27.15%)
*************************** 18.row ***************************
_block_dist: 2700 ||||| 12 (5.43%)
*************************** 19.row ***************************
_block_dist: 2900 ||| 6 (2.71%)
*************************** 20.row ***************************
_block_dist: 3100 |||| 10 (4.52%)
*************************** 21.row ***************************
_block_dist: 3300 ||| 8 (3.62%)
*************************** 22.row ***************************
_block_dist: 3500 |||| 10 (4.52%)
*************************** 23.row ***************************
_block_dist: 3700 ||| 6 (2.71%)
*************************** 24.row ***************************
_block_dist: 3900 |||| 11 (4.98%)
*************************** 25.row ***************************
_block_dist: 4100 ||||||||||||||||||||||||| 69 (31.22%)
Query OK, 25 row(s) in set (0.012694s)
taos>
写入数据后，每个块中保存的表的数据不是很满，块中有不少空闲空间，导致出现这种情况。
解决方法的话：一是 等每个表攒得足够多后，写入一次，让每个块中尽量能够填满。
二是还是按照现在方式写入，使用compact 重整命令，来合并块中的数据，释放出多余的块，这样减少存储空间。但compact 只有企业版才支持。
企业版年费是多少，按机子收费？
具体情况请与我们商务对接。是否需要给一个联系方式？或者您留个联系方式，让我们商务联系您？
收到。我们商务会联系您的