MySQL Forums
Forum List  »  Spanish

Re: Configuración MySQL 5.5 innodb
Posted by: Milton Villafuerte
Date: April 12, 2016 09:49PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Configuración MySQL 5.5 innodb
1091
April 12, 2016 09: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.