my mysql service vaguely stops all the time
I make the optimization settings, still the same
//////////////////////
Show Slow Log
//////////////////////
use x***************x;
SET timestamp=1648875745;
SELECT post_id FROM byw_postmeta, byw_posts WHERE ID = post_id AND post_type = 'attachment' AND meta_key = '_wp_old_slug' AND meta_value = 'bifo-2m-sm-sc-lc-9-125%c2%b5-lszh-duplex-fiber-optik-patch-kablo';
/www/server/mysql/bin/mysqld, Version: 5.7.32-log (Source distribution). started with:
Tcp port: 2295 Unix socket: /tmp/mysql.sock
Time Id Command Argument
Time: 2022-04-02T05:07:18.310935Z
User@Host: Px***x[Px***x] @ localhost [] Id: 48
Query_time: 52.469436 Lock_time: 3.370519 Rows_sent: 349 Rows_examined: 349
use Px******x;
SET timestamp=1648876038;
SELECT option_name, option_value FROM wpb_options WHERE autoload = 'yes';
Time: 2022-04-02T05:08:59.745375Z
User@Host: x************x[x************x] @ localhost [] Id: 70
Query_time: 4.994096 Lock_time: 1.257384 Rows_sent: 4 Rows_examined: 4
use x***************x;
SET timestamp=1648876139;
SHOW FULL COLUMNS FROM byw_options;
/www/server/mysql/bin/mysqld, Version: 5.7.32-log (Source distribution). started with:
Tcp port: 2295 Unix socket: /tmp/mysql.sock
Time Id Command Argument
Time: 2022-04-02T05:23:07.332660Z
User@Host: x************x[x************x] @ localhost [] Id: 95
Query_time: 13.159131 Lock_time: 3.385968 Rows_sent: 20 Rows_examined: 20
use x***************x;
SET timestamp=1648876987;
SELECT tr.object_id FROM byw_term_relationships AS tr INNER JOIN byw_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('nav_menu') AND tt.term_id IN ('1056') ORDER BY tr.object_id ASC;
Time: 2022-04-02T05:25:33.906401Z
User@Host: x************x[x************x] @ localhost [] Id: 105
Query_time: 4.314441 Lock_time: 0.360869 Rows_sent: 521 Rows_examined: 521
SET timestamp=1648877133;
SELECT option_name, option_value FROM byw_options WHERE autoload = 'yes';
/www/server/mysql/bin/mysqld, Version: 5.7.32-log (Source distribution). started with:
Tcp port: 2295 Unix socket: /tmp/mysql.sock
Time Id Command Argument
//////////////////
Logs
/////////////////
2021-10-26T15:24:30.512466Z 2380 [Note] Got an error reading communication packets
2021-10-26T16:35:05.710179Z 0 [Note] Giving 0 client threads a chance to die gracefully
2021-10-26T16:35:05.710226Z 0 [Note] Shutting down slave threads
2021-10-26T16:35:05.712058Z 0 [Note] Forcefully disconnecting 0 remaining clients
2021-10-26T16:35:05.712089Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2021-10-26T16:35:05.712212Z 0 [Note] Binlog end
2021-10-26T16:35:05.718145Z 0 [Note] Shutting down plugin 'ngram'
2021-10-26T16:35:05.718181Z 0 [Note] Shutting down plugin 'partition'
2021-10-26T16:35:05.718187Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2021-10-26T16:35:05.718194Z 0 [Note] Shutting down plugin 'ARCHIVE'
2021-10-26T16:35:05.718199Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2021-10-26T16:35:05.718270Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2021-10-26T16:35:05.718277Z 0 [Note] Shutting down plugin 'MyISAM'
2021-10-26T16:35:05.718292Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2021-10-26T16:35:05.718298Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-10-26T16:35:05.718303Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-10-26T16:35:05.718307Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-10-26T16:35:05.718311Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-10-26T16:35:05.718316Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-10-26T16:35:05.718320Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2021-10-26T16:35:05.718324Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2021-10-26T16:35:05.718328Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2021-10-26T16:35:05.718333Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2021-10-26T16:35:05.718337Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2021-10-26T16:35:05.718341Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2021-10-26T16:35:05.718345Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2021-10-26T16:35:05.718349Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2021-10-26T16:35:05.718353Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2021-10-26T16:35:05.718357Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2021-10-26T16:35:05.718362Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2021-10-26T16:35:05.718366Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2021-10-26T16:35:05.718370Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2021-10-26T16:35:05.718374Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2021-10-26T16:35:05.718379Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2021-10-26T16:35:05.718383Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2021-10-26T16:35:05.718387Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2021-10-26T16:35:05.718391Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2021-10-26T16:35:05.718396Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2021-10-26T16:35:05.718400Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2021-10-26T16:35:05.718404Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2021-10-26T16:35:05.718409Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2021-10-26T16:35:05.718413Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2021-10-26T16:35:05.718417Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2021-10-26T16:35:05.718421Z 0 [Note] Shutting down plugin 'InnoDB'
2021-10-26T16:35:05.719328Z 0 [Note] InnoDB: FTS optimize thread exiting.
2021-10-26T16:35:05.719768Z 0 [Note] InnoDB: Starting shutdown...
2021-10-26T16:35:05.820037Z 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2021-10-26T16:35:05.820720Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 211026 18:35:05
2021-10-26T16:35:06.771730Z 0 [Note] InnoDB: Shutdown completed; log sequence number 14206050267
2021-10-26T16:35:06.774556Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-10-26T16:35:06.774597Z 0 [Note] Shutting down plugin 'MEMORY'
2021-10-26T16:35:06.774605Z 0 [Note] Shutting down plugin 'CSV'
2021-10-26T16:35:06.774612Z 0 [Note] Shutting down plugin 'sha256_password'
2021-10-26T16:35:06.774616Z 0 [Note] Shutting down plugin 'mysql_native_password'
2021-10-26T16:35:06.774868Z 0 [Note] Shutting down plugin 'binlog'
2021-10-26T16:35:06.776954Z 0 [Note] /www/server/mysql/bin/mysqld: Shutdown complete
//////////////////////////////////
Optimization settings
///////////////////////////
