|
$ cat /etc/sysctl.conf
|
kernel.shmmax = 2705817600
|
kernel.shmall = 660600
|
vm.nr_hugepages = 500
|
vm.hugetlb_shm_group = 2001
|
|
$ id mysql
|
uid=2001(mysql) gid=2001(mysql) groups=2001(mysql)
|
|
$ cat /etc/security/limits.conf
|
mysql soft nproc 131072
|
mysql hard nproc 131072
|
mysql soft nofile 131072
|
mysql hard nofile 131072
|
mysql soft core unlimited
|
mysql hard core unlimited
|
mysql soft memlock unlimited
|
mysql hard memlock unlimited
|
|
$ free -h
|
total used free shared buff/cache available
|
Mem: 2.8G 1.1G 250M 2.2M 1.5G 1.5G
|
Swap: 1.5G 50M 1.5G
|
|
$ cat /proc/meminfo | grep -i huge
|
AnonHugePages: 2048 kB
|
HugePages_Total: 500
|
HugePages_Free: 500
|
HugePages_Rsvd: 0
|
HugePages_Surp: 0
|
Hugepagesize: 2048 kB
|
|
$ cat /etc/my.cnf | grep large-pages
|
large-pages
|
|
$ mysqld_safe &
|
[1] 67750
|
170909 01:34:39 mysqld_safe Logging to '/MGC/datadg/log/alert_MGC.log'.
|
170909 01:34:40 mysqld_safe Starting mysqld daemon with databases from /MGC/datadg/db
|
|
$ cat /MGC/datadg/log/alert_MGC.log | grep -i "Warning: Using conventional memory pool"
|
|
$ cat /proc/meminfo | grep -i huge
|
AnonHugePages: 88064 kB
|
HugePages_Total: 500
|
HugePages_Free: 499
|
HugePages_Rsvd: 115
|
HugePages_Surp: 0
|
Hugepagesize: 2048 kB
|
|
|
01:36:47 (root@localhost) [(none)]> select version();
|
+--------------------+
|
| version() |
|
+--------------------+
|
| 10.2.7-MariaDB-log |
|
+--------------------+
|
1 row in set (0.00 sec)
|
|
01:37:29 (root@localhost) [(none)]> select count(*) from test.a;
|
+----------+
|
| count(*) |
|
+----------+
|
| 3263442 |
|
+----------+
|
1 row in set (2.44 sec)
|
|
|
$ cat /proc/meminfo | grep -i huge
|
AnonHugePages: 167936 kB
|
HugePages_Total: 500
|
HugePages_Free: 499
|
HugePages_Rsvd: 115
|
HugePages_Surp: 0
|
Hugepagesize: 2048 kB
|
|
$ free -h
|
total used free shared buff/cache available
|
Mem: 2.8G 1.2G 76M 2.2M 1.4G 1.3G
|
Swap: 1.5G 50M 1.5G
|
|
$ ll -h
|
total 109M
|
-rw-rw---- 1 mysql mysql 432 Sep 8 23:34 a.frm
|
-rw-rw---- 1 mysql mysql 108M Sep 8 23:36 a.ibd
|
|
> show global variables like '%buffer%';
|
+-------------------------------------+----------------+
|
| Variable_name | Value |
|
+-------------------------------------+----------------+
|
| aria_pagecache_buffer_size | 134217728 |
|
| aria_sort_buffer_size | 268434432 |
|
| bulk_insert_buffer_size | 8388608 |
|
| innodb_buffer_pool_chunk_size | 134217728 |
|
| innodb_buffer_pool_dump_at_shutdown | ON |
|
| innodb_buffer_pool_dump_now | OFF |
|
| innodb_buffer_pool_dump_pct | 25 |
|
| innodb_buffer_pool_filename | ib_buffer_pool |
|
| innodb_buffer_pool_instances | 1 |
|
| innodb_buffer_pool_load_abort | OFF |
|
| innodb_buffer_pool_load_at_startup | ON |
|
| innodb_buffer_pool_load_now | OFF |
|
| innodb_buffer_pool_populate | OFF |
|
| innodb_buffer_pool_size | 134217728 |
|
| innodb_change_buffer_max_size | 25 |
|
| innodb_change_buffering | all |
|
| innodb_log_buffer_size | 16777216 |
|
| innodb_sort_buffer_size | 1048576 |
|
| join_buffer_size | 262144 |
|
| join_buffer_space_limit | 2097152 |
|
| key_buffer_size | 134217728 |
|
| mrr_buffer_size | 262144 |
|
| myisam_sort_buffer_size | 134216704 |
|
| net_buffer_length | 16384 |
|
| preload_buffer_size | 32768 |
|
| read_buffer_size | 131072 |
|
| read_rnd_buffer_size | 262144 |
|
| sort_buffer_size | 2097152 |
|
| sql_buffer_result | OFF |
|
+-------------------------------------+----------------+
|
|
Bug
Major
