mysql
我叫江城
重拾博客,记录下5年php转java的心路历程,不定期整理更新
展开
-
mysql积累——长期更新
Navicat Premium 12.1.8.0安装与激活https://www.jianshu.com/p/5f693b4c9468https://www.jianshu.com/p/5f693b4c9468?mType=Grouplinux 链接mysqlmysql -uroot -h 127.0.0.1 -p分组后根据该组个数排序SELECT *,count(*) as cnt from `bftv_order` where tvSn='console' GROUP..原创 2020-06-11 18:04:18 · 197 阅读 · 0 评论 -
记一次mysql调优
首先需要明白现有配置性能,然后调优,才能量化调优量mysql原理:https://blog.csdn.net/xianqi45/article/details/78841811mysqlslap测试:http://www.ha97.com/5182.htmlhttps://blog.csdn.net/u012279631/article/details/80686633字段修改建议:select * from tem_statistics procedure analyse(1,256) ;原创 2020-06-11 17:31:22 · 152 阅读 · 0 评论