MySQL 8 关闭 performance_schema = off，可以瞬间节省200~300M左右内存
分类目录归档：MySQL
查询MySQL全局和会话时区（time_zone）当前值
SELECT @@GLOBAL.time_zone, @@SESSION.time_zone;MySQL索引失效
关于update by = count 自己
共享锁、排他锁、行锁(innodb)、页级锁(bdb)、乐观锁、悲观锁、读锁、写锁、
ROWID、DB_TRX_ID、DB_ROLL_PTR
redo log 和 bin log
Error Code: 1200. The server is not configured as slave; fix in config file
mysqldump emoji –default-character-set=utf8mb4
${MYSQLDUMPPATH}mysqldump –default-character-set=utf8mb4 -h${HOST} ${DUMPOPTION} –user=${MYSQLROOT} –password=${MYSQLPASS} ${DATABASE} | gzip -3 > ${TMP_PATH}${FILENAME}.gz