以上数据可以看出这里 node0 到 node1 还是很慢的,居然比跨 socket 还慢,反过来说鲲鹏跨 socket 性能很好。
绑定 mysqld 到不同 node 的 page cache 操作:
1 systemctl stop mysql-server 2 vmtouch -e /usr/local/mysql/bin/mysqld 3 Files: 1 4 Directories: 0 5 Evicted Pages: 5916 (23M) 6 Elapsed: 0.00322 seconds 7 vmtouch -v /usr/local/mysql/bin/mysqld 8 /usr/local/mysql/bin/mysqld 9 [ ] 0/5916 10 Files: 1 11 Directories: 0 12 Resident Pages: 0/5916 0/23M 0% 13 Elapsed: 0.000204 seconds 14 taskset -c 24 md5sum /usr/local/mysql/bin/mysqld 15 grep mysqld /proc/`pidof mysqld`/numa_maps //检查mysqld具体绑定在哪个node上 16 00400000 default file=/usr/local/mysql/bin/mysqld mapped=3392 active=1 N0=3392 kernelpagesize_kB=4 17 0199b000 default file=/usr/local/mysql/bin/mysqld anon=10 dirty=10 mapped=134 active=10 N0=134 kernelpagesize_kB=4 18 01a70000 default file=/usr/local/mysql/bin/mysqld anon=43 dirty=43 mapped=120 active=43 N0=120 kernelpagesize_kB=4
服务热线
1391-024-6332