【讨论中】mysql数据库运行过程中报错：Out of memory

gevermis

mysql数据库运行过程中报错：
ERROR 1041 (00000): Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space

mysql服务重启又正常，请教各位了.
[root@sdgovvod ~]# grep -v "#"  /etc/my.cnf

[client]
port            = 3306
socket          = /tmp/mysql.sock

[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
skip-locking
back_log = 300

key_buffer = 512M
max_allowed_packet = 64M
table_cache = 2048
sort_buffer_size = 10M
net_buffer_length = 10M
read_buffer_size = 10M
read_rnd_buffer_size = 10M
myisam_sort_buffer_size = 128M
skip-name-resolve

thread_cache_size = 256
thread_stack = 226976
join_buffer_size = 10M
query_cache_size = 1024M
max_connections = 1500
max_connect_errors = 999999999
open_files_limit = 4096
skip-innodb
interactive_timeout = 20
wait_timeout = 20
net_read_timeout =20

skip-federated
log-bin=mysql-bin
server-id       = 1
innodb_buffer_pool_size = 126M
[mysqldump]
quick
max_allowed_packet = 64M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 10M
write_buffer = 10M
[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 10M
write_buffer = 10M
[mysqlhotcopy]
interactive-timeout
skip-name-resolve

小版主杀手

物理内存有多大
多大的数据量 并发

a.a

还有可能是不科学的sql，取出大量的结果用光了内存空间。
之前碰到过一次。一app，将10多万条记录取出来放到2G内存里面，最后当然是应用挂了。

wenhq

ERROR 1041 (00000): Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
错误的提示：用free看下是否有availabe memory 如有没有，是否有ulimit或者swap大小的调整。

chinafenghao

@gevermis
1、扩大系统的swamp空间
2、
join_buffer_size = 10M
sort_buffer_size = 10M
net_buffer_length = 10M
read_buffer_size = 10M
read_rnd_buffer_size = 10M
myisam_sort_buffer_size = 128M
这些是每个session都会分配,如果并发大，这些值全部改小。