数据库
鹿指为码
努力!奋斗!
展开
-
1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
错误信息: [Err] 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'scp.m.manufacturer_id' which is not functionally dependent on columns in GROUP BY clause;...原创 2019-03-30 23:52:10 · 7939 阅读 · 0 评论 -
MYSQL修改最大连接数 ["Too many connections"]
"Too many connections" 话不多说,开始解决问题。 1.我们可以运用如下代码查看数据库当前最大连接数 show variables like '%max_connections%'; 结果如下:(PS:默认值是100,我的是已经修改好了的)。 2.再使用如下代码查看数据库当前已经连接数 show global status like 'Max_used_...原创 2018-10-06 21:40:26 · 333 阅读 · 0 评论