MySAL crashes constantly, log included

[Alexandra1]

MySql crashes constantly, and won't run. I tried to reinstall Xamp, but it continues to happen. I use the latest build.

Code: Select all

2022-10-07  1:01:06 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-10-07  1:01:06 0 [Note] InnoDB: Waiting for purge to start
2022-10-07  1:01:06 0 [Note] InnoDB: 10.4.24 started; log sequence number 300414; transaction id 170
2022-10-07  1:01:06 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-10-07  1:01:06 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-10-07  1:01:06 0 [Note] Server socket created on IP: '::'.
2022-10-07  1:01:12 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-10-07  1:01:12 0 [Note] InnoDB: Uses event mutexes
2022-10-07  1:01:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-10-07  1:01:12 0 [Note] InnoDB: Number of pools: 1
2022-10-07  1:01:12 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-10-07  1:01:12 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-10-07  1:01:12 0 [Note] InnoDB: Completed initialization of buffer pool
2022-10-07  1:01:13 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-10-07  1:01:13 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-10-07  1:01:13 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

[Alexandra1]

Is there anything in the log that could help? I have no idea what causes it...

I did fix it by reading stackoverflow: I delete all the files with @@@ in them, in the mysql/data folder. When i delete them, MySQL starts normally again. But as of the cause... I have no clue.

[Froosh]

This appears to happen from time to time if you are not running MySQL as a Windows Service. You can repair the databases when it happens, or use XAMPP's Control Panel to configure MySQL to run as a Windows Service.

After having database issues occasionally over several months, and correcting the issue, I switched to using MySQL as a Windows Service. It has now been almost half a year since making that change, and I have not encountered any issues related to MySQL since then. Highly recommended change in my view.

[Alexandra1]

This appears to happen from time to time if you are not running MySQL as a Windows Service. You can repair the databases when it happens, or use XAMPP's Control Panel to configure MySQL to run as a Windows Service.

After having database issues occasionally over several months, and correcting the issue, I switched to using MySQL as a Windows Service. It has now been almost half a year since making that change, and I have not encountered any issues related to MySQL since then. Highly recommended change in my view.

How do you run it as a service?

[Nobbie]

Simply by putting a cross to the option in the Xampp Control Panel. Its in front of each service.