MySQL Forums
Forum List  »  Newbie

MySQL Error Log
Posted by: Paul Grimes
Date: October 03, 2023 03:57AM

Good day all.
I have just inherited a job logging server with MySQL and PHP, it works ok but I have just looked into the error log and I see this. Is there anything I can do to fix this please?
Thank you

2023-10-03T06:30:54.452938Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-10-03T06:30:54.558007Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.43-log) starting as process 2360 ...
2023-10-03T06:30:55.018792Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-10-03T06:30:55.020517Z 0 [Note] InnoDB: Uses event mutexes
2023-10-03T06:30:55.021578Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2023-10-03T06:30:55.023003Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2023-10-03T06:30:55.024131Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
2023-10-03T06:30:55.112019Z 0 [Note] InnoDB: Number of pools: 1
2023-10-03T06:30:55.138433Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2023-10-03T06:30:55.184806Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2023-10-03T06:30:55.218762Z 0 [Note] InnoDB: Completed initialization of buffer pool
2023-10-03T06:30:55.336452Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2023-10-03T06:31:05.958974Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-10-03T06:31:05.961116Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-10-03T06:31:05.983004Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2023-10-03T06:31:05.993990Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2023-10-03T06:31:05.995767Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2023-10-03T06:31:05.998188Z 0 [Note] InnoDB: Waiting for purge to start
2023-10-03T06:31:06.060702Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10827ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2023-10-03T06:31:06.063490Z 0 [Note] InnoDB: 5.7.43 started; log sequence number 18036532027
2023-10-03T06:31:06.142710Z 0 [Note] Plugin 'FEDERATED' is disabled.
2023-10-03T06:31:06.143308Z 0 [Note] InnoDB: Loading buffer pool(s) from C:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
2023-10-03T06:31:09.315233Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2023-10-03T06:31:09.317537Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2023-10-03T06:31:09.319322Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2023-10-03T06:31:09.320869Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2023-10-03T06:31:09.583963Z 0 [Warning] CA certificate ca.pem is self signed.
2023-10-03T06:31:09.599469Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2023-10-03T06:31:09.616093Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2023-10-03T06:31:09.619686Z 0 [Note] IPv6 is available.
2023-10-03T06:31:09.620572Z 0 [Note] - '::' resolves to '::';
2023-10-03T06:31:09.621702Z 0 [Note] Server socket created on IP: '::'.
2023-10-03T06:31:10.927753Z 0 [Note] Failed to start slave threads for channel ''
2023-10-03T06:31:12.506259Z 0 [Note] Event Scheduler: Loaded 0 events
2023-10-03T06:31:12.507809Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ready for connections.

Options: ReplyQuote

Written By
MySQL Error Log
October 03, 2023 03:57AM
October 03, 2023 05:06PM

Sorry, only registered users may post in this forum.

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.