Table Size Estimator
Estimate table disk usage from schema and row count
Table Size Estimator is a free online Developer tool. Estimate table disk usage from schema and row count Related terms: 表大小 · 估算 · 存储 · 行数 · 数据类型 · 磁盘. Use it on this page without signing in.
| 列名 | 数据类型 | 参数（n / p,s） | 字节数 | |
|---|---|---|---|---|
| — | 8 | |||
| 194 | ||||
| 386 | ||||
| — | 8 | |||
| — | 500 |
基于 MySQL InnoDB 数据类型字节大小估算。VARCHAR 按 UTF-8 最大 3 字节/字符计算；TEXT/JSON/BLOB 使用可配置的均值。实际占用受引擎压缩、NULL 位图、碎片等因素影响，仅供参考。
使用说明
- 定义表的列结构（列名 + 数据类型）
- 输入预估行数
- 自动计算每行字节数、总数据大小、含索引和开销的估算总大小
常见问题
- 估算准确吗？ 基于数据类型的理论字节数，实际占用因引擎和压缩而异
- 索引占多少？ 一般索引大小约为数据大小的 20%-50%
- VARCHAR 怎么算？ 按实际存储长度计算，UTF-8 中文约 3 字节/字符
More Developer
View allJSON Formatter
Format, minify, validate JSON, convert to Go struct / TS interface
JSON Field Search
Search JSON by field, value or path with highlights, supports jq expressions
Timestamp Converter
Convert between Unix timestamps and dates, seconds and milliseconds
Cron Expression
Generate and parse cron expressions, preview next run time
UUID Generator
Generate UUID v4 / v7 / ULID / NanoID
Hash Calculator
Compute MD5 / SHA1 / SHA256 / SHA512 of text or files
JWT Decoder
Decode JWT header and payload, view expiry time
URL Encoder / Decoder
Encode and decode URL / URI components
FAQ about Table Size Estimator
What can Table Size Estimator do?
Table Size Estimator is a Developer tool. Estimate table disk usage from schema and row count You can finish the job on this page.
Who should use Table Size Estimator?
Anyone handling 表大小 · 估算 · 存储 · 行数 · 数据类型 · 磁盘 who does not want to install desktop software can use Table Size Estimator in the browser.
Is Table Size Estimator safe? Is my data uploaded?
This tool runs in your browser. We do not collect the content you enter into Table Size Estimator just because you used it.
What similar tools exist?
Related tools in the same Developer group are listed at the bottom of this page.