生成环境Mysql prepared 处理时间长求大佬指点
prepared 时间很长、其实是一个小表 里面就几条数据、有老板遇到过吗、是和我用了持久连接有关系吗
| PHP | 7.4.2 |
| Swoole | 4.5.2 |
| LaravelS | 3.7.4 |
| Laravel Framework [local] | Lumen (7.2.0) (Laravel Components ^7.0)
CREATE TABLE `tables` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'AUTO ID',
`xxx` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT ',
`xxx` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '',
`xxx` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '',
`created_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '操作人',
`created_at` datetime NOT NULL COMMENT '创建时间',
`updated_at` datetime NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='';
sql=select * from tables
time=1681.45ms detail={“pretending”:”0ms”,”prepared”:”1377.58ms”,”bindValues”:”0ms”,”execute”:”303.5ms”,”fetchAll”:”0.1ms”}
不用持久的呢 有试过吗