2021-04-15から1日間の記事一覧

SQLの読み書きブロック数確認

DB

MySQL (8.0.22) show session status like 'Innodb_buffer_pool_read_requests';show session status like 'Innodb_pages_read';select count(*) from tab1;show session status like 'Innodb_buffer_pool_read_requests';show session status like 'Innodb_…

SQLモード

DB

MySQL (8.0.22)https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html select @@sql_mode; ALLOW_INVALID_DATESANSI_QUOTESERROR_FOR_DIVISION_BY_ZERO ★デフォルトONHIGH_NOT_PRECEDENCEIGNORE_SPACENO_AUTO_VALUE_ON_ZERONO_BACKSLASH_ESCAPESNO_DIR_IN_…