####################################### 5.7 #######################################

rm -rf 104984/
bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/104984 --log-error-verbosity=3
bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/104984 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=$PWD/104984/log.err --log-error-verbosity=3 --secure-file-priv=""  --performance-schema=ON 2>&1 &


create database if not exists test;
use test;
set names gbk;
create table sakila_for_gbk(id int, name varchar(45) comment '中文');
set names utf8;
create table sakila_for_utf8(id int, name varchar(45) comment '中文');

[umshastr@support-cluster03:/export/home/tmp/ushastry/mysql-5.7.35]$ bin/mysql -uroot -S /tmp/mysql_ushastry.sock                                         Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.35 MySQL Community Server (GPL)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database if not exists test;
Query OK, 1 row affected (0.00 sec)

mysql> use test;
Database changed
mysql> set names gbk;
Query OK, 0 rows affected (0.00 sec)

mysql> create table sakila_for_gbk(id int, name varchar(45) comment '中文');
Query OK, 0 rows affected, 1 warning (0.01 sec)

mysql> set names utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> create table sakila_for_utf8(id int, name varchar(45) comment '中文');
Query OK, 0 rows affected (0.01 sec)

mysql> shutdown;
Query OK, 0 rows affected (0.00 sec)

mysql> \q
Bye


# Try for in-place upgrade to 8.0.26 / 8.0.23
####################################### 8.0 #######################################
bin/mysqld --no-defaults --upgrade=FORCE --basedir=$PWD --datadir=/export/home/tmp/ushastry/mysql-5.7.35/104984 --core-file --socket=/tmp/mysql_ushastry.sock  --port=3306 --log-error=/export/home/tmp/ushastry/mysql-5.7.35/104984/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3  --secure-file-priv=/tmp/ 2>&1 &

 bin/mysql -uroot -S /tmp/mysql_ushastry.sock                                         
 Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.26 MySQL Community Server - GPL

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show create table sakila_for_gbk\G
*************************** 1. row ***************************
       Table: sakila_for_gbk
Create Table: CREATE TABLE `sakila_for_gbk` (
  `id` int DEFAULT NULL,
  `name` varchar(45) DEFAULT NULL COMMENT '涓?枃'
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

mysql> show create table sakila_for_utf8\G
*************************** 1. row ***************************
       Table: sakila_for_utf8
Create Table: CREATE TABLE `sakila_for_utf8` (
  `id` int DEFAULT NULL,
  `name` varchar(45) DEFAULT NULL COMMENT '中文'
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

mysql> shutdown;
Query OK, 0 rows affected (0.00 sec)

mysql> \q
Bye
[1]+  Done                    bin/mysqld --no-defaults --upgrade=FORCE --basedir=$PWD --datadir=/export/home/tmp/ushastry/mysql-5.7.35/104984 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=/export/home/tmp/ushastry/mysql-5.7.35/104984/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv=/tmp/ 2>&1

- extract from error log


 cat /export/home/tmp/ushastry/mysql-5.7.35/104984/log.err
2021-09-20T06:06:22.594481Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-09-20T06:06:22.594564Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2021-09-20T06:06:22.594583Z 0 [Note] bin/mysqld (mysqld 5.7.35) starting as process 5739 ...
2021-09-20T06:06:22.597537Z 0 [Note] InnoDB: PUNCH HOLE support available
2021-09-20T06:06:22.597552Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-09-20T06:06:22.597555Z 0 [Note] InnoDB: Uses event mutexes
2021-09-20T06:06:22.597557Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2021-09-20T06:06:22.597560Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-09-20T06:06:22.597562Z 0 [Note] InnoDB: Using Linux native AIO
2021-09-20T06:06:22.597701Z 0 [Note] InnoDB: Number of pools: 1
2021-09-20T06:06:22.597767Z 0 [Note] InnoDB: Using CPU crc32 instructions
2021-09-20T06:06:22.598905Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-09-20T06:06:22.604228Z 0 [Note] InnoDB: Completed initialization of buffer pool
2021-09-20T06:06:22.605646Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-09-20T06:06:22.616845Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2021-09-20T06:06:22.622459Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-09-20T06:06:22.622593Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-09-20T06:06:22.655707Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-09-20T06:06:22.656240Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2021-09-20T06:06:22.656245Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2021-09-20T06:06:22.656670Z 0 [Note] InnoDB: Waiting for purge to start
2021-09-20T06:06:22.706805Z 0 [Note] InnoDB: 5.7.35 started; log sequence number 2748441
2021-09-20T06:06:22.707247Z 0 [Note] InnoDB: Loading buffer pool(s) from /export/home/tmp/ushastry/mysql-5.7.35/104984/ib_buffer_pool
2021-09-20T06:06:22.707424Z 0 [Note] Plugin 'FEDERATED' is disabled.
2021-09-20T06:06:22.708300Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210920  8:06:22
2021-09-20T06:06:22.710772Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2021-09-20T06:06:22.710784Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2021-09-20T06:06:22.710787Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2021-09-20T06:06:22.710788Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2021-09-20T06:06:22.711307Z 0 [Warning] CA certificate ca.pem is self signed.
2021-09-20T06:06:22.711334Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2021-09-20T06:06:22.711428Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2021-09-20T06:06:22.711467Z 0 [Note] IPv6 is available.
2021-09-20T06:06:22.711472Z 0 [Note]   - '::' resolves to '::';
2021-09-20T06:06:22.711482Z 0 [Note] Server socket created on IP: '::'.
2021-09-20T06:06:22.713754Z 0 [Warning] Insecure configuration for --pid-file: Location '/export/home/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2021-09-20T06:06:22.718477Z 0 [Note] Event Scheduler: Loaded 0 events
2021-09-20T06:06:22.718617Z 0 [Note] bin/mysqld: ready for connections.
Version: '5.7.35'  socket: '/tmp/mysql_ushastry.sock'  port: 3306  MySQL Community Server (GPL)
2021-09-20T06:08:00.269652Z 0 [Note] Giving 0 client threads a chance to die gracefully
2021-09-20T06:08:00.269681Z 0 [Note] Shutting down slave threads
2021-09-20T06:08:00.269685Z 0 [Note] Forcefully disconnecting 0 remaining clients
2021-09-20T06:08:00.269698Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2021-09-20T06:08:00.269775Z 0 [Note] Binlog end
2021-09-20T06:08:00.270153Z 0 [Note] Shutting down plugin 'ngram'
2021-09-20T06:08:00.270157Z 0 [Note] Shutting down plugin 'ARCHIVE'
2021-09-20T06:08:00.270159Z 0 [Note] Shutting down plugin 'partition'
2021-09-20T06:08:00.270160Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2021-09-20T06:08:00.270163Z 0 [Note] Shutting down plugin 'MEMORY'
2021-09-20T06:08:00.270165Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2021-09-20T06:08:00.270184Z 0 [Note] Shutting down plugin 'MyISAM'
2021-09-20T06:08:00.270190Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2021-09-20T06:08:00.270192Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-09-20T06:08:00.270194Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-09-20T06:08:00.270195Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-09-20T06:08:00.270197Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-09-20T06:08:00.270198Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-09-20T06:08:00.270200Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2021-09-20T06:08:00.270201Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2021-09-20T06:08:00.270202Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2021-09-20T06:08:00.270204Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2021-09-20T06:08:00.270205Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2021-09-20T06:08:00.270207Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2021-09-20T06:08:00.270208Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2021-09-20T06:08:00.270210Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2021-09-20T06:08:00.270211Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2021-09-20T06:08:00.270212Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2021-09-20T06:08:00.270214Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2021-09-20T06:08:00.270215Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2021-09-20T06:08:00.270217Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2021-09-20T06:08:00.270218Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2021-09-20T06:08:00.270220Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2021-09-20T06:08:00.270221Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2021-09-20T06:08:00.270223Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2021-09-20T06:08:00.270224Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2021-09-20T06:08:00.270226Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2021-09-20T06:08:00.270227Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2021-09-20T06:08:00.270228Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2021-09-20T06:08:00.270230Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2021-09-20T06:08:00.270231Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2021-09-20T06:08:00.270233Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2021-09-20T06:08:00.270234Z 0 [Note] Shutting down plugin 'InnoDB'
2021-09-20T06:08:00.270279Z 0 [Note] InnoDB: FTS optimize thread exiting.
2021-09-20T06:08:00.270413Z 0 [Note] InnoDB: Starting shutdown...
2021-09-20T06:08:00.370571Z 0 [Note] InnoDB: Dumping buffer pool(s) to /export/home/tmp/ushastry/mysql-5.7.35/104984/ib_buffer_pool
2021-09-20T06:08:00.371359Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210920  8:08:00
2021-09-20T06:08:01.578704Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2757077
2021-09-20T06:08:01.579593Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-09-20T06:08:01.579604Z 0 [Note] Shutting down plugin 'CSV'
2021-09-20T06:08:01.579608Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2021-09-20T06:08:01.579611Z 0 [Note] Shutting down plugin 'sha256_password'
2021-09-20T06:08:01.579613Z 0 [Note] Shutting down plugin 'mysql_native_password'
2021-09-20T06:08:01.579740Z 0 [Note] Shutting down plugin 'binlog'
2021-09-20T06:08:01.580110Z 0 [Note] bin/mysqld: Shutdown complete

2021-09-20T06:12:57.436997Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2021-09-20T06:12:57.437060Z 0 [Note] [MY-010949] [Server] Basedir set to /export/home/tmp/ushastry/mysql-8.0.26/.
2021-09-20T06:12:57.437074Z 0 [System] [MY-010116] [Server] /export/home/tmp/ushastry/mysql-8.0.26/bin/mysqld (mysqld 8.0.26) starting as process 6125
2021-09-20T06:12:57.443324Z 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO
2021-09-20T06:12:57.443575Z 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
2021-09-20T06:12:57.445470Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2021-09-20T06:12:57.445572Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-09-20T06:12:57.445623Z 1 [Note] [MY-013546] [InnoDB] Atomic write enabled
2021-09-20T06:12:57.445685Z 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2021-09-20T06:12:57.445756Z 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
2021-09-20T06:12:57.445813Z 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2021-09-20T06:12:57.445876Z 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.11
2021-09-20T06:12:57.447250Z 1 [Note] [MY-013251] [InnoDB] Number of pools: 1
2021-09-20T06:12:57.447412Z 1 [Note] [MY-012951] [InnoDB] Using CPU crc32 instructions
2021-09-20T06:12:57.447825Z 1 [Note] [MY-012203] [InnoDB] Directories to scan './'
2021-09-20T06:12:57.447952Z 1 [Note] [MY-012204] [InnoDB] Scanning './'
2021-09-20T06:12:57.449572Z 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 22 files.
2021-09-20T06:12:57.450185Z 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M
2021-09-20T06:12:57.455530Z 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2021-09-20T06:12:57.458185Z 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-09-20T06:12:57.549542Z 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 2
2021-09-20T06:12:57.549689Z 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 4
2021-09-20T06:12:57.549877Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
2021-09-20T06:12:57.550125Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
2021-09-20T06:12:57.552628Z 1 [Note] [MY-012529] [InnoDB] Redo log format is v1. The redo log was created before MySQL 8.0.3.
2021-09-20T06:12:57.552773Z 1 [Note] [MY-012557] [InnoDB] Redo log is from an earlier version, v1.
2021-09-20T06:12:57.553254Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2021-09-20T06:12:57.563584Z 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ...
2021-09-20T06:12:57.563785Z 1 [Note] [MY-012535] [InnoDB] Apply batch completed!
2021-09-20T06:12:57.564000Z 1 [Note] [MY-013041] [InnoDB] Upgrading redo log: 2*50331648 bytes, LSN=2757077
2021-09-20T06:12:57.564341Z 1 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2021-09-20T06:12:57.570329Z 1 [Note] [MY-012968] [InnoDB] Starting to delete and rewrite log files.
2021-09-20T06:12:57.576104Z 1 [Note] [MY-013575] [InnoDB] Creating log file ./ib_logfile101
2021-09-20T06:12:57.684739Z 1 [Note] [MY-013575] [InnoDB] Creating log file ./ib_logfile1
2021-09-20T06:12:57.886123Z 1 [Note] [MY-012892] [InnoDB] Renaming log file ./ib_logfile101 to ./ib_logfile0
2021-09-20T06:12:57.886338Z 1 [Note] [MY-012893] [InnoDB] New log files created, LSN=2757132
2021-09-20T06:12:57.886480Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2021-09-20T06:12:57.887173Z 1 [Note] [MY-013040] [InnoDB] Will create 2 new undo tablespaces.
2021-09-20T06:12:57.889508Z 1 [Note] [MY-012896] [InnoDB] Creating UNDO Tablespace ./undo_001
2021-09-20T06:12:57.889706Z 1 [Note] [MY-012897] [InnoDB] Setting file ./undo_001 size to 16 MB
2021-09-20T06:12:57.889902Z 1 [Note] [MY-012898] [InnoDB] Physically writing the file full
2021-09-20T06:12:57.936229Z 1 [Note] [MY-012896] [InnoDB] Creating UNDO Tablespace ./undo_002
2021-09-20T06:12:57.936409Z 1 [Note] [MY-012897] [InnoDB] Setting file ./undo_002 size to 16 MB
2021-09-20T06:12:57.936545Z 1 [Note] [MY-012898] [InnoDB] Physically writing the file full
2021-09-20T06:12:57.974951Z 1 [Note] [MY-012915] [InnoDB] Created 2 undo tablespaces.
2021-09-20T06:12:57.975229Z 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 0
2021-09-20T06:12:57.976587Z 1 [Note] [MY-011825] [InnoDB] Parallel initialization of rseg complete
2021-09-20T06:12:57.976834Z 1 [Note] [MY-011825] [InnoDB] Time taken to initialize rseg using 4 thread: 1597 ms.
2021-09-20T06:12:57.977030Z 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2021-09-20T06:12:57.977243Z 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-09-20T06:12:58.009553Z 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
2021-09-20T06:12:58.009993Z 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/'
2021-09-20T06:12:58.026270Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2021-09-20T06:12:58.029121Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in undo tablespace number 1. 128 are now active.
2021-09-20T06:12:58.031948Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in undo tablespace number 2. 128 are now active.
2021-09-20T06:12:58.191949Z 1 [Note] [MY-012976] [InnoDB] 8.0.26 started; log sequence number 5115862
2021-09-20T06:12:58.193049Z 1 [Note] [MY-012922] [InnoDB] Waiting for purge to start
2021-09-20T06:12:58.248504Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-09-20T06:12:58.251454Z 1 [Note] [MY-011088] [Server] Data dictionary initializing version '80023'.
2021-09-20T06:12:58.655175Z 1 [Note] [MY-010337] [Server] Created Data Dictionary for upgrade
2021-09-20T06:12:58.671230Z 0 [Note] [MY-011332] [Server] Plugin mysqlx reported: 'IPv6 is available'
2021-09-20T06:12:58.673333Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. bind-address: '::' port: 33330'
2021-09-20T06:12:58.673554Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. socket: '/tmp/mysql_x_ushastry.sock''
2021-09-20T06:12:59.592892Z 2 [System] [MY-011003] [Server] Finished populating Data Dictionary tables with data.
2021-09-20T06:12:59.595519Z 2 [Note] [MY-011008] [Server] Finished migrating TABLE statistics data.
2021-09-20T06:12:59.598345Z 2 [Note] [MY-011008] [Server] Finished migrating TABLE statistics data.
2021-09-20T06:13:00.338998Z 2 [Note] [MY-010006] [Server] Using data dictionary with version '80023'.
2021-09-20T06:13:00.734590Z 5 [System] [MY-013381] [Server] Server upgrade from '50700' to '80026' started.
2021-09-20T06:13:00.735853Z 5 [Note] [MY-013386] [Server] Running queries to upgrade MySQL server.
2021-09-20T06:13:04.176477Z 5 [Note] [MY-013387] [Server] Upgrading system table data.
2021-09-20T06:13:04.513007Z 5 [Note] [MY-013385] [Server] Upgrading the sys schema.
2021-09-20T06:13:05.045880Z 5 [Note] [MY-013400] [Server] Upgrade of help tables started.
2021-09-20T06:13:05.176105Z 5 [Note] [MY-013400] [Server] Upgrade of help tables completed.
2021-09-20T06:13:05.176543Z 5 [Note] [MY-013394] [Server] Checking 'mysql' schema.
2021-09-20T06:13:05.297192Z 5 [Note] [MY-013394] [Server] Checking 'sys' schema.
2021-09-20T06:13:05.313732Z 5 [Note] [MY-013394] [Server] Checking 'test' schema.
2021-09-20T06:13:05.325787Z 5 [System] [MY-013381] [Server] Server upgrade from '50700' to '80026' completed.
2021-09-20T06:13:05.361805Z 0 [Note] [MY-010902] [Server] Thread priority attribute setting in Resource Group SQL shall be ignored due to unsupported platform or insufficient privilege.
2021-09-20T06:13:05.372926Z 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin
2021-09-20T06:13:05.373343Z 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end
2021-09-20T06:13:05.373905Z 0 [Note] [MY-011946] [InnoDB] Loading buffer pool(s) from /export/home/tmp/ushastry/mysql-5.7.35/104984/ib_buffer_pool
2021-09-20T06:13:05.374297Z 0 [Note] [MY-011946] [InnoDB] Buffer pool(s) load completed at 210920  8:13:05
2021-09-20T06:13:05.383122Z 0 [Note] [MY-010913] [Server] You have not provided a mandatory server-id. Servers in a replication topology must have unique server-ids. Please refer to the proper server start-up parameters documentation.
2021-09-20T06:13:05.384578Z 0 [Note] [MY-010182] [Server] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2021-09-20T06:13:05.384862Z 0 [Note] [MY-010304] [Server] Skipping generation of SSL certificates as certificate files are present in data directory.
2021-09-20T06:13:05.385126Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-09-20T06:13:05.385387Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-09-20T06:13:05.386532Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-09-20T06:13:05.386842Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-09-20T06:13:05.387130Z 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --sha256_password_auto_generate_rsa_keys as key files are present in data directory.
2021-09-20T06:13:05.387427Z 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --caching_sha2_password_auto_generate_rsa_keys as key files are present in data directory.
2021-09-20T06:13:05.387867Z 0 [Note] [MY-010252] [Server] Server hostname (bind-address): '*'; port: 3306
2021-09-20T06:13:05.388181Z 0 [Note] [MY-010253] [Server] IPv6 is available.
2021-09-20T06:13:05.388503Z 0 [Note] [MY-010264] [Server]   - '::' resolves to '::';
2021-09-20T06:13:05.388808Z 0 [Note] [MY-010251] [Server] Server socket created on IP: '::'.
2021-09-20T06:13:05.390734Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/export/home/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2021-09-20T06:13:05.402020Z 0 [Note] [MY-011025] [Repl] Failed to start slave threads for channel ''.
2021-09-20T06:13:05.403830Z 8 [Note] [MY-010051] [Server] Event Scheduler: scheduler thread started with id 8
2021-09-20T06:13:05.403971Z 0 [Note] [MY-011240] [Server] Plugin mysqlx reported: 'Using SSL configuration from MySQL Server'
2021-09-20T06:13:05.404454Z 0 [Note] [MY-011243] [Server] Plugin mysqlx reported: 'Using OpenSSL for TLS connections'
2021-09-20T06:13:05.404564Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33330, socket: /tmp/mysql_x_ushastry.sock
2021-09-20T06:13:05.404610Z 0 [System] [MY-010931] [Server] /export/home/tmp/ushastry/mysql-8.0.26/bin/mysqld: ready for connections. Version: '8.0.26'  socket: '/tmp/mysql_ushastry.sock'  port: 3306  MySQL Community Server - GPL.
2021-09-20T06:13:47.242150Z 10 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.26).
2021-09-20T06:13:47.242995Z 0 [Note] [MY-010067] [Server] Giving 1 client threads a chance to die gracefully
2021-09-20T06:13:47.243035Z 0 [Note] [MY-010117] [Server] Shutting down slave threads
2021-09-20T06:13:47.243044Z 0 [Note] [MY-010054] [Server] Event Scheduler: Killing the scheduler thread, thread id 8
2021-09-20T06:13:47.243052Z 0 [Note] [MY-010050] [Server] Event Scheduler: Waiting for the scheduler thread to reply
2021-09-20T06:13:47.243118Z 0 [Note] [MY-010048] [Server] Event Scheduler: Stopped
2021-09-20T06:13:47.243128Z 0 [Note] [MY-010118] [Server] Forcefully disconnecting 0 remaining clients
2021-09-20T06:13:47.243135Z 0 [Note] [MY-010043] [Server] Event Scheduler: Purging the queue. 0 events
2021-09-20T06:13:47.244343Z 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting.
2021-09-20T06:13:47.478022Z 0 [Note] [MY-010120] [Server] Binlog end
2021-09-20T06:13:47.480471Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx'
2021-09-20T06:13:47.480947Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx_cache_cleaner'
2021-09-20T06:13:47.480962Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'ngram'
2021-09-20T06:13:47.480967Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'BLACKHOLE'
2021-09-20T06:13:47.480973Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'ARCHIVE'
2021-09-20T06:13:47.480977Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'TempTable'
2021-09-20T06:13:47.480981Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'PERFORMANCE_SCHEMA'
2021-09-20T06:13:47.481018Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MRG_MYISAM'
2021-09-20T06:13:47.481022Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MyISAM'
2021-09-20T06:13:47.481030Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_SESSION_TEMP_TABLESPACES'
2021-09-20T06:13:47.481035Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CACHED_INDEXES'
2021-09-20T06:13:47.481039Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_VIRTUAL'
2021-09-20T06:13:47.481043Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_COLUMNS'
2021-09-20T06:13:47.481047Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESPACES'
2021-09-20T06:13:47.481063Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_INDEXES'
2021-09-20T06:13:47.481067Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESTATS'
2021-09-20T06:13:47.481071Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLES'
2021-09-20T06:13:47.481075Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2021-09-20T06:13:47.481079Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2021-09-20T06:13:47.481083Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_CONFIG'
2021-09-20T06:13:47.481087Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2021-09-20T06:13:47.481091Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DELETED'
2021-09-20T06:13:47.481095Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2021-09-20T06:13:47.481098Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_METRICS'
2021-09-20T06:13:47.481102Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2021-09-20T06:13:47.481106Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2021-09-20T06:13:47.481110Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2021-09-20T06:13:47.481114Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE'
2021-09-20T06:13:47.481118Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2021-09-20T06:13:47.481122Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2021-09-20T06:13:47.481126Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM_RESET'
2021-09-20T06:13:47.481129Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM'
2021-09-20T06:13:47.481133Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_RESET'
2021-09-20T06:13:47.481137Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP'
2021-09-20T06:13:47.481141Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TRX'
2021-09-20T06:13:47.481145Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'InnoDB'
2021-09-20T06:13:47.481174Z 0 [Note] [MY-013072] [InnoDB] Starting shutdown...
2021-09-20T06:13:47.481535Z 0 [Note] [MY-011944] [InnoDB] Dumping buffer pool(s) to /export/home/tmp/ushastry/mysql-5.7.35/104984/ib_buffer_pool
2021-09-20T06:13:47.482006Z 0 [Note] [MY-011944] [InnoDB] Buffer pool(s) dump completed at 210920  8:13:47
2021-09-20T06:13:47.738532Z 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2021-09-20T06:13:48.247476Z 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 30108449
2021-09-20T06:13:48.248323Z 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1"
2021-09-20T06:13:48.248346Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MEMORY'
2021-09-20T06:13:48.248354Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'CSV'
2021-09-20T06:13:48.248361Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'daemon_keyring_proxy_plugin'
2021-09-20T06:13:48.248375Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha2_cache_cleaner'
2021-09-20T06:13:48.248381Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'caching_sha2_password'
2021-09-20T06:13:48.248388Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha256_password'
2021-09-20T06:13:48.248392Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysql_native_password'
2021-09-20T06:13:48.248566Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'binlog'
2021-09-20T06:13:48.249787Z 0 [System] [MY-010910] [Server] /export/home/tmp/ushastry/mysql-8.0.26/bin/mysqld: Shutdown complete (mysqld 8.0.26)  MySQL Community Server - GPL.


-- restart

.35/104984 --core-file --socket=/tmp/mysql_ushastry.sock  --port=3306 --log-error=/export/home/tmp/ushastry/mysql-5.7.35/104984/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3  --secure-file-priv=/tmp/ 2>&1 &
[1] 6347
[umshastr@support-cluster03:/export/home/tmp/ushastry/mysql-8.0.26]$
[umshastr@support-cluster03:/export/home/tmp/ushastry/mysql-8.0.26]$ bin/mysql -uroot -S /tmp/mysql_ushastry.sock                                         Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 8.0.26 MySQL Community Server - GPL

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>



--- 5.7.35 to 8.0.23

[umshastr@support-cluster03:/export/home/tmp/ushastry/mysql-8.0.23]$ cat /export/home/tmp/ushastry/mysql-5.7.35/104984/log.err                            2021-09-20T06:28:09.984032Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-09-20T06:28:09.984113Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2021-09-20T06:28:09.984132Z 0 [Note] bin/mysqld (mysqld 5.7.35) starting as process 7090 ...
2021-09-20T06:28:09.986878Z 0 [Note] InnoDB: PUNCH HOLE support available
2021-09-20T06:28:09.986897Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-09-20T06:28:09.986900Z 0 [Note] InnoDB: Uses event mutexes
2021-09-20T06:28:09.986902Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2021-09-20T06:28:09.986905Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-09-20T06:28:09.986907Z 0 [Note] InnoDB: Using Linux native AIO
2021-09-20T06:28:09.987048Z 0 [Note] InnoDB: Number of pools: 1
2021-09-20T06:28:09.987104Z 0 [Note] InnoDB: Using CPU crc32 instructions
2021-09-20T06:28:09.988039Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-09-20T06:28:09.993064Z 0 [Note] InnoDB: Completed initialization of buffer pool
2021-09-20T06:28:09.994428Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-09-20T06:28:10.005657Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2021-09-20T06:28:10.011676Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-09-20T06:28:10.011717Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-09-20T06:28:10.044854Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-09-20T06:28:10.045434Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2021-09-20T06:28:10.045444Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2021-09-20T06:28:10.045953Z 0 [Note] InnoDB: 5.7.35 started; log sequence number 2748441
2021-09-20T06:28:10.046156Z 0 [Note] InnoDB: Loading buffer pool(s) from /export/home/tmp/ushastry/mysql-5.7.35/104984/ib_buffer_pool
2021-09-20T06:28:10.046349Z 0 [Note] Plugin 'FEDERATED' is disabled.
2021-09-20T06:28:10.046989Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210920  8:28:10
2021-09-20T06:28:10.049695Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2021-09-20T06:28:10.049708Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2021-09-20T06:28:10.049712Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2021-09-20T06:28:10.049715Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2021-09-20T06:28:10.050232Z 0 [Warning] CA certificate ca.pem is self signed.
2021-09-20T06:28:10.050259Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2021-09-20T06:28:10.050336Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2021-09-20T06:28:10.050369Z 0 [Note] IPv6 is available.
2021-09-20T06:28:10.050374Z 0 [Note]   - '::' resolves to '::';
2021-09-20T06:28:10.050385Z 0 [Note] Server socket created on IP: '::'.
2021-09-20T06:28:10.052501Z 0 [Warning] Insecure configuration for --pid-file: Location '/export/home/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2021-09-20T06:28:10.056937Z 0 [Note] Event Scheduler: Loaded 0 events
2021-09-20T06:28:10.057135Z 0 [Note] bin/mysqld: ready for connections.
Version: '5.7.35'  socket: '/tmp/mysql_ushastry.sock'  port: 3306  MySQL Community Server (GPL)
2021-09-20T06:28:36.995563Z 0 [Note] Giving 0 client threads a chance to die gracefully
2021-09-20T06:28:36.995586Z 0 [Note] Shutting down slave threads
2021-09-20T06:28:36.995590Z 0 [Note] Forcefully disconnecting 0 remaining clients
2021-09-20T06:28:36.995601Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2021-09-20T06:28:36.995697Z 0 [Note] Binlog end
2021-09-20T06:28:36.996067Z 0 [Note] Shutting down plugin 'ngram'
2021-09-20T06:28:36.996071Z 0 [Note] Shutting down plugin 'ARCHIVE'
2021-09-20T06:28:36.996073Z 0 [Note] Shutting down plugin 'partition'
2021-09-20T06:28:36.996075Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2021-09-20T06:28:36.996077Z 0 [Note] Shutting down plugin 'MEMORY'
2021-09-20T06:28:36.996079Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2021-09-20T06:28:36.996097Z 0 [Note] Shutting down plugin 'MyISAM'
2021-09-20T06:28:36.996103Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2021-09-20T06:28:36.996105Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-09-20T06:28:36.996106Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-09-20T06:28:36.996108Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-09-20T06:28:36.996109Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-09-20T06:28:36.996111Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-09-20T06:28:36.996112Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2021-09-20T06:28:36.996113Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2021-09-20T06:28:36.996115Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2021-09-20T06:28:36.996116Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2021-09-20T06:28:36.996117Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2021-09-20T06:28:36.996119Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2021-09-20T06:28:36.996120Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2021-09-20T06:28:36.996122Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2021-09-20T06:28:36.996123Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2021-09-20T06:28:36.996124Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2021-09-20T06:28:36.996126Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2021-09-20T06:28:36.996127Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2021-09-20T06:28:36.996128Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2021-09-20T06:28:36.996130Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2021-09-20T06:28:36.996131Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2021-09-20T06:28:36.996133Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2021-09-20T06:28:36.996134Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2021-09-20T06:28:36.996136Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2021-09-20T06:28:36.996137Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2021-09-20T06:28:36.996139Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2021-09-20T06:28:36.996140Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2021-09-20T06:28:36.996141Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2021-09-20T06:28:36.996143Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2021-09-20T06:28:36.996144Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2021-09-20T06:28:36.996146Z 0 [Note] Shutting down plugin 'InnoDB'
2021-09-20T06:28:36.996198Z 0 [Note] InnoDB: FTS optimize thread exiting.
2021-09-20T06:28:36.996760Z 0 [Note] InnoDB: Starting shutdown...
2021-09-20T06:28:37.096916Z 0 [Note] InnoDB: Dumping buffer pool(s) to /export/home/tmp/ushastry/mysql-5.7.35/104984/ib_buffer_pool
2021-09-20T06:28:37.097196Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210920  8:28:37
2021-09-20T06:28:38.705894Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2757068
2021-09-20T06:28:38.706832Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-09-20T06:28:38.706844Z 0 [Note] Shutting down plugin 'CSV'
2021-09-20T06:28:38.706848Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2021-09-20T06:28:38.706851Z 0 [Note] Shutting down plugin 'sha256_password'
2021-09-20T06:28:38.706853Z 0 [Note] Shutting down plugin 'mysql_native_password'
2021-09-20T06:28:38.706960Z 0 [Note] Shutting down plugin 'binlog'
2021-09-20T06:28:38.707319Z 0 [Note] bin/mysqld: Shutdown complete

2021-09-20T06:28:58.555685Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2021-09-20T06:28:58.555737Z 0 [Note] [MY-010949] [Server] Basedir set to /export/home/tmp/ushastry/mysql-8.0.23/.
2021-09-20T06:28:58.555750Z 0 [System] [MY-010116] [Server] /export/home/tmp/ushastry/mysql-8.0.23/bin/mysqld (mysqld 8.0.23) starting as process 7161
2021-09-20T06:28:58.561685Z 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO
2021-09-20T06:28:58.561924Z 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
2021-09-20T06:28:58.563539Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2021-09-20T06:28:58.563624Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-09-20T06:28:58.563673Z 1 [Note] [MY-013546] [InnoDB] Atomic write enabled
2021-09-20T06:28:58.563742Z 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2021-09-20T06:28:58.563799Z 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
2021-09-20T06:28:58.563855Z 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2021-09-20T06:28:58.563920Z 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.11
2021-09-20T06:28:58.565065Z 1 [Note] [MY-013251] [InnoDB] Number of pools: 1
2021-09-20T06:28:58.565216Z 1 [Note] [MY-012951] [InnoDB] Using CPU crc32 instructions
2021-09-20T06:28:58.565604Z 1 [Note] [MY-012203] [InnoDB] Directories to scan './'
2021-09-20T06:28:58.565735Z 1 [Note] [MY-012204] [InnoDB] Scanning './'
2021-09-20T06:28:58.567263Z 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 22 files.
2021-09-20T06:28:58.567862Z 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M
2021-09-20T06:28:58.573063Z 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2021-09-20T06:28:58.575899Z 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-09-20T06:28:58.660318Z 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 2
2021-09-20T06:28:58.660500Z 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 4
2021-09-20T06:28:58.660663Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
2021-09-20T06:28:58.660904Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
2021-09-20T06:28:58.663245Z 1 [Note] [MY-012529] [InnoDB] Redo log format is v1. The redo log was created before MySQL 8.0.3.
2021-09-20T06:28:58.663377Z 1 [Note] [MY-012557] [InnoDB] Redo log is from an earlier version, v1.
2021-09-20T06:28:58.663988Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2021-09-20T06:28:58.664418Z 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ...
2021-09-20T06:28:58.664593Z 1 [Note] [MY-012535] [InnoDB] Apply batch completed!
2021-09-20T06:28:58.664822Z 1 [Note] [MY-013041] [InnoDB] Upgrading redo log: 2*50331648 bytes, LSN=2757068
2021-09-20T06:28:58.665158Z 1 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2021-09-20T06:28:58.670230Z 1 [Note] [MY-012968] [InnoDB] Starting to delete and rewrite log files.
2021-09-20T06:28:58.676256Z 1 [Note] [MY-013575] [InnoDB] Creating log file ./ib_logfile101
2021-09-20T06:28:58.792653Z 1 [Note] [MY-013575] [InnoDB] Creating log file ./ib_logfile1
2021-09-20T06:28:58.991196Z 1 [Note] [MY-012892] [InnoDB] Renaming log file ./ib_logfile101 to ./ib_logfile0
2021-09-20T06:28:58.991498Z 1 [Note] [MY-012893] [InnoDB] New log files created, LSN=2757132
2021-09-20T06:28:58.991670Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2021-09-20T06:28:58.992333Z 1 [Note] [MY-013040] [InnoDB] Will create 2 new undo tablespaces.
2021-09-20T06:28:58.994785Z 1 [Note] [MY-012896] [InnoDB] Creating UNDO Tablespace ./undo_001
2021-09-20T06:28:58.995030Z 1 [Note] [MY-012897] [InnoDB] Setting file ./undo_001 size to 16 MB
2021-09-20T06:28:58.995235Z 1 [Note] [MY-012898] [InnoDB] Physically writing the file full
2021-09-20T06:28:59.038153Z 1 [Note] [MY-012896] [InnoDB] Creating UNDO Tablespace ./undo_002
2021-09-20T06:28:59.038376Z 1 [Note] [MY-012897] [InnoDB] Setting file ./undo_002 size to 16 MB
2021-09-20T06:28:59.038587Z 1 [Note] [MY-012898] [InnoDB] Physically writing the file full
2021-09-20T06:28:59.079953Z 1 [Note] [MY-012915] [InnoDB] Created 2 undo tablespaces.
2021-09-20T06:28:59.080281Z 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 0
2021-09-20T06:28:59.082001Z 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2021-09-20T06:28:59.082259Z 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-09-20T06:28:59.111875Z 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
2021-09-20T06:28:59.112333Z 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/'
2021-09-20T06:28:59.151957Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2021-09-20T06:28:59.154645Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in undo tablespace number 1. 128 are now active.
2021-09-20T06:28:59.158171Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in undo tablespace number 2. 128 are now active.
2021-09-20T06:28:59.294356Z 1 [Note] [MY-012976] [InnoDB] 8.0.23 started; log sequence number 5115852
2021-09-20T06:28:59.295454Z 1 [Note] [MY-012922] [InnoDB] Waiting for purge to start
2021-09-20T06:28:59.348969Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-09-20T06:28:59.351783Z 1 [Note] [MY-011088] [Server] Data dictionary initializing version '80023'.
2021-09-20T06:28:59.858529Z 1 [Note] [MY-010337] [Server] Created Data Dictionary for upgrade
2021-09-20T06:28:59.873688Z 0 [Note] [MY-011332] [Server] Plugin mysqlx reported: 'IPv6 is available'
2021-09-20T06:28:59.875913Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. bind-address: '::' port: 33330'
2021-09-20T06:28:59.876112Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. socket: '/tmp/mysql_x_ushastry.sock''
2021-09-20T06:28:59.876305Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33330, socket: /tmp/mysql_x_ushastry.sock
2021-09-20T06:29:00.870108Z 2 [System] [MY-011003] [Server] Finished populating Data Dictionary tables with data.
2021-09-20T06:29:00.873163Z 2 [Note] [MY-011008] [Server] Finished migrating TABLE statistics data.
2021-09-20T06:29:00.875356Z 2 [Note] [MY-011008] [Server] Finished migrating TABLE statistics data.
2021-09-20T06:29:01.570539Z 2 [Note] [MY-010006] [Server] Using data dictionary with version '80023'.
2021-09-20T06:29:01.967879Z 5 [System] [MY-013381] [Server] Server upgrade from '50700' to '80023' started.
2021-09-20T06:29:01.969107Z 5 [Note] [MY-013386] [Server] Running queries to upgrade MySQL server.
2021-09-20T06:29:05.524701Z 5 [Note] [MY-013387] [Server] Upgrading system table data.
2021-09-20T06:29:05.843510Z 5 [Note] [MY-013385] [Server] Upgrading the sys schema.
2021-09-20T06:29:06.382932Z 5 [Note] [MY-013400] [Server] Upgrade of help tables started.
2021-09-20T06:29:06.508480Z 5 [Note] [MY-013400] [Server] Upgrade of help tables completed.
2021-09-20T06:29:06.508829Z 5 [Note] [MY-013394] [Server] Checking 'mysql' schema.
2021-09-20T06:29:06.619106Z 5 [Note] [MY-013394] [Server] Checking 'sys' schema.
2021-09-20T06:29:06.640011Z 5 [Note] [MY-013394] [Server] Checking 'test' schema.
2021-09-20T06:29:06.660559Z 5 [System] [MY-013381] [Server] Server upgrade from '50700' to '80023' completed.
2021-09-20T06:29:06.699706Z 0 [Note] [MY-010902] [Server] Thread priority attribute setting in Resource Group SQL shall be ignored due to unsupported platform or insufficient privilege.
2021-09-20T06:29:06.711812Z 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin
2021-09-20T06:29:06.712438Z 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end
2021-09-20T06:29:06.713000Z 0 [Note] [MY-011946] [InnoDB] Loading buffer pool(s) from /export/home/tmp/ushastry/mysql-5.7.35/104984/ib_buffer_pool
2021-09-20T06:29:06.713556Z 0 [Note] [MY-011946] [InnoDB] Buffer pool(s) load completed at 210920  8:29:06
2021-09-20T06:29:06.722517Z 0 [Note] [MY-010913] [Server] You have not provided a mandatory server-id. Servers in a replication topology must have unique server-ids. Please refer to the proper server start-up parameters documentation.
2021-09-20T06:29:06.724258Z 0 [Note] [MY-010182] [Server] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2021-09-20T06:29:06.724567Z 0 [Note] [MY-010304] [Server] Skipping generation of SSL certificates as certificate files are present in data directory.
2021-09-20T06:29:06.725721Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-09-20T06:29:06.726015Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-09-20T06:29:06.726290Z 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --sha256_password_auto_generate_rsa_keys as key files are present in data directory.
2021-09-20T06:29:06.726600Z 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --caching_sha2_password_auto_generate_rsa_keys as key files are present in data directory.
2021-09-20T06:29:06.727037Z 0 [Note] [MY-010252] [Server] Server hostname (bind-address): '*'; port: 3306
2021-09-20T06:29:06.727343Z 0 [Note] [MY-010253] [Server] IPv6 is available.
2021-09-20T06:29:06.727668Z 0 [Note] [MY-010264] [Server]   - '::' resolves to '::';
2021-09-20T06:29:06.727958Z 0 [Note] [MY-010251] [Server] Server socket created on IP: '::'.
2021-09-20T06:29:06.730135Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/export/home/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2021-09-20T06:29:06.741918Z 0 [Note] [MY-011025] [Repl] Failed to start slave threads for channel ''.
2021-09-20T06:29:06.743845Z 8 [Note] [MY-010051] [Server] Event Scheduler: scheduler thread started with id 8
2021-09-20T06:29:06.743999Z 0 [Note] [MY-011240] [Server] Plugin mysqlx reported: 'Using SSL configuration from MySQL Server'
2021-09-20T06:29:06.744528Z 0 [Note] [MY-011243] [Server] Plugin mysqlx reported: 'Using OpenSSL for TLS connections'
2021-09-20T06:29:06.744699Z 0 [System] [MY-010931] [Server] /export/home/tmp/ushastry/mysql-8.0.23/bin/mysqld: ready for connections. Version: '8.0.23'  socket: '/tmp/mysql_ushastry.sock'  port: 3306  MySQL Community Server - GPL.
2021-09-20T06:29:55.484061Z 10 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.23).
2021-09-20T06:29:55.484810Z 0 [Note] [MY-010067] [Server] Giving 1 client threads a chance to die gracefully
2021-09-20T06:29:55.484843Z 0 [Note] [MY-010117] [Server] Shutting down slave threads
2021-09-20T06:29:55.484852Z 0 [Note] [MY-010054] [Server] Event Scheduler: Killing the scheduler thread, thread id 8
2021-09-20T06:29:55.484858Z 0 [Note] [MY-010050] [Server] Event Scheduler: Waiting for the scheduler thread to reply
2021-09-20T06:29:55.484958Z 0 [Note] [MY-010048] [Server] Event Scheduler: Stopped
2021-09-20T06:29:55.484964Z 0 [Note] [MY-010118] [Server] Forcefully disconnecting 0 remaining clients
2021-09-20T06:29:55.484975Z 0 [Note] [MY-010043] [Server] Event Scheduler: Purging the queue. 0 events
2021-09-20T06:29:55.486204Z 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting.
2021-09-20T06:29:55.664177Z 0 [Note] [MY-010120] [Server] Binlog end
2021-09-20T06:29:55.666288Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx'
2021-09-20T06:29:55.666768Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx_cache_cleaner'
2021-09-20T06:29:55.666785Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'ngram'
2021-09-20T06:29:55.666791Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'BLACKHOLE'
2021-09-20T06:29:55.666804Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'ARCHIVE'
2021-09-20T06:29:55.666808Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'TempTable'
2021-09-20T06:29:55.666812Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'PERFORMANCE_SCHEMA'
2021-09-20T06:29:55.666853Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MRG_MYISAM'
2021-09-20T06:29:55.666858Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MyISAM'
2021-09-20T06:29:55.666866Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_SESSION_TEMP_TABLESPACES'
2021-09-20T06:29:55.666871Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CACHED_INDEXES'
2021-09-20T06:29:55.666875Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_VIRTUAL'
2021-09-20T06:29:55.666879Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_COLUMNS'
2021-09-20T06:29:55.666883Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESPACES'
2021-09-20T06:29:55.666886Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_INDEXES'
2021-09-20T06:29:55.666890Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESTATS'
2021-09-20T06:29:55.666894Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLES'
2021-09-20T06:29:55.666898Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2021-09-20T06:29:55.666902Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2021-09-20T06:29:55.666906Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_CONFIG'
2021-09-20T06:29:55.666909Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2021-09-20T06:29:55.666913Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DELETED'
2021-09-20T06:29:55.666917Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2021-09-20T06:29:55.666921Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_METRICS'
2021-09-20T06:29:55.666924Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2021-09-20T06:29:55.666928Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2021-09-20T06:29:55.666932Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2021-09-20T06:29:55.666936Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE'
2021-09-20T06:29:55.666940Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2021-09-20T06:29:55.666944Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2021-09-20T06:29:55.666948Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM_RESET'
2021-09-20T06:29:55.666952Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM'
2021-09-20T06:29:55.666955Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_RESET'
2021-09-20T06:29:55.666960Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP'
2021-09-20T06:29:55.666963Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TRX'
2021-09-20T06:29:55.666967Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'InnoDB'
2021-09-20T06:29:55.666994Z 0 [Note] [MY-013072] [InnoDB] Starting shutdown...
2021-09-20T06:29:55.667265Z 0 [Note] [MY-011944] [InnoDB] Dumping buffer pool(s) to /export/home/tmp/ushastry/mysql-5.7.35/104984/ib_buffer_pool
2021-09-20T06:29:55.667706Z 0 [Note] [MY-011944] [InnoDB] Buffer pool(s) dump completed at 210920  8:29:55
2021-09-20T06:29:55.950676Z 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2021-09-20T06:29:56.458611Z 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 29613258
2021-09-20T06:29:56.459483Z 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1"
2021-09-20T06:29:56.459502Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MEMORY'
2021-09-20T06:29:56.459509Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'CSV'
2021-09-20T06:29:56.459516Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha2_cache_cleaner'
2021-09-20T06:29:56.459527Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'caching_sha2_password'
2021-09-20T06:29:56.459535Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha256_password'
2021-09-20T06:29:56.459539Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysql_native_password'
2021-09-20T06:29:56.459689Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'binlog'
2021-09-20T06:29:56.460841Z 0 [System] [MY-010910] [Server] /export/home/tmp/ushastry/mysql-8.0.23/bin/mysqld: Shutdown complete (mysqld 8.0.23)  MySQL Community Server - GPL.
2021-09-20T06:30:23.515051Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2021-09-20T06:30:23.515101Z 0 [Note] [MY-010949] [Server] Basedir set to /export/home/tmp/ushastry/mysql-8.0.23/.
2021-09-20T06:30:23.515115Z 0 [System] [MY-010116] [Server] /export/home/tmp/ushastry/mysql-8.0.23/bin/mysqld (mysqld 8.0.23) starting as process 7307
2021-09-20T06:30:23.520031Z 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO
2021-09-20T06:30:23.520246Z 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
2021-09-20T06:30:23.521805Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-09-20T06:30:23.521865Z 1 [Note] [MY-013546] [InnoDB] Atomic write enabled
2021-09-20T06:30:23.521920Z 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2021-09-20T06:30:23.521962Z 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
2021-09-20T06:30:23.522004Z 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2021-09-20T06:30:23.522050Z 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.11
2021-09-20T06:30:23.523422Z 1 [Note] [MY-013251] [InnoDB] Number of pools: 1
2021-09-20T06:30:23.523559Z 1 [Note] [MY-012951] [InnoDB] Using CPU crc32 instructions
2021-09-20T06:30:23.523909Z 1 [Note] [MY-012203] [InnoDB] Directories to scan './'
2021-09-20T06:30:23.524011Z 1 [Note] [MY-012204] [InnoDB] Scanning './'
2021-09-20T06:30:23.524690Z 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 6 files.
2021-09-20T06:30:23.525261Z 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M
2021-09-20T06:30:23.530803Z 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2021-09-20T06:30:23.532794Z 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-09-20T06:30:23.533097Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
2021-09-20T06:30:23.533412Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
2021-09-20T06:30:23.625099Z 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 2
2021-09-20T06:30:23.625222Z 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 4
2021-09-20T06:30:23.625315Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
2021-09-20T06:30:23.625440Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
2021-09-20T06:30:23.625865Z 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 29613084, whereas checkpoint_lsn = 29613258 and start_lsn = 29613056
2021-09-20T06:30:23.627914Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2021-09-20T06:30:23.628264Z 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ...
2021-09-20T06:30:23.628450Z 1 [Note] [MY-012535] [InnoDB] Apply batch completed!
2021-09-20T06:30:23.628753Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
2021-09-20T06:30:23.629787Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
2021-09-20T06:30:23.630902Z 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
2021-09-20T06:30:23.631052Z 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 4759
2021-09-20T06:30:23.639422Z 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2021-09-20T06:30:23.639646Z 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-09-20T06:30:23.671807Z 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
2021-09-20T06:30:23.672136Z 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/'
2021-09-20T06:30:23.713353Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2021-09-20T06:30:23.713819Z 1 [Note] [MY-012976] [InnoDB] 8.0.23 started; log sequence number 29613258
2021-09-20T06:30:23.714818Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-09-20T06:30:23.719332Z 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80023'.
2021-09-20T06:30:23.801056Z 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files
2021-09-20T06:30:23.802029Z 1 [Note] [MY-012356] [InnoDB] Validated 8/8  tablespaces
2021-09-20T06:30:23.813104Z 1 [Note] [MY-010006] [Server] Using data dictionary with version '80023'.
2021-09-20T06:30:23.818147Z 0 [Note] [MY-011332] [Server] Plugin mysqlx reported: 'IPv6 is available'
2021-09-20T06:30:23.820561Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. bind-address: '::' port: 33330'
2021-09-20T06:30:23.820721Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. socket: '/tmp/mysql_x_ushastry.sock''
2021-09-20T06:30:23.820871Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33330, socket: /tmp/mysql_x_ushastry.sock
2021-09-20T06:30:23.833735Z 0 [Note] [MY-010902] [Server] Thread priority attribute setting in Resource Group SQL shall be ignored due to unsupported platform or insufficient privilege.
2021-09-20T06:30:23.850657Z 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin
2021-09-20T06:30:23.850912Z 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end
2021-09-20T06:30:23.851223Z 0 [Note] [MY-011946] [InnoDB] Loading buffer pool(s) from /export/home/tmp/ushastry/mysql-5.7.35/104984/ib_buffer_pool
2021-09-20T06:30:23.854650Z 0 [Note] [MY-011946] [InnoDB] Buffer pool(s) load completed at 210920  8:30:23
2021-09-20T06:30:23.859560Z 0 [Note] [MY-012922] [InnoDB] Waiting for purge to start
2021-09-20T06:30:23.915970Z 0 [Note] [MY-010913] [Server] You have not provided a mandatory server-id. Servers in a replication topology must have unique server-ids. Please refer to the proper server start-up parameters documentation.
2021-09-20T06:30:23.917704Z 0 [Note] [MY-010182] [Server] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2021-09-20T06:30:23.917895Z 0 [Note] [MY-010304] [Server] Skipping generation of SSL certificates as certificate files are present in data directory.
2021-09-20T06:30:23.918963Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-09-20T06:30:23.919170Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-09-20T06:30:23.919360Z 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --sha256_password_auto_generate_rsa_keys as key files are present in data directory.
2021-09-20T06:30:23.919578Z 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --caching_sha2_password_auto_generate_rsa_keys as key files are present in data directory.
2021-09-20T06:30:23.919913Z 0 [Note] [MY-010252] [Server] Server hostname (bind-address): '*'; port: 3306
2021-09-20T06:30:23.920148Z 0 [Note] [MY-010253] [Server] IPv6 is available.
2021-09-20T06:30:23.920345Z 0 [Note] [MY-010264] [Server]   - '::' resolves to '::';
2021-09-20T06:30:23.920588Z 0 [Note] [MY-010251] [Server] Server socket created on IP: '::'.
2021-09-20T06:30:23.934647Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/export/home/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2021-09-20T06:30:23.948503Z 0 [Note] [MY-011025] [Repl] Failed to start slave threads for channel ''.
2021-09-20T06:30:23.950444Z 5 [Note] [MY-010051] [Server] Event Scheduler: scheduler thread started with id 5
2021-09-20T06:30:23.950766Z 0 [Note] [MY-011240] [Server] Plugin mysqlx reported: 'Using SSL configuration from MySQL Server'
2021-09-20T06:30:23.951276Z 0 [Note] [MY-011243] [Server] Plugin mysqlx reported: 'Using OpenSSL for TLS connections'
2021-09-20T06:30:23.951492Z 0 [System] [MY-010931] [Server] /export/home/tmp/ushastry/mysql-8.0.23/bin/mysqld: ready for connections. Version: '8.0.23'  socket: '/tmp/mysql_ushastry.sock'  port: 3306  MySQL Community Server - GPL.
2021-09-20T06:30:32.799033Z 7 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.23).
2021-09-20T06:30:32.799682Z 0 [Note] [MY-010067] [Server] Giving 1 client threads a chance to die gracefully
2021-09-20T06:30:32.799716Z 0 [Note] [MY-010117] [Server] Shutting down slave threads
2021-09-20T06:30:32.799733Z 0 [Note] [MY-010054] [Server] Event Scheduler: Killing the scheduler thread, thread id 5
2021-09-20T06:30:32.799742Z 0 [Note] [MY-010050] [Server] Event Scheduler: Waiting for the scheduler thread to reply
2021-09-20T06:30:32.799922Z 0 [Note] [MY-010048] [Server] Event Scheduler: Stopped
2021-09-20T06:30:32.799937Z 0 [Note] [MY-010118] [Server] Forcefully disconnecting 0 remaining clients
2021-09-20T06:30:32.799946Z 0 [Note] [MY-010043] [Server] Event Scheduler: Purging the queue. 0 events
2021-09-20T06:30:32.801157Z 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting.
2021-09-20T06:30:32.805814Z 0 [Note] [MY-010120] [Server] Binlog end
2021-09-20T06:30:32.807900Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx'
2021-09-20T06:30:32.808230Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx_cache_cleaner'
2021-09-20T06:30:32.808244Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'ngram'
2021-09-20T06:30:32.808249Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'BLACKHOLE'
2021-09-20T06:30:32.808256Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'ARCHIVE'
2021-09-20T06:30:32.808260Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'TempTable'
2021-09-20T06:30:32.808264Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'PERFORMANCE_SCHEMA'
2021-09-20T06:30:32.808300Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MRG_MYISAM'
2021-09-20T06:30:32.808304Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MyISAM'
2021-09-20T06:30:32.808316Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_SESSION_TEMP_TABLESPACES'
2021-09-20T06:30:32.808321Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CACHED_INDEXES'
2021-09-20T06:30:32.808325Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_VIRTUAL'
2021-09-20T06:30:32.808329Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_COLUMNS'
2021-09-20T06:30:32.808332Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESPACES'
2021-09-20T06:30:32.808336Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_INDEXES'
2021-09-20T06:30:32.808340Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESTATS'
2021-09-20T06:30:32.808344Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLES'
2021-09-20T06:30:32.808348Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2021-09-20T06:30:32.808352Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2021-09-20T06:30:32.808357Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_CONFIG'
2021-09-20T06:30:32.808362Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2021-09-20T06:30:32.808365Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DELETED'
2021-09-20T06:30:32.808369Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2021-09-20T06:30:32.808388Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_METRICS'
2021-09-20T06:30:32.808392Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2021-09-20T06:30:32.808435Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2021-09-20T06:30:32.808455Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2021-09-20T06:30:32.808462Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE'
2021-09-20T06:30:32.808467Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2021-09-20T06:30:32.808471Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2021-09-20T06:30:32.808475Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM_RESET'
2021-09-20T06:30:32.808479Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM'
2021-09-20T06:30:32.808483Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_RESET'
2021-09-20T06:30:32.808487Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP'
2021-09-20T06:30:32.808491Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TRX'
2021-09-20T06:30:32.808494Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'InnoDB'
2021-09-20T06:30:32.808513Z 0 [Note] [MY-013072] [InnoDB] Starting shutdown...
2021-09-20T06:30:32.808600Z 0 [Note] [MY-011944] [InnoDB] Dumping buffer pool(s) to /export/home/tmp/ushastry/mysql-5.7.35/104984/ib_buffer_pool
2021-09-20T06:30:32.810176Z 0 [Note] [MY-011944] [InnoDB] Buffer pool(s) dump completed at 210920  8:30:32
2021-09-20T06:30:32.819636Z 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2021-09-20T06:30:33.328135Z 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 29639457
2021-09-20T06:30:33.329127Z 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1"
2021-09-20T06:30:33.329147Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MEMORY'
2021-09-20T06:30:33.329155Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'CSV'
2021-09-20T06:30:33.329162Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha2_cache_cleaner'
2021-09-20T06:30:33.329167Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'caching_sha2_password'
2021-09-20T06:30:33.329174Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha256_password'
2021-09-20T06:30:33.329178Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysql_native_password'
2021-09-20T06:30:33.329333Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'binlog'
2021-09-20T06:30:33.329947Z 0 [System] [MY-010910] [Server] /export/home/tmp/ushastry/mysql-8.0.23/bin/mysqld: Shutdown complete (mysqld 8.0.23)  MySQL Community Server - GPL.