· 4 years ago · Mar 24, 2021, 12:08 PM
1LOG FILE:
2
3C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.23 (MySQL Community Server - GPL). started with:
4TCP Port: 3306, Named Pipe: MySQL
5Time Id Command Argument
62021-03-24T03:46:35.442247Z 8 Connect root@localhost on using SSL/TLS
72021-03-24T03:46:35.442432Z 8 Query SELECT @@max_allowed_packet, @@character_set_client,
8 @@character_set_connection, @@license, @@sql_mode, @@lower_case_table_names
92021-03-24T03:46:35.442650Z 8 Query SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP())
102021-03-24T03:46:35.442871Z 8 Query SHOW COLLATION
112021-03-24T03:46:35.446944Z 8 Query SET NAMES utf8mb4
122021-03-24T03:46:35.447017Z 8 Query SET character_set_results=NULL
132021-03-24T03:46:35.447084Z 8 Quit
142021-03-24T03:47:04.094247Z 9 Connect root@localhost on using SSL/TLS
152021-03-24T03:47:04.094343Z 9 Query set autocommit=1
162021-03-24T03:47:04.094450Z 9 Query SHOW SESSION VARIABLES LIKE 'lower_case_table_names'
172021-03-24T03:47:04.099334Z 9 Query SELECT current_user()
182021-03-24T03:47:04.100171Z 9 Query SET CHARACTER SET utf8
192021-03-24T03:47:04.100303Z 9 Query SET NAMES utf8
202021-03-24T03:47:04.100409Z 9 Query SHOW SESSION VARIABLES LIKE 'sql_mode'
212021-03-24T03:47:04.102279Z 9 Query SELECT CONNECTION_ID()
222021-03-24T03:47:04.102397Z 9 Query show character set where charset = 'utf8mb4'
232021-03-24T03:47:04.103374Z 9 Query SET NAMES 'utf8mb4'
242021-03-24T03:47:04.103758Z 9 Query SHOW SESSION STATUS LIKE 'Ssl_cipher'
252021-03-24T03:47:04.105091Z 9 Query set autocommit=1
262021-03-24T03:47:04.108381Z 10 Connect root@localhost on using SSL/TLS
272021-03-24T03:47:04.108482Z 10 Query set autocommit=1
282021-03-24T03:47:04.108582Z 10 Query SHOW SESSION VARIABLES LIKE 'lower_case_table_names'
292021-03-24T03:47:04.110232Z 10 Query SELECT current_user()
302021-03-24T03:47:04.110325Z 10 Query SET CHARACTER SET utf8
312021-03-24T03:47:04.110400Z 10 Query SET NAMES utf8
322021-03-24T03:47:04.110460Z 10 Query SET SQL_SAFE_UPDATES=1
332021-03-24T03:47:04.110514Z 10 Query SELECT CONNECTION_ID()
342021-03-24T03:47:04.110590Z 10 Query show character set where charset = 'utf8mb4'
352021-03-24T03:47:04.110950Z 10 Query SET NAMES 'utf8mb4'
362021-03-24T03:47:04.111038Z 10 Query SHOW SESSION STATUS LIKE 'Ssl_cipher'
372021-03-24T03:47:04.111851Z 10 Query set autocommit=1
382021-03-24T03:47:04.111978Z 10 Query SHOW SESSION VARIABLES LIKE 'sql_mode'
392021-03-24T03:47:04.113427Z 10 Query SHOW SESSION VARIABLES LIKE 'version_comment'
402021-03-24T03:47:04.114697Z 10 Query SHOW SESSION VARIABLES LIKE 'version'
412021-03-24T03:47:04.116125Z 10 Query SELECT current_user()
422021-03-24T03:47:04.116420Z 10 Query SHOW SESSION VARIABLES LIKE 'lower_case_table_names'
432021-03-24T03:47:04.420320Z 10 Query show engines
442021-03-24T03:47:04.420393Z 9 Query SHOW DATABASES
452021-03-24T03:47:04.420586Z 10 Query show charset
462021-03-24T03:47:04.420972Z 10 Query show collation
472021-03-24T03:47:04.422768Z 10 Query show variables
482021-03-24T03:47:04.424718Z 10 Query SHOW SESSION VARIABLES LIKE 'version_compile_os'
492021-03-24T03:47:04.425964Z 10 Query SHOW SESSION VARIABLES LIKE 'offline_mode'
502021-03-24T03:47:04.439358Z 10 Query SHOW SESSION VARIABLES LIKE 'wait_timeout'
512021-03-24T03:47:04.440596Z 10 Query SHOW SESSION VARIABLES LIKE 'interactive_timeout'
522021-03-24T03:47:08.563157Z 10 Quit
532021-03-24T03:47:08.563278Z 9 Quit
542021-03-24T03:47:24.187326Z 11 Connect root2@192.168.88.65 on using SSL/TLS
552021-03-24T03:47:24.187705Z 11 Query set autocommit=1
562021-03-24T03:47:24.188062Z 11 Query SHOW SESSION VARIABLES LIKE 'lower_case_table_names'
572021-03-24T03:47:24.189865Z 11 Query SELECT current_user()
582021-03-24T03:47:24.190233Z 11 Query SET CHARACTER SET utf8
592021-03-24T03:47:24.190589Z 11 Query SET NAMES utf8
602021-03-24T03:47:24.190940Z 11 Query SHOW SESSION VARIABLES LIKE 'sql_mode'
612021-03-24T03:47:24.192489Z 11 Query SELECT CONNECTION_ID()
622021-03-24T03:47:24.192891Z 11 Query show character set where charset = 'utf8mb4'
632021-03-24T03:47:24.193626Z 11 Query SET NAMES 'utf8mb4'
642021-03-24T03:47:24.194032Z 11 Query SHOW SESSION STATUS LIKE 'Ssl_cipher'
652021-03-24T03:47:24.194837Z 11 Query set autocommit=1
662021-03-24T03:47:24.225490Z 12 Connect root2@192.168.88.65 on using SSL/TLS
672021-03-24T03:47:24.225810Z 12 Query set autocommit=1
682021-03-24T03:47:24.226139Z 12 Query SHOW SESSION VARIABLES LIKE 'lower_case_table_names'
692021-03-24T03:47:24.227731Z 12 Query SELECT current_user()
702021-03-24T03:47:24.228080Z 12 Query SET CHARACTER SET utf8
712021-03-24T03:47:24.228437Z 12 Query SET NAMES utf8
722021-03-24T03:47:24.228783Z 12 Query SET SQL_SAFE_UPDATES=1
732021-03-24T03:47:24.229093Z 12 Query SELECT CONNECTION_ID()
742021-03-24T03:47:24.229444Z 12 Query show character set where charset = 'utf8mb4'
752021-03-24T03:47:24.230094Z 12 Query SET NAMES 'utf8mb4'
762021-03-24T03:47:24.230452Z 12 Query SHOW SESSION STATUS LIKE 'Ssl_cipher'
772021-03-24T03:47:24.231220Z 12 Query set autocommit=1
782021-03-24T03:47:24.231562Z 12 Query SHOW SESSION VARIABLES LIKE 'sql_mode'
792021-03-24T03:47:24.233046Z 12 Query SHOW SESSION VARIABLES LIKE 'version_comment'
802021-03-24T03:47:24.234519Z 12 Query SHOW SESSION VARIABLES LIKE 'version'
812021-03-24T03:47:24.236637Z 12 Query SELECT current_user()
822021-03-24T03:47:24.237030Z 12 Query SHOW SESSION VARIABLES LIKE 'lower_case_table_names'
832021-03-24T03:47:24.351504Z 11 Query SHOW DATABASES
842021-03-24T03:47:24.351614Z 12 Query show engines
852021-03-24T03:47:24.352378Z 12 Query show charset
862021-03-24T03:47:24.353354Z 12 Query show collation
872021-03-24T03:47:24.356672Z 12 Query show variables
882021-03-24T03:47:24.360726Z 12 Query SHOW SESSION VARIABLES LIKE 'version_compile_os'
892021-03-24T03:47:24.362207Z 12 Query SHOW SESSION VARIABLES LIKE 'offline_mode'
902021-03-24T03:47:24.367809Z 12 Query SHOW SESSION VARIABLES LIKE 'wait_timeout'
912021-03-24T03:47:24.372583Z 12 Query SHOW SESSION VARIABLES LIKE 'interactive_timeout'
922021-03-24T03:47:26.737930Z 12 Quit
932021-03-24T03:47:26.738138Z 11 Quit
94C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.23 (MySQL Community Server - GPL). started with:
95TCP Port: 3306, Named Pipe: MySQL
96Time Id Command Argument
97C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.23 (MySQL Community Server - GPL). started with:
98TCP Port: 3306, Named Pipe: MySQL
99Time Id Command Argument
100C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.23 (MySQL Community Server - GPL). started with:
101TCP Port: 3306, Named Pipe: MySQL
102Time Id Command Argument
1032021-03-24T04:48:40.834490Z 8 Connect root@localhost on using SSL/TLS
1042021-03-24T04:48:40.834640Z 8 Query set autocommit=1
1052021-03-24T04:48:40.835001Z 8 Query SHOW SESSION VARIABLES LIKE 'lower_case_table_names'
1062021-03-24T04:48:40.840738Z 8 Query SELECT current_user()
1072021-03-24T04:48:40.841789Z 8 Query SET CHARACTER SET utf8
1082021-03-24T04:48:40.841933Z 8 Query SET NAMES utf8
1092021-03-24T04:48:40.842066Z 8 Query SHOW SESSION VARIABLES LIKE 'sql_mode'
1102021-03-24T04:48:40.843992Z 8 Query SELECT CONNECTION_ID()
1112021-03-24T04:48:40.844132Z 8 Query show character set where charset = 'utf8mb4'
1122021-03-24T04:48:40.845873Z 8 Query SET NAMES 'utf8mb4'
1132021-03-24T04:48:40.846253Z 8 Query SHOW SESSION STATUS LIKE 'Ssl_cipher'
1142021-03-24T04:48:40.847555Z 8 Query set autocommit=1
1152021-03-24T04:48:40.850995Z 9 Connect root@localhost on using SSL/TLS
1162021-03-24T04:48:40.851085Z 9 Query set autocommit=1
1172021-03-24T04:48:40.851169Z 9 Query SHOW SESSION VARIABLES LIKE 'lower_case_table_names'
1182021-03-24T04:48:40.852822Z 9 Query SELECT current_user()
1192021-03-24T04:48:40.852908Z 9 Query SET CHARACTER SET utf8
1202021-03-24T04:48:40.852981Z 9 Query SET NAMES utf8
1212021-03-24T04:48:40.853040Z 9 Query SET SQL_SAFE_UPDATES=1
1222021-03-24T04:48:40.853104Z 9 Query SELECT CONNECTION_ID()
1232021-03-24T04:48:40.853209Z 9 Query show character set where charset = 'utf8mb4'
1242021-03-24T04:48:40.853636Z 9 Query SET NAMES 'utf8mb4'
1252021-03-24T04:48:40.853787Z 9 Query SHOW SESSION STATUS LIKE 'Ssl_cipher'
1262021-03-24T04:48:40.854686Z 9 Query set autocommit=1
1272021-03-24T04:48:40.854778Z 9 Query SHOW SESSION VARIABLES LIKE 'sql_mode'
1282021-03-24T04:48:40.856356Z 9 Query SHOW SESSION VARIABLES LIKE 'version_comment'
1292021-03-24T04:48:40.857772Z 9 Query SHOW SESSION VARIABLES LIKE 'version'
1302021-03-24T04:48:40.859432Z 9 Query SELECT current_user()
1312021-03-24T04:48:40.859529Z 9 Query SHOW SESSION VARIABLES LIKE 'lower_case_table_names'
1322021-03-24T04:48:41.215395Z 9 Query show engines
1332021-03-24T04:48:41.215460Z 8 Query SHOW DATABASES
1342021-03-24T04:48:41.215670Z 9 Query show charset
1352021-03-24T04:48:41.216135Z 9 Query show collation
1362021-03-24T04:48:41.219634Z 9 Query show variables
1372021-03-24T04:48:41.221765Z 9 Query SHOW SESSION VARIABLES LIKE 'version_compile_os'
1382021-03-24T04:48:41.223078Z 9 Query SHOW SESSION VARIABLES LIKE 'offline_mode'
1392021-03-24T04:48:41.236299Z 9 Query SHOW SESSION VARIABLES LIKE 'wait_timeout'
1402021-03-24T04:48:41.237731Z 9 Query SHOW SESSION VARIABLES LIKE 'interactive_timeout'
1412021-03-24T04:49:09.635050Z 9 Quit
1422021-03-24T04:49:09.635132Z 8 Quit
143C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.23 (MySQL Community Server - GPL). started with:
144TCP Port: 3306, Named Pipe: MySQL
145Time Id Command Argument
1462021-03-24T07:17:01.707529Z 8 Connect root2@cedieasd on using SSL/TLS
1472021-03-24T07:17:01.720167Z 8 Query SELECT @@max_allowed_packet, @@character_set_client,
148 @@character_set_connection, @@license, @@sql_mode, @@lower_case_table_names
1492021-03-24T07:17:01.731467Z 8 Query SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP())
1502021-03-24T07:17:01.733450Z 8 Query SHOW COLLATION
1512021-03-24T07:17:01.755915Z 8 Query SET NAMES utf8mb4
1522021-03-24T07:17:01.756122Z 8 Query SET character_set_results=NULL
1532021-03-24T07:17:05.544356Z 8 Quit
154C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.23 (MySQL Community Server - GPL). started with:
155TCP Port: 3306, Named Pipe: MySQL
156Time Id Command Argument
1572021-03-24T10:10:50.028314Z 8 Connect root@localhost on using SSL/TLS
1582021-03-24T10:10:50.028808Z 8 Query select @@version_comment limit 1
1592021-03-24T10:11:00.201705Z 8 Query SELECT DATABASE()
1602021-03-24T10:11:00.201855Z 8 Init DB mysql
1612021-03-24T10:11:07.476643Z 8 Query select user, host from user
162C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.23 (MySQL Community Server - GPL). started with:
163TCP Port: 3306, Named Pipe: MySQL
164Time Id Command Argument
1652021-03-24T10:47:05.816745Z 8 Connect root@localhost on using SSL/TLS
1662021-03-24T10:47:05.832205Z 8 Query SELECT @@max_allowed_packet, @@character_set_client,
167 @@character_set_connection, @@license, @@sql_mode, @@lower_case_table_names
1682021-03-24T10:47:05.845953Z 8 Query SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP())
1692021-03-24T10:47:05.847828Z 8 Query SHOW COLLATION
1702021-03-24T10:47:05.854506Z 8 Query SET NAMES utf8mb4
1712021-03-24T10:47:05.854696Z 8 Query SET character_set_results=NULL
1722021-03-24T10:47:05.859285Z 8 Quit
1732021-03-24T10:47:43.081213Z 9 Connect root@localhost on using SSL/TLS
1742021-03-24T10:47:43.093754Z 9 Query SELECT @@max_allowed_packet, @@character_set_client,
175 @@character_set_connection, @@license, @@sql_mode, @@lower_case_table_names
1762021-03-24T10:47:43.106426Z 9 Query SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP())
1772021-03-24T10:47:43.108505Z 9 Query SHOW COLLATION
1782021-03-24T10:47:43.112433Z 9 Query SET NAMES utf8mb4
1792021-03-24T10:47:43.112640Z 9 Query SET character_set_results=NULL
1802021-03-24T10:47:43.117005Z 9 Quit
1812021-03-24T10:47:52.529109Z 10 Connect root@localhost on using SSL/TLS
1822021-03-24T10:47:52.529195Z 10 Query select @@version_comment limit 1
1832021-03-24T10:47:52.529297Z 10 Query SET GLOBAL innodb_fast_shutdown = 0
1842021-03-24T10:47:52.529376Z 10 Quit
1852021-03-24T10:47:54.605239Z 11 Connect root@localhost on using SSL/TLS
1862021-03-24T10:47:54.605316Z 11 Query shutdown
1872021-03-24T10:47:54.605781Z 11 Query
188C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.23 (MySQL Community Server - GPL). started with:
189TCP Port: 3306, Named Pipe: MySQL
190Time Id Command Argument
1912021-03-24T10:47:57.210221Z 8 Connect root@localhost on using SSL/TLS
1922021-03-24T10:47:57.210387Z 8 Query SELECT @@max_allowed_packet, @@character_set_client,
193 @@character_set_connection, @@license, @@sql_mode, @@lower_case_table_names
1942021-03-24T10:47:57.210556Z 8 Query SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP())
1952021-03-24T10:47:57.210668Z 8 Query SHOW COLLATION
1962021-03-24T10:47:57.214681Z 8 Query SET NAMES utf8mb4
1972021-03-24T10:47:57.214774Z 8 Query SET character_set_results=NULL
1982021-03-24T10:47:57.214831Z 8 Quit
1992021-03-24T10:50:18.394815Z 9 Connect root@localhost on using SSL/TLS
2002021-03-24T10:50:18.395130Z 9 Query select @@version_comment limit 1
2012021-03-24T10:50:41.501143Z 9 Query show variables like '%log%'
2022021-03-24T10:51:04.889386Z 9 Query SET GLOBAL general_log = 'ON'
2032021-03-24T10:54:05.894361Z 10 Connect root@localhost on using SSL/TLS
2042021-03-24T10:54:05.894621Z 10 Query select @@version_comment limit 1
2052021-03-24T10:59:14.353397Z 11 Connect root@localhost on using SSL/TLS
2062021-03-24T10:59:14.365648Z 11 Query SELECT @@max_allowed_packet, @@character_set_client,
207 @@character_set_connection, @@license, @@sql_mode, @@lower_case_table_names
2082021-03-24T10:59:14.379127Z 11 Query SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP())
2092021-03-24T10:59:14.380897Z 11 Query SHOW COLLATION
2102021-03-24T10:59:14.384894Z 11 Query SET NAMES utf8mb4
2112021-03-24T10:59:14.385068Z 11 Query SET character_set_results=NULL
2122021-03-24T10:59:14.389613Z 11 Quit
2132021-03-24T10:59:52.402424Z 12 Connect root@localhost on using SSL/TLS
2142021-03-24T10:59:52.402540Z 12 Query select @@version_comment limit 1
2152021-03-24T10:59:52.402686Z 12 Query SET GLOBAL innodb_fast_shutdown = 0
2162021-03-24T10:59:52.402766Z 12 Quit
2172021-03-24T10:59:54.455486Z 13 Connect root@localhost on using SSL/TLS
2182021-03-24T10:59:54.455561Z 13 Query shutdown
2192021-03-24T10:59:54.456004Z 13 Query
220C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.23 (MySQL Community Server - GPL). started with:
221TCP Port: 3306, Named Pipe: MySQL
222Time Id Command Argument
2232021-03-24T10:59:57.903732Z 8 Connect root@localhost on using SSL/TLS
2242021-03-24T10:59:57.903907Z 8 Query SELECT @@max_allowed_packet, @@character_set_client,
225 @@character_set_connection, @@license, @@sql_mode, @@lower_case_table_names
2262021-03-24T10:59:57.904076Z 8 Query SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP())
2272021-03-24T10:59:57.904234Z 8 Query SHOW COLLATION
2282021-03-24T10:59:57.908072Z 8 Query SET NAMES utf8mb4
2292021-03-24T10:59:57.908190Z 8 Query SET character_set_results=NULL
2302021-03-24T10:59:57.908290Z 8 Quit
2312021-03-24T11:00:18.944077Z 9 Connect root@localhost on using SSL/TLS
2322021-03-24T11:00:18.944344Z 9 Query select @@version_comment limit 1
2332021-03-24T11:01:22.763529Z 10 Connect root@localhost on using SSL/TLS
2342021-03-24T11:01:22.776343Z 10 Query SELECT @@max_allowed_packet, @@character_set_client,
235 @@character_set_connection, @@license, @@sql_mode, @@lower_case_table_names
2362021-03-24T11:01:22.789516Z 10 Query SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP())
2372021-03-24T11:01:22.791271Z 10 Query SHOW COLLATION
2382021-03-24T11:01:22.794936Z 10 Query SET NAMES utf8mb4
2392021-03-24T11:01:22.795202Z 10 Query SET character_set_results=NULL
2402021-03-24T11:01:22.799614Z 10 Quit
2412021-03-24T11:02:29.550089Z 11 Connect root@localhost on using SSL/TLS
2422021-03-24T11:02:29.550179Z 11 Query select @@version_comment limit 1
2432021-03-24T11:02:29.550272Z 11 Query SET GLOBAL innodb_fast_shutdown = 0
2442021-03-24T11:02:29.550376Z 11 Quit
2452021-03-24T11:02:31.601097Z 12 Connect root@localhost on using SSL/TLS
2462021-03-24T11:02:31.601174Z 12 Query shutdown
2472021-03-24T11:02:31.601619Z 12 Query
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264my.cnf:
265
266# Other default tuning values
267# MySQL Server Instance Configuration File
268# ----------------------------------------------------------------------
269# Generated by the MySQL Server Instance Configuration Wizard
270#
271# Installation Instructions
272# ----------------------------------------------------------------------
273#
274# On Linux you can copy this file to /etc/my.cnf to set global options,
275# mysql-data-dir/my.cnf to set server-specific options
276# (@localstatedir@ for this installation) or to
277# ~/.my.cnf to set user-specific options.
278#
279# On Windows you should keep this file in the installation directory
280# of your server (e.g. C:\Program Files\MySQL\MySQL Server X.Y). To
281# make sure the server reads the config file use the startup option
282# "--defaults-file".
283#
284# To run the server from the command line, execute this in a
285# command line shell, e.g.
286# mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"
287#
288# To install the server as a Windows service manually, execute this in a
289# command line shell, e.g.
290# mysqld --install MySQLXY --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"
291#
292# And then execute this in a command line shell to start the server, e.g.
293# net start MySQLXY
294#
295# Guidelines for editing this file
296# ----------------------------------------------------------------------
297#
298# In this file, you can use all long options that the program supports.
299# If you want to know the options a program supports, start the program
300# with the "--help" option.
301#
302# More detailed information about the individual options can also be
303# found in the manual.
304#
305# For advice on how to change settings please see
306# https://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html
307#
308# CLIENT SECTION
309# ----------------------------------------------------------------------
310#
311# The following options will be read by MySQL client applications.
312# Note that only client applications shipped by MySQL are guaranteed
313# to read this section. If you want your own MySQL client program to
314# honor these values, you need to specify it as an option during the
315# MySQL client library initialization.
316#
317[client]
318
319# pipe=
320
321# socket=MYSQL
322
323port=3306
324
325[mysql]
326no-beep=
327
328# default-character-set=
329
330# SERVER SECTION
331# ----------------------------------------------------------------------
332#
333# The following options will be read by the MySQL Server. Make sure that
334# you have installed the server correctly (see above) so it reads this
335# file.=
336#
337# server_type=3
338
339[mysqld]
340
341bind-address = 0.0.0.0
342
343# skip-grant-tables=
344
345# The next three options are mutually exclusive to SERVER_PORT below.
346# skip-networking=
347# enable-named-pipe=
348# shared-memory=
349
350# shared-memory-base-name=MYSQL
351
352# The Pipe the MySQL Server will use
353# socket=MYSQL
354
355# The TCP/IP Port the MySQL Server will listen on
356port=3306
357
358# Path to installation directory. All paths are usually resolved relative to this.
359# basedir="C:/Program Files/MySQL/MySQL Server 8.0/"
360
361# Path to the database root
362datadir=C:/ProgramData/MySQL/MySQL Server 8.0\Data
363
364# The default character set that will be used when a new schema or table is
365# created and no character set is defined
366# character-set-server=
367
368# The default authentication plugin to be used when connecting to the server
369default_authentication_plugin=caching_sha2_password
370
371# The default storage engine that will be used when create new tables when
372default-storage-engine=INNODB
373
374# Set the SQL mode to strict
375sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
376
377# General and Slow logging.
378log-output=FILE
379
380general-log=1
381
382general_log_file="I:\cedie LOGS\mysql\mysql.log"
383
384slow-query-log=1
385
386slow_query_log_file="I:\cedie LOGS\mysql\mysql.log"
387
388long_query_time=10
389
390# Error Logging.
391log-error="I:\cedie LOGS\mysql\mysql.err"
392
393# ***** Group Replication Related *****
394# Specifies the base name to use for binary log files. With binary logging
395# enabled, the server logs all statements that change data to the binary
396# log, which is used for backup and replication.
397log-bin="CEDIEASD-bin"
398
399# ***** Group Replication Related *****
400# Specifies the server ID. For servers that are used in a replication topology,
401# you must specify a unique server ID for each replication server, in the
402# range from 1 to 2^32 − 1. “Unique” means that each ID must be different
403# from every other ID in use by any other source or replica.
404server-id=1
405
406# ***** Group Replication Related *****
407# The host name or IP address of the replica to be reported to the source
408# during replica registration. This value appears in the output of SHOW REPLICAS
409# on the source server. Leave the value unset if you do not want the replica to
410# register itself with the source.
411# report_host=0.0
412
413# NOTE: Modify this value after Server initialization won't take effect.
414lower_case_table_names=1
415
416# Secure File Priv.
417secure-file-priv="C:/ProgramData/MySQL/MySQL Server 8.0/Uploads"
418
419# The maximum amount of concurrent sessions the MySQL server will
420# allow. One of these connections will be reserved for a user with
421# SUPER privileges to allow the administrator to login even if the
422# connection limit has been reached.
423max_connections=151
424
425# The number of open tables for all threads. Increasing this value
426# increases the number of file descriptors that mysqld requires.
427# Therefore you have to make sure to set the amount of open files
428# allowed to at least 4096 in the variable "open-files-limit" in
429# section [mysqld_safe]
430table_open_cache=2000
431
432# Maximum size for internal (in-memory) temporary tables. If a table
433# grows larger than this value, it is automatically converted to disk
434# based table This limitation is for a single table. There can be many
435# of them.
436tmp_table_size=101M
437
438# How many threads we should keep in a cache for reuse. When a client
439# disconnects, the client's threads are put in the cache if there aren't
440# more than thread_cache_size threads from before. This greatly reduces
441# the amount of thread creations needed if you have a lot of new
442# connections. (Normally this doesn't give a notable performance
443# improvement if you have a good thread implementation.)
444thread_cache_size=10
445
446# *** MyISAM Specific options
447# The maximum size of the temporary file MySQL is allowed to use while
448# recreating the index (during REPAIR, ALTER TABLE or LOAD DATA INFILE.
449# If the file-size would be bigger than this, the index will be created
450# through the key cache (which is slower).
451myisam_max_sort_file_size=100G
452
453# The size of the buffer that is allocated when sorting MyISAM indexes
454# during a REPAIR TABLE or when creating indexes with CREATE INDEX
455# or ALTER TABLE.
456myisam_sort_buffer_size=192M
457
458# Size of the Key Buffer, used to cache index blocks for MyISAM tables.
459# Do not set it larger than 30% of your available memory, as some memory
460# is also required by the OS to cache rows. Even if you're not using
461# MyISAM tables, you should still set it to 8-64M as it will also be
462# used for internal temporary disk tables.
463key_buffer_size=8M
464
465# Size of the buffer used for doing full table scans of MyISAM tables.
466# Allocated per thread, if a full scan is needed.
467read_buffer_size=64K
468
469read_rnd_buffer_size=256K
470
471# *** INNODB Specific options ***
472# innodb_data_home_dir=
473
474# Use this option if you have a MySQL server with InnoDB support enabled
475# but you do not plan to use it. This will save memory and disk space
476# and speed up some things.
477# skip-innodb=
478
479# If set to 1, InnoDB will flush (fsync) the transaction logs to the
480# disk at each commit, which offers full ACID behavior. If you are
481# willing to compromise this safety, and you are running small
482# transactions, you may set this to 0 or 2 to reduce disk I/O to the
483# logs. Value 0 means that the log is only written to the log file and
484# the log file flushed to disk approximately once per second. Value 2
485# means the log is written to the log file at each commit, but the log
486# file is only flushed to disk approximately once per second.
487innodb_flush_log_at_trx_commit=1
488
489# The size of the buffer InnoDB uses for buffering log data. As soon as
490# it is full, InnoDB will have to flush it to disk. As it is flushed
491# once per second anyway, it does not make sense to have it very large
492# (even with long transactions).
493innodb_log_buffer_size=1M
494
495# InnoDB, unlike MyISAM, uses a buffer pool to cache both indexes and
496# row data. The bigger you set this the less disk I/O is needed to
497# access data in tables. On a dedicated database server you may set this
498# parameter up to 80% of the machine physical memory size. Do not set it
499# too large, though, because competition of the physical memory may
500# cause paging in the operating system. Note that on 32bit systems you
501# might be limited to 2-3.5G of user level memory per process, so do not
502# set it too high.
503innodb_buffer_pool_size=8M
504
505# Size of each log file in a log group. You should set the combined size
506# of log files to about 25%-100% of your buffer pool size to avoid
507# unneeded buffer pool flush activity on log file overwrite. However,
508# note that a larger logfile size will increase the time needed for the
509# recovery process.
510innodb_log_file_size=48M
511
512# Number of threads allowed inside the InnoDB kernel. The optimal value
513# depends highly on the application, hardware as well as the OS
514# scheduler properties. A too high value may lead to thread thrashing.
515innodb_thread_concurrency=25
516
517# The increment size (in MB) for extending the size of an auto-extend InnoDB system tablespace file when it becomes full.
518innodb_autoextend_increment=64
519
520# The number of regions that the InnoDB buffer pool is divided into.
521# For systems with buffer pools in the multi-gigabyte range, dividing the buffer pool into separate instances can improve concurrency,
522# by reducing contention as different threads read and write to cached pages.
523innodb_buffer_pool_instances=8
524
525# Determines the number of threads that can enter InnoDB concurrently.
526innodb_concurrency_tickets=5000
527
528# Specifies how long in milliseconds (ms) a block inserted into the old sublist must stay there after its first access before
529# it can be moved to the new sublist.
530innodb_old_blocks_time=1000
531
532# It specifies the maximum number of .ibd files that MySQL can keep open at one time. The minimum value is 10.
533innodb_open_files=300
534
535# When this variable is enabled, InnoDB updates statistics during metadata statements.
536innodb_stats_on_metadata=0
537
538# When innodb_file_per_table is enabled (the default in 5.6.6 and higher), InnoDB stores the data and indexes for each newly created table
539# in a separate .ibd file, rather than in the system tablespace.
540innodb_file_per_table=1
541
542# Use the following list of values: 0 for crc32, 1 for strict_crc32, 2 for innodb, 3 for strict_innodb, 4 for none, 5 for strict_none.
543innodb_checksum_algorithm=0
544
545# The number of outstanding connection requests MySQL can have.
546# This option is useful when the main MySQL thread gets many connection requests in a very short time.
547# It then takes some time (although very little) for the main thread to check the connection and start a new thread.
548# The back_log value indicates how many requests can be stacked during this short time before MySQL momentarily
549# stops answering new requests.
550# You need to increase this only if you expect a large number of connections in a short period of time.
551back_log=80
552
553# If this is set to a nonzero value, all tables are closed every flush_time seconds to free up resources and
554# synchronize unflushed data to disk.
555# This option is best used only on systems with minimal resources.
556flush_time=0
557
558# The minimum size of the buffer that is used for plain index scans, range index scans, and joins that do not use
559# indexes and thus perform full table scans.
560join_buffer_size=256K
561
562# The maximum size of one packet or any generated or intermediate string, or any parameter sent by the
563# mysql_stmt_send_long_data() C API function.
564max_allowed_packet=4M
565
566# If more than this many successive connection requests from a host are interrupted without a successful connection,
567# the server blocks that host from performing further connections.
568max_connect_errors=100
569
570# Changes the number of file descriptors available to mysqld.
571# You should try increasing the value of this option if mysqld gives you the error "Too many open files".
572open_files_limit=4161
573
574# If you see many sort_merge_passes per second in SHOW GLOBAL STATUS output, you can consider increasing the
575# sort_buffer_size value to speed up ORDER BY or GROUP BY operations that cannot be improved with query optimization
576# or improved indexing.
577sort_buffer_size=256K
578
579# The number of table definitions (from .frm files) that can be stored in the definition cache.
580# If you use a large number of tables, you can create a large table definition cache to speed up opening of tables.
581# The table definition cache takes less space and does not use file descriptors, unlike the normal table cache.
582# The minimum and default values are both 400.
583table_definition_cache=1400
584
585# Specify the maximum size of a row-based binary log event, in bytes.
586# Rows are grouped into events smaller than this size if possible. The value should be a multiple of 256.
587binlog_row_event_max_size=8K
588
589# If the value of this variable is greater than 0, a replica synchronizes its master.info file to disk.
590# (using fdatasync()) after every sync_master_info events.
591sync_master_info=10000
592
593# If the value of this variable is greater than 0, the MySQL server synchronizes its relay log to disk.
594# (using fdatasync()) after every sync_relay_log writes to the relay log.
595sync_relay_log=10000
596
597# If the value of this variable is greater than 0, a replica synchronizes its relay-log.info file to disk.
598# (using fdatasync()) after every sync_relay_log_info transactions.
599sync_relay_log_info=10000
600
601# Load mysql plugins at start."plugin_x ; plugin_y".
602# plugin_load=
603
604# The TCP/IP Port the MySQL Server X Protocol will listen on.
605loose_mysqlx_port=33060
606