Re: Configuración MySQL 5.5 innodb
Gracias nuevamente,
En efecto, al momento de cambiar esos dos parametros borro los archivos log para que pueda volver a iniciar el servicio de mysql.
Cual es el tamaño máximo que puedo colocar en el pool_size considerando que mi S.O. es Windows server 2008 de 64bits, pero la versión del mysql es 5.5.48 de 32bits?
Hice el cambio que me sugeriste al poner 2048M en el pool_size, sin embargo el problema continua, no sé cómo solucionarlo, detalle del error:
160412 22:39:21 [Note] Plugin 'FEDERATED' is disabled.
160412 22:39:21 InnoDB: The InnoDB memory heap is disabled
160412 22:39:21 InnoDB: Mutexes and rw_locks use Windows interlocked functions
160412 22:39:21 InnoDB: Compressed tables use zlib 1.2.3
160412 22:39:21 InnoDB: Initializing buffer pool, size = 2.0G
InnoDB: VirtualAlloc(2175795200 bytes) failed; Windows error 8
160412 22:39:21 InnoDB: Completed initialization of buffer pool
160412 22:39:21 InnoDB: Fatal error: cannot allocate memory for the buffer pool
160412 22:39:21 [ERROR] Plugin 'InnoDB' init function returned error.
160412 22:39:21 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
160412 22:39:21 [ERROR] Unknown/unsupported storage engine: INNODB
160412 22:39:21 [ERROR] Aborting
Muchas gracias
Subject
Views
Written By
Posted
1254
April 11, 2016 01:30PM
673
April 11, 2016 04:39PM
1718
April 11, 2016 07:35PM
866
April 12, 2016 08:49PM
Re: Configuración MySQL 5.5 innodb
1091
April 12, 2016 09:49PM
832
April 14, 2016 02:50PM
843
April 14, 2016 04:38PM
877
April 14, 2016 06:41PM
823
April 14, 2016 07:49PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.