#innodb_flush_log_at_trx_commit 에 따른 입력건수 성능비교

#innodb_flush_log_at_trx_commit 에 따른 입력건수 성능비교
#innodb_flush_log_at_trx_commit 에 따른 입력건수 성능비교
#innodb_flush_log_at_trx_commit 에 따른 입력건수 성능비교
#innodb_flush_log_at_trx_commit 에 따른 입력건수 성능비교
#innodb_flush_log_at_trx_commit 에 따른 입력건수 성능비교

 

 

#QUEUE사용안함
#QUEUE사용안함

 

#QUEUE사용안함

#SERIAL형식의 입력
#SERIAL형식의 입력
#SERIAL형식의 입력
#SERIAL형식의 입력

 

mysql> select sum(T2.t_cnt) from DUMMY T1, (select substr(regtime,1,17) as t_regtime, count(1) as t_cnt from RB_OCUS_POS_TEST2 group by substr(regtime,1,17)) T2;
+---------------+
| sum(T2.t_cnt) |
+---------------+
|        161297 |
+---------------+
1 row in set (0.26 sec)

mysql>

mysql> show variables like 'innodb_flush_log_at_trx_commit';
+--------------------------------+-------+
| Variable_name                  | Value |
+--------------------------------+-------+
| innodb_flush_log_at_trx_commit | 1     |
+--------------------------------+-------+
1 row in set (0.04 sec)

1SEC > 647.7791164658635 입력

mysql> show variables like 'innodb_flush_log_at_trx_commit';
+--------------------------------+-------+
| Variable_name                  | Value |
+--------------------------------+-------+
| innodb_flush_log_at_trx_commit | 0     |
+--------------------------------+-------+
1 row in set (0.04 sec)

>>begin[20190829 07:23:04(988)],end[20190829 07:23:23(968)]

1SEC > 8489.315789473684 입력

mysql> show variables like 'innodb_flush_log_at_trx_commit';
+--------------------------------+-------+
| Variable_name                  | Value |
+--------------------------------+-------+
| innodb_flush_log_at_trx_commit | 2     |
+--------------------------------+-------+
1 row in set (0.04 sec)

>>begin[20190829 07:25:41(568)],end[20190829 07:26:05(191)]

1SEC > 6451.88 입력