4-1.测试MySql数据量优化

CREATE TABLE `r_sku_storage_goods` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `sku_id` bigint NOT NULL COMMENT 'SKU ID',
  `storage_id` bigint NOT NULL DEFAULT '0' COMMENT '库点ID',
  `section_id` bigint NOT NULL DEFAULT '0' COMMENT '库区ID',
  `bin_id` bigint NOT NULL DEFAULT '0' COMMENT '库位ID',
  `goods_identity_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '物品识别码',
  `processing_plan_receipt_id` bigint NOT NULL COMMENT '加工单ID',
  `batch_number` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '批号',
  `expiry_date` date NOT NULL COMMENT '有效期',
  `production_date` date DEFAULT NULL COMMENT '生产日期',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '物品状态：1-正常使用 0-删除',
  `purchase_price` decimal(10,2) DEFAULT NULL COMMENT '采购价格',
  `trace_storage_id` bigint NOT NULL DEFAULT '0' COMMENT '追溯库点ID(用来记录出库前所在的库点)',
  `consume_time` datetime DEFAULT NULL COMMENT '消耗时间',
  `settlement_time` datetime DEFAULT NULL COMMENT '结算时间',
  `create_user` bigint NOT NULL COMMENT '创建人ID',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间,默认当前时间',
  `update_user` bigint DEFAULT NULL COMMENT '最后修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '最后修改时间',
  `remark` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_sku_storage_goods_goodsIdentityCode` (`goods_identity_code`),
  KEY `idx_sku_storage_goods_skuid` (`sku_id`) USING BTREE,
  KEY `idx_sku_storage_goods_storageid` (`storage_id`) USING BTREE,
  KEY `idx_sku_storage_goods_expirydate` (`expiry_date`) USING BTREE,
  KEY `status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='仓库物品表';

ALTER TABLE r_sku_storage_goods ADD INDEX (status);