ユーザ用ツール

サイト用ツール


サイドバー



最近の更新



Tag Cloud

タグ#
8
10
1
3
1
2
17
7
1
1
4
12
4
1
2
248
1
8
2
7
17
5
1
30
3
3
1
6
1
1
44
1
3
3
1
1
1
1
1
1
32
46
7
9
10
7
10
3
3
2
9
2
2
6
6
1
1
4
10
4
3
3
2
1
8
2
4
1
6
30
2
12
2
3
1
1
2
2
1
1
2
4
3
2
4
2
2
1
1
2
1
2
1
2
1
27
2
1
2
2
2
1
1
2
3
15
5
8
1
1
2
13
1
6
1
2
12
1
2
1
1
4
10
1
6
2
1
6
1
3
3
11
1
2
1
1
10
3
1
14
1
1
4
1
2
1
2
9
2
2
3
1
1
3
1
2
1
2
2
2
1
2
3
1
4
3
4
1
3
1
3
3
2
1
1
7
1
3
3
1
1
1
3
5
1
35
2
2
2
1
2
2
3
1
1
1
4
1
2
1
3
1
1
1
1
5
2
5
2
1
1
1
4
3
2
4
2
1
2
1
18
1
1
2
2
1
1
2
1
1
2
1
1
1
1
2
1
1
1
1
1
9
6
1
3
1
1
3
1
1
1
1
1
01_linux:11_データベース:01_mysql:22_innodb_innodb_buffer_pool_size

22 INNODB innodb_buffer_pool_size を算出

最適なinnodb_buffer_pool_sizeを算出

SELECT CONCAT(CEILING(RIBPS/POWER(1024,pw)),SUBSTR(' KMGT',pw+1,1))
Recommended_InnoDB_Buffer_Pool_Size FROM
(
    SELECT RIBPS,FLOOR(LOG(RIBPS)/LOG(1024)) pw
    FROM
    (
        SELECT SUM(data_length+index_length)*1.1*growth RIBPS
        FROM information_schema.tables AAA,
        (SELECT 1.25 growth) BBB
        WHERE ENGINE='InnoDB'
    ) AA
) A;
01_linux/11_データベース/01_mysql/22_innodb_innodb_buffer_pool_size.txt · 最終更新: 2020/06/13 10:39 by matsui

Yesterday:2627 Today:2655 Total:60704