hi all
На некоторую базейку напрыгнуло 80 молотилок, имитирующих OLTP-нагрузку.
В результате сейчас:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
Version: 145, Active owner: 0, Length: 16777216, Used: 2972632
Flags: 0x0001
Enqs: 1131159, Converts: 45815, Rejects: 45293, Blocks: 594733
Deadlock scans: 0, Deadlocks: 0, Scan interval: 10
Acquires: 3265464, Acquire blocks: 804356, Spin count: 0
Mutex wait: 24.6%
Hash slots: 22111, Hash lengths (min/avg/max): 0/ 0/ 4
Remove node: 0, Insert queue: 0, Insert prior: 0
Owners (81): forward: 189720, backward: 2965080
Free owners: *empty*
Free locks (19): forward: 195592, backward: 2893528
Free requests (898): forward: 2600624, backward: 2819800
Lock Ordering: Enabled
ФБ 2.5 работает в режиме SuperClassic'a, в системе 32 Гб ram. Конкурентов процессу ФБ нет.
top 1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
[root@oel64 14:50:46 fb25]$ top -u firebird
top - 14:52:49 up 4 days, 13 min, 2 users, load average: 1.63, 1.57, 0.94
Tasks: 169 total, 1 running, 168 sleeping, 0 stopped, 0 zombie
Cpu0 : 13.1%us, 2.0%sy, 0.0%ni, 84.9%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 10.0%us, 2.3%sy, 0.0%ni, 87.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 62.8%us, 2.0%sy, 0.0%ni, 35.2%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 : 16.1%us, 2.0%sy, 0.0%ni, 81.9%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu4 : 14.1%us, 2.0%sy, 0.0%ni, 83.9%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu5 : 21.9%us, 2.4%sy, 0.0%ni, 75.8%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu6 : 14.3%us, 2.0%sy, 0.0%ni, 83.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu7 : 7.4%us, 1.3%sy, 0.0%ni, 91.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu8 : 3.7%us, 2.0%sy, 0.0%ni, 94.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu9 : 6.0%us, 1.7%sy, 0.0%ni, 92.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu10 : 4.0%us, 1.7%sy, 0.0%ni, 94.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu11 : 5.4%us, 6.4%sy, 0.0%ni, 87.8%id, 0.0%wa, 0.0%hi, 0.3%si, 0.0%st
Mem: 32987988k total, 24772912k used, 8215076k free, 452844k buffers
Swap: 32767996k total, 0k used, 32767996k free, 18689396k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
14365 firebird 20 0 16.0g 2.0g 10m S 208.1 6.4 1930:16 /opt/fb25sc/bin/fb_smp_server
Изменённые параметры конфига:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
$ grep "^[^#;]" firebird.conf
ExternalFileAccess = Restrict /var/db/fb25
TempDirectories = /dev/shm;/tmp
MaxUserTraceLogSize = 9999
DefaultDbCachePages = 8192
FileSystemCacheThreshold = 1000000
TempBlockSize = 104857600
TempCacheLimit = 1073741824
BugcheckAbort = 1
RemoteServicePort = 3252
LockMemSize = 16777216
LockHashSlots = 22111
База в FW = OFF.
Вопрос, соб-сно, простой как 3 коп: за счет чего можно уменьшить процент ожиданий на мьютексе ? |
