DB
PHP
入
Web DB
16
SCORE:
13 27
(+
132 7 0
(
0
%))
SCORE:
14 69
(+
146 9 0
(
0
%))
Slide 17
Slide 17 text
htop
htop
17
Slide 18
Slide 18 text
DB
DB
MySQL
innodb_buffer_pool_size
innodb_log_file_size
innodb_flush_log_at_trx_commit
innodb_flush_method
table_open_cache
thread_cache_size
max_connections
18
Slide 19
Slide 19 text
DB
PHP
入
Web DB
DB
19
SCORE:
13 27
(+
132 7 0
(
0
%))
SCORE:
14 69
(+
146 9 0
(
0
%))
SCORE:
16 95
(+
169 5 0
(
0
%))
Slide 20
Slide 20 text
Index
DB
Index
pt-query-digest
用
20
ALTER TABLE visit_history DROP INDEX tenant_id_idx;
ALTER TABLE visit_history ADD INDEX tenant_id_idx(tenant_id, competition_id, player_id, created_at);
Slide 21
Slide 21 text
Index
PHP
入
Web DB
DB
Index
21
SCORE:
13 27
(+
132 7 0
(
0
%))
SCORE:
14 69
(+
146 9 0
(
0
%))
SCORE:
16 95
(+
169 5 0
(
0
%))
SCORE:
18 67
(+
186 7 0
(
0
%))
Slide 22
Slide 22 text
N+
1
22
MySQL
App\Isuports\Handlers::playerHandler
N+
1 行