[Progress Communities] [Progress OpenEdge ABL] Forum Post: Centos 7.7, OpenEdge 11.7.2, VMWare 6.5 - slow networking???

[arturikk]

Hello Everyone! So, we have problem on our PRODUCTION environment. If you know something about this article, please help us to resolve this problem. One host (1xCPU Xeon E5-2683, 32 logical processors), two virtual machines. I just want to mention, that latest VMWare tools are installed, we don't use selinux iptables. No switches or firewall between these VMs!!! As I know, same problem is with latest Debian kernel. - VMWare 6.5 - Centos 6.9 and Centos 7.7, clean, wihtout patches and software, we took Centos minimal installation. VM1 (Centos 6.9) - one processor - RAM 2Gb - SSD disk RAID10 VM2 (Centos 7.7) - one processor - RAM 2Gb - SSD disk RAID10 Both OpenEdge 11.7.2 installed, this is release what we use on PRODUCTION environment. So, lets start with a tests: VM1 run iperf3 -s VM2 run iperf3 -c "VM1.domain" We have speed about 15Gb/s another test VM1 run iperf3 -c "VM2.domain" VM2 run iperf3 -s we have speed about 30Gb/s. Also we tested speed from localhost to localhost on Centos6 and Centos7. Same result, Centos6 is about two times faster than Centos7. -------------------------------------------- So same situation with Progress. We have about performance degradation with FOR EACH from Centos 7 to Centos 6. I want to also mention, that we have another DB vendors, no others shows any problems. Data from Progress : -------------------------------------------- DB Start script on both servers: /usr/dlc/bin/proserve /xxx/xxx -n 65 -ServerType 4GL -S 2222 -Mpb 5 -Mn 9 -Mi 1 -Ma 7 -aiarcdir /xxx/xxx/xxx -aiarcinterval 3600 -aistall /usr/dlc/bin/proserve /xxx/xxx-m3 -ServerType SQL -S 3333 -minport 3334 -maxport 3400 -Mpb 3 -Mi 1 -Ma 6 $DLC/bin/proapw /xxx/xxx $DLC/bin/probiw /xxx/xxx $DLC/bin/proaiw /xxx/xxx -------------------------------------------- Startup.pf -cpinternal KOI8-RL -cpstream KOI8-RL -cpcoll RUSLAT -cpcase BASIC -d dmy -numsep 44 -numdec 46 -Mm 16384 -maxport 3000 -------------------------------------------- So, here are test results on different Centos servers. Done with database sports2000 Centos 7 CONNECT command 1155ms Run NO-LOCK NO-PREFETCH SHARE-LOCK 1 88 7137 26541 2 102 6281 26013 3 87 7259 25303 4 82 7381 25318 5 88 6883 27381 6 84 6472 27532 7 79 6101 25775 8 87 5960 27045 9 82 6029 25494 10 111 4909 26087 11 80 6284 26263 AVE 88.2 6426.9 26250.2 Centos 6 CONNECT 15ms Run NO-LOCK NO-PREFETCH SHARE-LOCK 1 79 1353 1736 2 75 1364 1624 3 80 1368 2049 4 80 1328 1729 5 93 1508 1683 6 79 1368 2015 7 99 1550 1730 8 73 3714 1924 9 93 1643 1668 10 90 1426 1679 11 87 1392 1809 AVE 84.4 1637.6 1786.0 SCRIPT: DEFINE TEMP-TABLE ttResult NO-UNDO FIELD uRun AS INTEGER FORMAT ">9" FIELD uTime AS INTEGER FORMAT ">>>>>>>>9" FIELD uCount AS INTEGER FORMAT ">>>>>>>>>9" INDEX i-run uRun. DEFINE VARIABLE tTime AS INTEGER NO-UNDO. DEFINE VARIABLE i AS INTEGER NO-UNDO. DO i = 1 TO 11: ETIME(TRUE). FOR EACH OrderLine NO-LOCK /*NO-PREFETCH*/: ACCUMULATE "rec":U (COUNT). END. tTime = ETIME. CREATE ttResult. ASSIGN ttResult.uRun = i ttResult.uTime = tTime ttResult.uCount = ACCUM COUNT ("rec":U). END. FOR EACH ttResult NO-LOCK: DISPLAY ttResult. END. If you know something about this, please let me know!

Continue reading...