We are in the process of migrating this forum. A new space will be available soon. We are sorry for the inconvenience.

[MYSQL] Imposible ampliar "max_connections"


copitodenieve
08/08/2015, 20:48
Ya amplié el número de conexiones en linux, pero a pesar de seguir todo al pie de la letra me da error mysql, y lo vuelve por defecto a 214

Ros
04/08/2015, 19:10
Donde tienes que ampliar el numero de archivos abiertos es en Linux.

+ Info: http://www.cyberciti.biz/faq/linux-i...of-open-files/

copitodenieve
03/08/2015, 13:48
https://www.mysql.com/common/logos/l...ql-170x115.png

Buenos días, he instalado mysql 5 y debido a la creciente demanda de usuarios me veo en la obligación de ampliar el número de conexiones permitidas por mysql en este caso por defecto 214

He probado ya a ampliar la variable "max_connections" en /etc/mysql/mysql.conf.d/mysqld.cnf pero al reiniciar mysql me dice que
debo ampliar el número máximo de archivos abiertos, lo cual he intentando pero no me funciona, os adjunto mi config,
estoy usando usuario root

http://pastebin.com/aUTXMJm2 <--- mysqld.cnf


y el error que me da en el log de mysql:
Código:
150803 12:26:08 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150803 12:26:08 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2015-08-03 12:26:08 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-08-03 12:26:08 0 [Note] /usr/sbin/mysqld (mysqld 5.6.24-0ubuntu2) starting as process 8770 ...
2015-08-03 12:26:08 8770 [Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 10000)

2015-08-03 12:26:08 8770 [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 2000)

2015-08-03 12:26:08 8770 [Warning] Buffered warning: Changed limits: table_open_cache: 400 (requested 2000)

2015-08-03 12:26:08 8770 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2015-08-03 12:26:08 8770 [Note] Plugin 'FEDERATED' is disabled.
2015-08-03 12:26:08 8770 [ERROR] Function 'innodb' already exists
2015-08-03 12:26:08 8770 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2015-08-03 12:26:08 8770 [ERROR] Function 'federated' already exists
2015-08-03 12:26:08 8770 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2015-08-03 12:26:08 8770 [ERROR] Function 'blackhole' already exists
2015-08-03 12:26:08 8770 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2015-08-03 12:26:08 8770 [ERROR] Function 'archive' already exists
2015-08-03 12:26:08 8770 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2015-08-03 12:26:08 8770 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-08-03 12:26:08 8770 [Note] InnoDB: The InnoDB memory heap is disabled
2015-08-03 12:26:08 8770 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-08-03 12:26:08 8770 [Note] InnoDB: Memory barrier is not used
2015-08-03 12:26:08 8770 [Note] InnoDB: Compressed tables use zlib 1.2.8
2015-08-03 12:26:08 8770 [Note] InnoDB: Using Linux native AIO
2015-08-03 12:26:08 8770 [Note] InnoDB: Using CPU crc32 instructions
2015-08-03 12:26:08 8770 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-08-03 12:26:08 8770 [Note] InnoDB: Completed initialization of buffer pool
2015-08-03 12:26:08 8770 [Note] InnoDB: Highest supported file format is Barracuda.
2015-08-03 12:26:08 8770 [Note] InnoDB: 128 rollback segment(s) are active.
2015-08-03 12:26:08 8770 [Note] InnoDB: Waiting for purge to start
2015-08-03 12:26:08 8770 [Note] InnoDB: 5.6.24 started; log sequence number 10310483225
Sin nada más que decir me despido, gracias y espero su ayuda.