MySQL 查看单个表 大小 SELECT TABLE_NAME AS `Table`, ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)` FROM information_schema.TABLES WHERE TABLE_SCHEMA = "$DB_NAME" AND TABLE_NAME = "$TABLE_NAME" ORDER BY (DATA_LENGTH + INDEX_LENGTH) DESC; 查看前十大的表, size单位是MB select table_schema as database_name, table_name, round( (data_length + index_length) / 1024 / 1024, 2) as

在上传一个368M的zip包时，会有tengine的一个entityTooLarge的报错 调整了nginx的配置： client_max_body_size 1024m; client_body_timeout 1800s; 还是报同样的错。 碰

postgres advantages table inheritance function overloading MVCC without read locks(offers advantages to write-heavy workloads) parallel query plans can use multiple CPUs/cores create index concurrently partial indexes(like create index xxx where …) advanced data types (array, geometric/GIS, network address types, JSONB which can be indexed, native UUID, timezone-aware timestamps). postgres disadvantages (relative to mysql) less 3rd party tools read-heavy workflows

flag包 原则 标志前使用 - 和 – 都可以; 标志后带不带=都可以（bool除外） bool flag可选值： 1, 0, t, f, T, F, true, false, TRUE, FALSE, True, False 必须使用 -flag=false 的形式. （规避

排查步骤 $ df $ df -i 查看上述的block空间和inode的空间占用情况（IUse%有没有到100%） 若是inode满了，说明小文件太多，执行以