Number of processes running now: 0
080312 13:55:46  mysqld restarted
080312 13:55:46 - 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=2147483648
read_buffer_size=4190208
max_used_connections=1
max_connections=3000
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 26661128 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd=0x9910cc0
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=0x2c51e39d28, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x79726f74733374
New value of fp=0x9910cc0 failed sanity check, terminating stack trace!
Please read http://dev.mysql.com/doc/mysql/en/using-stack-trace.html and follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at (nil)  is invalid pointer
thd->thread_id=2
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.

You are running a statically-linked LinuxThreads binary on an NPTL system.
This can result in crashes on some distributions due to LT/NPTL conflicts.
You should either build a dynamically-linked binary, or force LinuxThreads
to be used with the LD_ASSUME_KERNEL environment variable. Please consult
the documentation for your distribution on how to do that.

Number of processes running now: 0
080312 13:55:46  mysqld restarted
080312 13:55:49  InnoDB: Started; log sequence number 2 417994210
080312 13:55:50 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.0.44'  socket: '/home/mysql/mysql.sock'  port: 3306  Source distribution


my.cnf 파일에 어떤부분을 설정해줘야되나요?


램은 16기가   cpu는 Intel(R) Xeon(R) CPU           E5320  @ 1.86GHz 쿼드 2개 사용중이고
os는 Red Hat Enterprise Linux AS release 4 (Nahant) 를 사용중입니다.




my.cnf 부분은

[client]
#password       = your_password
port            = 3306
socket          = /home/mysql/mysql.sock
default-character-set = euckr
# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port            = 3306
socket          = /home/mysql/mysql.sock
skip-locking
old-password = 1
default-character-set = euckr
init_connect = "set names euckr"
default-collation = euckr_bin
#init_connect = SET collation_connection = euckr_bin
character-set-server = euckr
collation-server = euckr_bin
#collation-database = euckr_bin
key_buffer_size = 2048M
max_allowed_packet = 8M
table_cache = 1800
sort_buffer_size = 4M
read_buffer_size = 4M
read_rnd_buffer_size = 16M
myisam_sort_buffer_size = 32M
thread_cache_size = 8
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
max_connections = 3000
max_connect_errors = 5000000

# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /home/mysql/data/
innodb_data_file_path = ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:2000M;ibdata5:2000M;ibdata6:2000M;ibdata7:2000M;ibdata8:2000M;ibdata9:2000M;ibdata10:2000M:autoextend
innodb_log_group_home_dir = /home/mysql/data/
innodb_log_arch_dir = /home/mysql/data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 4000M
innodb_additional_mem_pool_size = 128M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 500M
innodb_log_buffer_size = 4M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 512M
sort_buffer_size = 2M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 8M
write_buffer = 8M

[mysqlhotcopy]
interactive-timeout



주석 처리 된거 다 빼고 이렇거든요..