¿InnoDB (no realmente) fuera de memory?

MySQL sigue fallando en mi server. Estoy ejecutando varias docenas de sitios usando VestaCP y no he tenido problemas con MySQL durante meses.

Estoy funcionando en un VPS de Linode con 12GB de espolón, normalmente 9GB de él que es libre.

El logging de errores de MySQL tiene este aspecto:

160711 22:32:36 [Note] Plugin 'FEDERATED' is disabled. 160711 22:32:36 InnoDB: The InnoDB memory heap is disabled 160711 22:32:36 InnoDB: Mutexes and rw_locks use GCC atomic builtins 160711 22:32:36 InnoDB: Compressed tables use zlib 1.2.8 160711 22:32:36 InnoDB: Using Linux native AIO 160711 22:32:39 InnoDB: Initializing buffer pool, size = 1.0G InnoDB: mmap(1098907648 bytes) failed; errno 12 160711 22:32:39 InnoDB: Completed initialization of buffer pool 160711 22:32:39 InnoDB: Fatal error: cannot allocate memory for the buffer pool 160711 22:32:39 [ERROR] Plugin 'InnoDB' init function returned error. 160711 22:32:39 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 160711 22:32:39 [ERROR] Unknown/unsupported storage engine: InnoDB 160711 22:32:39 [ERROR] Aborting 160711 22:32:39 [Note] /usr/sbin/mysqld: Shutdown complete 160711 22:33:43 [Note] Plugin 'FEDERATED' is disabled. 160711 22:33:43 InnoDB: The InnoDB memory heap is disabled 160711 22:33:43 InnoDB: Mutexes and rw_locks use GCC atomic builtins 160711 22:33:43 InnoDB: Compressed tables use zlib 1.2.8 160711 22:33:43 InnoDB: Using Linux native AIO 160711 22:33:43 InnoDB: Initializing buffer pool, size = 1.0G 160711 22:33:43 InnoDB: Completed initialization of buffer pool 160711 22:33:43 InnoDB: highest supported file format is Barracuda. 

Estos sets particulares de errores parecen suceder después de emitir un command de service mysql restart .

Pasé una buena cantidad de time mirando este error en particular: Fatal error: cannot allocate memory for the buffer pool . Todo lo que encontré señaló la falta de RAM es el problema, la mayoría de la gente que tiene esto estaban en sistemas de memory extremadamente baja (512 MB o less). Obviamente, en 12GB de RAM y 9GB libre no debería haber un problema con no suficiente RAM, así que no estoy seguro de qué hacer en este caso.

Ejecutar free -h produce estos resultados:

Resultados de command-line de -h libre Además, hay una TON de inputs en los files de logging que se parecen a esto:

 160711 22:31:58 [Warning] Aborted connection 5131 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:31:58 [Warning] Aborted connection 5127 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:00 [Warning] Aborted connection 5136 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5134 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5133 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5112 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5135 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:04 [Warning] Aborted connection 5137 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:05 [Warning] Aborted connection 5140 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:31:58 [Advertencia] Abortado connection 5131 a db: 'xxxx' usuario: 'xxxx' host: 'localhost' (Got time de espera para leer los packages de comunicación) 160711 22:31:58 [Warning] Aborted connection 5131 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:31:58 [Warning] Aborted connection 5127 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:00 [Warning] Aborted connection 5136 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5134 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5133 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5112 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5135 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:04 [Warning] Aborted connection 5137 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:05 [Warning] Aborted connection 5140 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:31:58 [Advertencia] Abortado connection 5127 a db: 'xxxx' usuario: 'xxxx' host: 'localhost' (Got time de espera para leer los packages de comunicación) 160711 22:31:58 [Warning] Aborted connection 5131 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:31:58 [Warning] Aborted connection 5127 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:00 [Warning] Aborted connection 5136 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5134 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5133 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5112 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5135 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:04 [Warning] Aborted connection 5137 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:05 [Warning] Aborted connection 5140 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:00 [Advertencia] Abortado connection 5136 a db: 'xxxx' usuario: 'xxxx' host: 'localhost' (Tiempo de espera para leer los packages de comunicación) 160711 22:31:58 [Warning] Aborted connection 5131 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:31:58 [Warning] Aborted connection 5127 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:00 [Warning] Aborted connection 5136 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5134 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5133 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5112 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5135 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:04 [Warning] Aborted connection 5137 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:05 [Warning] Aborted connection 5140 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Advertencia] Abortado connection 5134 a db: 'xxxx' usuario: 'xxxx' host: 'localhost' (Got time de espera para leer los packages de comunicación) 160711 22:31:58 [Warning] Aborted connection 5131 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:31:58 [Warning] Aborted connection 5127 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:00 [Warning] Aborted connection 5136 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5134 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5133 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5112 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5135 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:04 [Warning] Aborted connection 5137 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:05 [Warning] Aborted connection 5140 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Advertencia] Abortado connection 5133 a db: 'xxxx' usuario: 'xxxx' host: 'localhost' (Tiempo de espera para leer los packages de comunicación) 160711 22:31:58 [Warning] Aborted connection 5131 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:31:58 [Warning] Aborted connection 5127 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:00 [Warning] Aborted connection 5136 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5134 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5133 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5112 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5135 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:04 [Warning] Aborted connection 5137 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:05 [Warning] Aborted connection 5140 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Advertencia] Abortado connection 5112 a db: 'xxxx' usuario: 'xxxx' host: 'localhost' (Got time de espera para leer los packages de comunicación) 160711 22:31:58 [Warning] Aborted connection 5131 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:31:58 [Warning] Aborted connection 5127 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:00 [Warning] Aborted connection 5136 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5134 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5133 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5112 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5135 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:04 [Warning] Aborted connection 5137 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:05 [Warning] Aborted connection 5140 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Advertencia] Abortado connection 5135 a db: 'xxxx' usuario: 'xxxx' host: 'localhost' (Tiempo de espera para leer los packages de comunicación) 160711 22:31:58 [Warning] Aborted connection 5131 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:31:58 [Warning] Aborted connection 5127 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:00 [Warning] Aborted connection 5136 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5134 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5133 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5112 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5135 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:04 [Warning] Aborted connection 5137 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:05 [Warning] Aborted connection 5140 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:04 [Advertencia] Abortado connection 5137 a db: 'xxxx' usuario: 'xxxx' host: 'localhost' (Tiempo de espera para leer los packages de comunicación) 160711 22:31:58 [Warning] Aborted connection 5131 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:31:58 [Warning] Aborted connection 5127 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:00 [Warning] Aborted connection 5136 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5134 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5133 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5112 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:01 [Warning] Aborted connection 5135 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:04 [Warning] Aborted connection 5137 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 160711 22:32:05 [Warning] Aborted connection 5140 to db: 'xxxx' user: 'xxxx' host: 'localhost' (Got timeout reading communication packets) 

Por último, intenté boost el tamaño de la InnoDB Buffer Pool de 512MB a 1GB y que no ha parecido ayudar. ¿Acabo de upload el tamaño de la memory intermedia hasta que deje de funcionar?

Edit: Gracias por las respuestas hasta ahora! Aquí está mi my.cnf actual:

 [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 log-warning=2 tmpdir=/tmp lc-messages-dir=/usr/share/mysql log_error=/var/log/mysql/error.log #skip-networking symbolic-links=0 skip-external-locking key_buffer_size = 16M max_allowed_packet = 256M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M #innodb_use_native_aio = 0 innodb_file_per_table max_connections=1500 max_user_connections=200 wait_timeout=10 interactive_timeout=50 long_query_time=5 innodb_log_buffer_size = 32M innodb_buffer_pool_size = 1024M innodb_log_file_size = 768M !includedir /etc/mysql/conf.d/ log-warning = 2 [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 log-warning=2 tmpdir=/tmp lc-messages-dir=/usr/share/mysql log_error=/var/log/mysql/error.log #skip-networking symbolic-links=0 skip-external-locking key_buffer_size = 16M max_allowed_packet = 256M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M #innodb_use_native_aio = 0 innodb_file_per_table max_connections=1500 max_user_connections=200 wait_timeout=10 interactive_timeout=50 long_query_time=5 innodb_log_buffer_size = 32M innodb_buffer_pool_size = 1024M innodb_log_file_size = 768M !includedir /etc/mysql/conf.d/ tmpdir = / tmp [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 log-warning=2 tmpdir=/tmp lc-messages-dir=/usr/share/mysql log_error=/var/log/mysql/error.log #skip-networking symbolic-links=0 skip-external-locking key_buffer_size = 16M max_allowed_packet = 256M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M #innodb_use_native_aio = 0 innodb_file_per_table max_connections=1500 max_user_connections=200 wait_timeout=10 interactive_timeout=50 long_query_time=5 innodb_log_buffer_size = 32M innodb_buffer_pool_size = 1024M innodb_log_file_size = 768M !includedir /etc/mysql/conf.d/ lc-posts-dir = / usr / share / mysql [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 log-warning=2 tmpdir=/tmp lc-messages-dir=/usr/share/mysql log_error=/var/log/mysql/error.log #skip-networking symbolic-links=0 skip-external-locking key_buffer_size = 16M max_allowed_packet = 256M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M #innodb_use_native_aio = 0 innodb_file_per_table max_connections=1500 max_user_connections=200 wait_timeout=10 interactive_timeout=50 long_query_time=5 innodb_log_buffer_size = 32M innodb_buffer_pool_size = 1024M innodb_log_file_size = 768M !includedir /etc/mysql/conf.d/ log_error = / var / log / mysql / error.log [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 log-warning=2 tmpdir=/tmp lc-messages-dir=/usr/share/mysql log_error=/var/log/mysql/error.log #skip-networking symbolic-links=0 skip-external-locking key_buffer_size = 16M max_allowed_packet = 256M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M #innodb_use_native_aio = 0 innodb_file_per_table max_connections=1500 max_user_connections=200 wait_timeout=10 interactive_timeout=50 long_query_time=5 innodb_log_buffer_size = 32M innodb_buffer_pool_size = 1024M innodb_log_file_size = 768M !includedir /etc/mysql/conf.d/ max_allowed_packet = 256M [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 log-warning=2 tmpdir=/tmp lc-messages-dir=/usr/share/mysql log_error=/var/log/mysql/error.log #skip-networking symbolic-links=0 skip-external-locking key_buffer_size = 16M max_allowed_packet = 256M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M #innodb_use_native_aio = 0 innodb_file_per_table max_connections=1500 max_user_connections=200 wait_timeout=10 interactive_timeout=50 long_query_time=5 innodb_log_buffer_size = 32M innodb_buffer_pool_size = 1024M innodb_log_file_size = 768M !includedir /etc/mysql/conf.d/ sort_buffer_size = 512K [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 log-warning=2 tmpdir=/tmp lc-messages-dir=/usr/share/mysql log_error=/var/log/mysql/error.log #skip-networking symbolic-links=0 skip-external-locking key_buffer_size = 16M max_allowed_packet = 256M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M #innodb_use_native_aio = 0 innodb_file_per_table max_connections=1500 max_user_connections=200 wait_timeout=10 interactive_timeout=50 long_query_time=5 innodb_log_buffer_size = 32M innodb_buffer_pool_size = 1024M innodb_log_file_size = 768M !includedir /etc/mysql/conf.d/ net_buffer_length = 8K [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 log-warning=2 tmpdir=/tmp lc-messages-dir=/usr/share/mysql log_error=/var/log/mysql/error.log #skip-networking symbolic-links=0 skip-external-locking key_buffer_size = 16M max_allowed_packet = 256M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M #innodb_use_native_aio = 0 innodb_file_per_table max_connections=1500 max_user_connections=200 wait_timeout=10 interactive_timeout=50 long_query_time=5 innodb_log_buffer_size = 32M innodb_buffer_pool_size = 1024M innodb_log_file_size = 768M !includedir /etc/mysql/conf.d/ #innodb_use_native_aio = 0 [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 log-warning=2 tmpdir=/tmp lc-messages-dir=/usr/share/mysql log_error=/var/log/mysql/error.log #skip-networking symbolic-links=0 skip-external-locking key_buffer_size = 16M max_allowed_packet = 256M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M #innodb_use_native_aio = 0 innodb_file_per_table max_connections=1500 max_user_connections=200 wait_timeout=10 interactive_timeout=50 long_query_time=5 innodb_log_buffer_size = 32M innodb_buffer_pool_size = 1024M innodb_log_file_size = 768M !includedir /etc/mysql/conf.d/ innodb_file_per_table [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 log-warning=2 tmpdir=/tmp lc-messages-dir=/usr/share/mysql log_error=/var/log/mysql/error.log #skip-networking symbolic-links=0 skip-external-locking key_buffer_size = 16M max_allowed_packet = 256M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M #innodb_use_native_aio = 0 innodb_file_per_table max_connections=1500 max_user_connections=200 wait_timeout=10 interactive_timeout=50 long_query_time=5 innodb_log_buffer_size = 32M innodb_buffer_pool_size = 1024M innodb_log_file_size = 768M !includedir /etc/mysql/conf.d/ max_connections = 1500 [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 log-warning=2 tmpdir=/tmp lc-messages-dir=/usr/share/mysql log_error=/var/log/mysql/error.log #skip-networking symbolic-links=0 skip-external-locking key_buffer_size = 16M max_allowed_packet = 256M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M #innodb_use_native_aio = 0 innodb_file_per_table max_connections=1500 max_user_connections=200 wait_timeout=10 interactive_timeout=50 long_query_time=5 innodb_log_buffer_size = 32M innodb_buffer_pool_size = 1024M innodb_log_file_size = 768M !includedir /etc/mysql/conf.d/ max_user_connections = 200 [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 log-warning=2 tmpdir=/tmp lc-messages-dir=/usr/share/mysql log_error=/var/log/mysql/error.log #skip-networking symbolic-links=0 skip-external-locking key_buffer_size = 16M max_allowed_packet = 256M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M #innodb_use_native_aio = 0 innodb_file_per_table max_connections=1500 max_user_connections=200 wait_timeout=10 interactive_timeout=50 long_query_time=5 innodb_log_buffer_size = 32M innodb_buffer_pool_size = 1024M innodb_log_file_size = 768M !includedir /etc/mysql/conf.d/ interactive_timeout = 50 [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 log-warning=2 tmpdir=/tmp lc-messages-dir=/usr/share/mysql log_error=/var/log/mysql/error.log #skip-networking symbolic-links=0 skip-external-locking key_buffer_size = 16M max_allowed_packet = 256M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M #innodb_use_native_aio = 0 innodb_file_per_table max_connections=1500 max_user_connections=200 wait_timeout=10 interactive_timeout=50 long_query_time=5 innodb_log_buffer_size = 32M innodb_buffer_pool_size = 1024M innodb_log_file_size = 768M !includedir /etc/mysql/conf.d/ long_query_time = 5 [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 log-warning=2 tmpdir=/tmp lc-messages-dir=/usr/share/mysql log_error=/var/log/mysql/error.log #skip-networking symbolic-links=0 skip-external-locking key_buffer_size = 16M max_allowed_packet = 256M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M #innodb_use_native_aio = 0 innodb_file_per_table max_connections=1500 max_user_connections=200 wait_timeout=10 interactive_timeout=50 long_query_time=5 innodb_log_buffer_size = 32M innodb_buffer_pool_size = 1024M innodb_log_file_size = 768M !includedir /etc/mysql/conf.d/ innodb_log_buffer_size = 32M [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 log-warning=2 tmpdir=/tmp lc-messages-dir=/usr/share/mysql log_error=/var/log/mysql/error.log #skip-networking symbolic-links=0 skip-external-locking key_buffer_size = 16M max_allowed_packet = 256M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M #innodb_use_native_aio = 0 innodb_file_per_table max_connections=1500 max_user_connections=200 wait_timeout=10 interactive_timeout=50 long_query_time=5 innodb_log_buffer_size = 32M innodb_buffer_pool_size = 1024M innodb_log_file_size = 768M !includedir /etc/mysql/conf.d/ innodb_buffer_pool_size = 1024M [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 log-warning=2 tmpdir=/tmp lc-messages-dir=/usr/share/mysql log_error=/var/log/mysql/error.log #skip-networking symbolic-links=0 skip-external-locking key_buffer_size = 16M max_allowed_packet = 256M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M #innodb_use_native_aio = 0 innodb_file_per_table max_connections=1500 max_user_connections=200 wait_timeout=10 interactive_timeout=50 long_query_time=5 innodb_log_buffer_size = 32M innodb_buffer_pool_size = 1024M innodb_log_file_size = 768M !includedir /etc/mysql/conf.d/ innodb_log_file_size = 768M [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 log-warning=2 tmpdir=/tmp lc-messages-dir=/usr/share/mysql log_error=/var/log/mysql/error.log #skip-networking symbolic-links=0 skip-external-locking key_buffer_size = 16M max_allowed_packet = 256M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M #innodb_use_native_aio = 0 innodb_file_per_table max_connections=1500 max_user_connections=200 wait_timeout=10 interactive_timeout=50 long_query_time=5 innodb_log_buffer_size = 32M innodb_buffer_pool_size = 1024M innodb_log_file_size = 768M !includedir /etc/mysql/conf.d/ 

Su búfer innodb es demasiado pequeño. Usted necesita boostlo y como 4 otros parameters innodb. Básicamente, le dices al motor innodb en la configuration de mysql cuánto carnero obtiene. Presumiblemente esto es para evitar que sucedan cosas horribles a sus datos si la máquina se queda sin memory RAM.

Si usted tiene un montón de tablas innodb que la piscina de amortiguación realmente muy grande, como idealmente puede ser del tamaño de todos sus datos innodb comúnmente utilizados. Ya que no tengo la configuration de mysql he hecho para mi último trabajo, me olvido de todas las opciones de configuration innodb_.

InnoDB / MySQL no puede asignar 1G por alguna razón. Al mismo time, free -h muestra un poco de memory libre. Eso significa que algo dentro de mysql o fuera de mysql que asigna memory. El my.cnf anterior no muestra ninguna asignación de memory adicional, pero tiene esto incluye: "! Includedir /etc/mysql/conf.d/" Compruebe el contenido de este directory y compruebe si hay otros files (excepto debian .cnf, que es sólo passwords) que tienen algunas opciones de configuration. También puede intentar iniciar MySQL y ver "superior" y comprobar el crecimiento de la memory virtual.

Otras posibilidades son:

  1. cachings del sistema de files. Añadir innodb_flush_method = O_DIRECT a my.cnf
  2. Esquema de performance en 5.6 / 5.7 puede comer 1G o más. Pruebe con performance_schema = 0 (agregue a my.cnf)