i installed xampp-win32-1.7.7-VC9-installer.exe on a windowsxp sp3. An older 1.7.1 is working perfectly on it but it was time to update.
Problem: even without making any modification to *any* configuration file, if i start/stop mysql from the ControlPanel, i get this in the mysql_error log:
111204 14:58:20 [Note] Plugin 'FEDERATED' is disabled.
111204 14:58:20 InnoDB: The InnoDB memory heap is disabled
111204 14:58:20 InnoDB: Mutexes and rw_locks use Windows interlocked functions
111204 14:58:20 InnoDB: Compressed tables use zlib 1.2.3
111204 14:58:20 InnoDB: Initializing buffer pool, size = 16.0M
111204 14:58:20 InnoDB: Completed initialization of buffer pool
111204 14:58:20 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
111204 14:58:20 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
111204 14:58:21 InnoDB: Waiting for the background threads to start
111204 14:58:22 InnoDB: 1.1.8 started; log sequence number 1595675
111204 14:58:22 [Note] Event Scheduler: Loaded 0 events
111204 14:58:22 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16' socket: '' port: 3306 MySQL Community Server (GPL)
And this happens on *every* start/stop from the control panel. This is surely not normal. bin-log is not enabled in my.ini.
This is a fresh install (I uninstalled and reinstalled just to be sure it was not my fault).
The first entry was this (if it matters):
- Code: Select all
111204 14:57:22 [Note] Plugin 'FEDERATED' is disabled.
111204 14:57:22 InnoDB: The InnoDB memory heap is disabled
111204 14:57:22 InnoDB: Mutexes and rw_locks use Windows interlocked functions
111204 14:57:22 InnoDB: Compressed tables use zlib 1.2.3
111204 14:57:22 InnoDB: Initializing buffer pool, size = 16.0M
111204 14:57:22 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file D:\xampp1.7.7\mysql\data\ibdata1 did not exist:
InnoDB: a new database to be created!
111204 14:57:22 InnoDB: Setting file D:\xampp1.7.7\mysql\data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
111204 14:57:23 InnoDB: Log file D:\xampp1.7.7\mysql\data\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file D:\xampp1.7.7\mysql\data\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
111204 14:57:23 InnoDB: Log file D:\xampp1.7.7\mysql\data\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file D:\xampp1.7.7\mysql\data\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
111204 14:57:25 InnoDB: Waiting for the background threads to start
111204 14:57:26 InnoDB: 1.1.8 started; log sequence number 0
111204 14:57:26 [Note] Event Scheduler: Loaded 0 events
111204 14:57:26 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16' socket: '' port: 3306 MySQL Community Server (GPL)
PS: on old 1.7.1 in the mysql_error log, when stopping the server it said:
111204 13:13:44 [Note] Event Scheduler: Purging the queue. 0 events
111204 13:13:44 InnoDB: Starting shutdown...
111204 13:13:46 InnoDB: Shutdown completed; log sequence number 0 301151805
111204 13:13:46 [Warning] Forcing shutdown of 1 plugins
111204 13:13:46 [Note] mysql\bin\mysqld.exe: Shutdown complete
PS2: mysql is not installed as a service !