vassili wrote:any inputs???
After installing and uninstalling once or twice a day now...I have come to the conclusion that for anything other than maybe emulating small websites and having a hobbyist situation, trying to use xampp for what I am trying to do is like bringing a rubber knife to a gunfight.
My attempts to bring into xampp a 4.1 gigg InnoDB have nothing but failed using (2) machines.
Dell 1300 dual 600 w/1 gig of ram and HP Probook 6550b with 4gig of ram and have used all mysql configurations included with the package.
Jim
Below is 2nd attempt for the day (after new install) using HP 6550b machine and the InnoDB - ini file supplied with xampp 1.8.0
- Code: Select all
140102 20:21:21 [Note] Plugin 'FEDERATED' is disabled.
140102 20:21:21 InnoDB: The InnoDB memory heap is disabled
140102 20:21:21 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140102 20:21:21 InnoDB: Compressed tables use zlib 1.2.3
140102 20:21:21 InnoDB: Initializing buffer pool, size = 2.0G
InnoDB: VirtualAlloc(2175795200 bytes) failed; Windows error 87
140102 20:21:21 InnoDB: Completed initialization of buffer pool
140102 20:21:21 InnoDB: Fatal error: cannot allocate memory for the buffer pool
140102 20:21:21 [ERROR] Plugin 'InnoDB' init function returned error.
140102 20:21:21 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140102 20:21:21 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140102 20:21:21 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140102 20:21:21 [Note] Server socket created on IP: '0.0.0.0'.
140102 20:21:21 [ERROR] c:\xampp\mysql\bin\mysqld.exe: Table '.\mysql\db' is marked as crashed and should be repaired
140102 20:21:21 [Warning] Checking table: '.\mysql\db'
140102 20:21:21 [ERROR] 1 client is using or hasn't closed the table properly
140102 20:21:21 [ERROR] c:\xampp\mysql\bin\mysqld.exe: Table '.\mysql\tables_priv' is marked as crashed and should be repaired
140102 20:21:21 [Warning] Checking table: '.\mysql\tables_priv'
140102 20:21:21 [ERROR] 1 client is using or hasn't closed the table properly
140102 20:21:21 [ERROR] c:\xampp\mysql\bin\mysqld.exe: Table '.\mysql\columns_priv' is marked as crashed and should be repaired
140102 20:21:21 [Warning] Checking table: '.\mysql\columns_priv'
140102 20:21:21 [ERROR] 1 client is using or hasn't closed the table properly
140102 20:21:21 [Note] Event Scheduler: Loaded 0 events
140102 20:21:21 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.25a-log' socket: '' port: 3306 MySQL Community Server (GPL)
140102 20:21:24 [Note] c:\xampp\mysql\bin\mysqld.exe: Normal shutdown
140102 20:21:24 [Note] Event Scheduler: Purging the queue. 0 events
140102 20:21:24 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete
140102 20:21:26 [Note] Plugin 'FEDERATED' is disabled.
140102 20:21:26 InnoDB: The InnoDB memory heap is disabled
140102 20:21:26 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140102 20:21:26 InnoDB: Compressed tables use zlib 1.2.3
140102 20:21:26 InnoDB: Initializing buffer pool, size = 2.0G
InnoDB: VirtualAlloc(2175795200 bytes) failed; Windows error 87
140102 20:21:26 InnoDB: Completed initialization of buffer pool
140102 20:21:26 InnoDB: Fatal error: cannot allocate memory for the buffer pool
140102 20:21:26 [ERROR] Plugin 'InnoDB' init function returned error.
140102 20:21:26 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140102 20:21:26 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140102 20:21:26 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140102 20:21:26 [Note] Server socket created on IP: '0.0.0.0'.
140102 20:21:26 [Note] Event Scheduler: Loaded 0 events
140102 20:21:26 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.25a-log' socket: '' port: 3306 MySQL Community Server (GPL)
140102 22:11:40 [Note] Plugin 'FEDERATED' is disabled.
140102 22:11:43 InnoDB: The InnoDB memory heap is disabled
140102 22:11:43 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140102 22:11:43 InnoDB: Compressed tables use zlib 1.2.3
140102 22:11:44 InnoDB: Initializing buffer pool, size = 2.0G
InnoDB: VirtualAlloc(2175795200 bytes) failed; Windows error 87
140102 22:11:44 InnoDB: Completed initialization of buffer pool
140102 22:11:44 InnoDB: Fatal error: cannot allocate memory for the buffer pool
140102 22:11:44 [ERROR] Plugin 'InnoDB' init function returned error.
140102 22:11:44 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140102 22:11:45 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140102 22:11:45 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140102 22:11:45 [Note] Server socket created on IP: '0.0.0.0'.
140102 22:11:51 [Note] Event Scheduler: Loaded 0 events
140102 22:11:51 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.25a-log' socket: '' port: 3306 MySQL Community Server (GPL)
[EDIT by Altrea: splitted from original topic for the following reasons]
- OP was 4 years old
- topic is now unrelated to OP
- one thread per unique user and issue rule