안녕하세요..

mysql서버를 운영중에 메모리 에러가 발생했습니다..  

기존 서버에서 3년 정도 운영후에  새서버로 이전한지 한 6개월 정도 되어 갑니다.

그리고 운영중에 이 에러가 발생한건 처음입니다.

에러 메세지는 다음과 같습니다.

------------------------------------

071129 8:31:01 - mysqld got signal 11;

This could be because you hit a bug. It is also possible that this binary

or one of the libraries it was linked against is corrupt, improperly built,

or misconfigured. This error can also be caused by malfunctioning hardware.

We will try our best to scrape up some info that will hopefully help diagnose

the problem, but since we have already crashed, something is definitely wrong

and this may fail.

key_buffer_size=6442450944

read_buffer_size=4190208

max_used_connections=1028

max_connections=2048

threads_connected=4

It is possible that mysqld could use up to

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 31449072 K

bytes of memory

Hope that's ok; if not, decrease some variables in the equation.

thd=0x2bd7a626d0

Attempting backtrace. You can use the following information to find out

where mysqld died. If you see no messages after this, something went

terribly wrong...

Cannot determine thread, fp=0x400, backtrace may not be correct.

Bogus stack limit or frame pointer, fp=0x400, stack_bottom=0x479d0000, thread_stack=196608, aborting backtrace.

Trying to get some variables.

Some pointers may be invalid and cause the dump to abort...

thd->query at 0x2bdacceb70 is invalid pointer

thd->thread_id=187731897

The manual page at http://www.mysql.com/doc/en/Crashing.html contains

information that should help you find out what is causing the crash.

Number of processes running now: 0

071129 08:31:01 mysqld restarted

071129 8:31:02 [ERROR] /data/local/mysql/bin/mysqld: Table './mysql/user' is marked as crashed and should be repaired

071129 8:31:02 [Warning] Checking table: './mysql/user'

071129 8:31:02 [ERROR] 1 client is using or hasn't closed the table properly

---------------------------------------------------- 

운영하드웨어 스펙은 Dell PowerEdge 2950(quad-core) 에 cent4.5버전을 사용중입니다.

메모리는 

[root@db1 data]# free -m

total used free shared buffers cached

Mem: 16030 10185 5845 0 750 5059

-/+ buffers/cache: 4375 11655

Swap: 0 0 0 

문제가 생긴 시점의 시스템 하드웨어적인 부하는 그런건 sar로 본봐로는 거의 없었고요. 그

 시점대에 클론으로 정산처리를 하고 있었는데.. 잘못된 쿼리로  이런 문제가 발생할수 있나요??