MySQL服务器报错求助

seoyou

服务器2，3天出现一次报错

1.too many connections ,这事情发生在早上7点，不太可能是在线人数过多引起的。

2. Out of memory ( Sort Needed 2.9M)
my.cnf设置如下
sort_buffer_size = 2M
key_buffer = 400M

请问该怎么设置呢？这问题是什么呢？

MySQL4.1

Coolriver

sort_buffer_size =3M

=======================
LZ能拿到那个时间的定时任务或是相应的SQL，看看什么查询的排序需要这么多内存，关注一下。

seoyou

thankyou for Coolriver's answer

but i don't know how to get the sql at that time. can't you tell me how to get the sql at that time point? thx

seoyou

is the reason  sql include a large amount of 'order by or group by'?
perhaps i need to check the sql which used order by and group by .

小木虫子

我以前也遇到过这个问题。

你出现问题时检查一下 show full processlist;

我以前是有一个SQL语句查询出了问题，频繁锁表，导致了你上面的那个错误。后来让PHP程序员修改后，好了。