= Сообщение: 9069 из 10753 ===================================== RU.UNIX.BSD =
От : Sergey Anohin 2:5034/10.1 07 Jul 19 17:09:22
Кому : Alex Korchmar 07 Jul 19 17:09:22
Тема : Re: Еще одна причина уйти с ZFS
FGHI : area://RU.UNIX.BSD?msgid=2:5034/10.1+a353e73b
На : area://RU.UNIX.BSD?msgid=<1187511917@ddt.demos.su>+24f40d38
= Кодировка сообщения определена как: CP866 ==================================
Ответ: area://RU.UNIX.BSD?msgid=<1187511925@ddt.demos.su>+822a6b94
==============================================================================
Hello, Alex!
AK> тупого копирования этой же innodb, 4x write multiply - лехко, ну и вообще top
AK> стоило показать до и после).
Компрессию включил. Тестим тупое копирование.
(pts/2)[root@server:~]# sysctl vfs.zfs.prefetch_disable
vfs.zfs.prefetch_disable: 1
до:
last pid: 74368; load averages: 0.64, 0.36, 0.28 up 1+16:02:36 16:42:59
120 processes: 1 running, 119 sleeping
CPU: 0.0% user, 0.0% nice, 0.0% system, 0.0% interrupt, 100% idle
Mem: 2258M Active, 965M Inact, 401M Laundry, 3894M Wired, 300M Free
ARC: 3185M Total, 2957M MFU, 158M MRU, 3060K Anon, 17M Header, 52M Other
2821M Compressed, 2984M Uncompressed, 1.06:1 Ratio
Swap: 4096M Total, 155M Used, 3941M Free, 3% Inuse
во время (через 10 минут после старта):
last pid: 89204; load averages: 0.22, 0.25, 0.24 up 1+16:28:21 17:08:44
132 processes: 3 running, 129 sleeping
CPU: 1.2% user, 0.0% nice, 3.1% system, 0.0% interrupt, 95.7% idle
Mem: 2278M Active, 965M Inact, 401M Laundry, 3927M Wired, 249M Free
ARC: 3298M Total, 2727M MFU, 405M MRU, 80M Anon, 16M Header, 51M Other
2881M Compressed, 3057M Uncompressed, 1.06:1 Ratio
Swap: 4096M Total, 155M Used, 3941M Free, 3% Inuse
PID USERNAME THR PRI NICE SIZE RES STATE C TIME WCPU COMMAND
82038 root 1 20 0 21M 11M zio->i 2 0:08 5.08% hpt
84662 root 1 20 0 12M 3412K zio->i 0 0:04 1.29% cp
во время копирования:
(pts/2)[root@server:~]# zpool iostat 3
capacity operations bandwidth
pool alloc free read write read write
---------- ----- ----- ----- ----- ----- -----
zroot 380G 1,44T 90 31 11,6M 1,91M
zroot 380G 1,44T 71 63 8,95M 11,5M
zroot 380G 1,44T 90 31 11,2M 11,5M
zroot 380G 1,44T 93 34 11,7M 2,54M
zroot 380G 1,44T 70 72 8,77M 14,2M
zroot 380G 1,44T 100 20 12,6M 2,63M
zroot 380G 1,44T 78 51 9,74M 10,5M
zroot 380G 1,44T 89 20 11,2M 12,1M
zroot 380G 1,44T 95 38 12,0M 2,25M
zroot 380G 1,44T 61 101 7,58M 16,0M
zroot 381G 1,44T 112 26 14,0M 2,43M
zroot 381G 1,44T 73 48 9,16M 10,4M
zroot 381G 1,44T 81 68 10,2M 13,9M
(pts/2)[root@server:~]# zfs get compressratio,used,logicalused zroot/var/db/mysql
NAME PROPERTY VALUE SOURCE
zroot/var/db/mysql compressratio 1.00x -
zroot/var/db/mysql used 15,9G -
zroot/var/db/mysql logicalused 16,0G -
(pts/2)[root@server:~]# zfs get compressratio,used,logicalused zroot/var/db/mysql/ibdata
NAME PROPERTY VALUE SOURCE
zroot/var/db/mysql/ibdata compressratio 1.16x -
zroot/var/db/mysql/ibdata used 626M -
zroot/var/db/mysql/ibdata logicalused 730M -
(pts/2)[root@server:~]# zfs get compressratio,used,logicalused zroot/var/db/mysql/iblogs
NAME PROPERTY VALUE SOURCE
zroot/var/db/mysql/iblogs compressratio 1.00x -
zroot/var/db/mysql/iblogs used 512M -
zroot/var/db/mysql/iblogs logicalused 512M -
С наилучшими пожеланиями, Sergey Anohin.
--- wfido
* Origin: https://5034.ru/wfido (2:5034/10.1)
|
