- Хроники
- Fafurion
- Исходники
- Присутствуют
- Сборка
- l2j
Парни кто в курсе столкнулся с такой херней в настройках мускула innodb_buffer_pool_size = 2512M и она + к 2 запущенным процессам логин и гейм сервера, т.е. логин берет дополнительно к 128м +2512M и гейм к 5128+2512M в итоге оперативка вся уходит, почему так получается? 1 раз с такой проблемкой столкнулся может что то в настройках упустил?
[client]
port=3306
socket=/var/run/mysqld/mysqld.sock
[mysqld_safe]
socket=/var/run/mysqld/mysqld.sock
[mysqld]
user=mysql
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/run/mysqld/mysqld.sock
port=3306
basedir=/usr
datadir=/var/lib/mysql
tmpdir=/tmp
lc-messages-dir=/usr/share/mysql
log_error=/var/log/mysql/error.log
symbolic-links=0
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 256M
table_open_cache = 256
table_cache = 128
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 0
thread_concurrency = 8
max_heap_table_size = 128M
tmp_table_size = 128M
innodb_use_sys_malloc = 0
#innodb_use_native_aio = 0
#innodb_additional_mem_pool_size=2M
innodb_file_per_table
innodb_buffer_pool_size = 1512M
innodb_read_io_threads = 4
innodb_write_io_threads = 4
innodb_thread_concurrency = 2
max_connections=700
max_user_connections=500
wait_timeout=1800000
interactive_timeout=125000
#long_query_time=50
memlock
[mysqld]
federated
!includedir /etc/mysql/conf.d/
port=3306
socket=/var/run/mysqld/mysqld.sock
[mysqld_safe]
socket=/var/run/mysqld/mysqld.sock
[mysqld]
user=mysql
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/run/mysqld/mysqld.sock
port=3306
basedir=/usr
datadir=/var/lib/mysql
tmpdir=/tmp
lc-messages-dir=/usr/share/mysql
log_error=/var/log/mysql/error.log
symbolic-links=0
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 256M
table_open_cache = 256
table_cache = 128
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 0
thread_concurrency = 8
max_heap_table_size = 128M
tmp_table_size = 128M
innodb_use_sys_malloc = 0
#innodb_use_native_aio = 0
#innodb_additional_mem_pool_size=2M
innodb_file_per_table
innodb_buffer_pool_size = 1512M
innodb_read_io_threads = 4
innodb_write_io_threads = 4
innodb_thread_concurrency = 2
max_connections=700
max_user_connections=500
wait_timeout=1800000
interactive_timeout=125000
#long_query_time=50
memlock
[mysqld]
federated
!includedir /etc/mysql/conf.d/
CPU:total 1 (initial active 1) (1 cores per cpu, 1 threads per core) family 6 model 62 stepping 4, cmov, cx8, fxsr, mmx, sse, sse2, sse3, ssse3, popcnt, avx, aes, clmul, erms, tsc
CPU Model and flags from /proc/cpuinfo:
model name : Intel(R) Xeon(R) CPU E5-2690 v2 @ 3.00GHz
ОЗУ - 12G
CPU Model and flags from /proc/cpuinfo:
model name : Intel(R) Xeon(R) CPU E5-2690 v2 @ 3.00GHz
ОЗУ - 12G