Welcome to Centmin Mod Community
Become a Member

SkySilk Cloud Provider launches with AMD EPYC CPUs

Discussion in 'Virtual Private Server (VPS) hosting' started by eva2000, Sep 8, 2018.

  1. eva2000

    eva2000 Administrator Staff Member

    40,625
    9,017
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +13,884
    Local Time:
    6:50 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    More AMD EPYC server action with SkySilk Cloud hosting provider launching with AMD EPYC processors - AMD EPYC 7601 with 2.7Ghz base cpu clock and 3.2Ghz Turbo Boost. They also seem to offer free 3Gbps DDOS mitigation protection too. SkySilk Launches As Linux-Powered Cloud Provider, Offers AMD EPYC Instances - Phoronix. Interesting to see as only other AMD EPYC cloud provider I know with hourly billing is Packet.net but they are doing full bare metal dedicated hourly cloud billing.

    My referral link here

    Doesn't seem to be KVM based but LXC container based via Proxmox
    skysilk-pricing-vps.png

    My fav location, Los Angeles data center for AMD EPYC

    skysilk-pricing-vps-amd-epyc-01.png
    skysilk-pricing-vps-amd-epyc-02.png
     
    Last edited: Sep 8, 2018
  2. eva2000

    eva2000 Administrator Staff Member

    40,625
    9,017
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +13,884
    Local Time:
    6:50 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    Official blog post NEW! | SkySilk is LIVE! Introducing a New Cloud VPS Hosting Platform

    My referral link here ;)
     
    Last edited: Sep 8, 2018
  3. eva2000

    eva2000 Administrator Staff Member

    40,625
    9,017
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +13,884
    Local Time:
    6:50 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    Tried SkySilk Basic Medium plan $20/hr
    • Server seems to a LENOVO ThinkServer RD640 model
    • You get a Intel Xeon E5-2680v1 Sandy Bridge cpu LXC container VPS which are clocked at 2.70Ghz base and 3.50Ghz Turbo Boost. Though SkySilk Basic Medium plan shows clocked at rest at ~3.1Ghz.
    • They are using LXC and not LXD containers
    • Defaults to CentOS 7.3 within LXC container and unfortunately very slow for 4 cpu core VPS (see end of post sar stats output). Probably the slowest 4 cpu VPS time I have seen for Centmin Mod 123.09beta01 install at 52+ minutes ! You can compare that to other Centmin Mod 123.09beta01 install times posted here.
    • I tried 2 installs and both times seems SSH disconnects near the end of Centmin Mod 123.09beta01 install routine. So need to install via screen so that SSH disconnections don't affect the install and you can re-attach screen session when SSH disconnects.
    • Default CentOS 7 image comes with EPEL yum repo already installed
    • sysbench benchmarks posted below show very slow disk I/O performance. sysbench file i/o for single thread was sequential read = 11.09MB/s with avg 0.35ms latency, sequential write = 1.30MB/s with average 1.32ms latency, random read = 6.95MB/s with average 0.56ms latency, and random write = 1.12MB/s with average 1.55ms latency and sysbench file fsyncs latency response time was very high with average 9.11 ms, max 25.93ms and 99th percentile at 16.71ms
    • Sar stats reported below for cpu load during Centmin Mod install are very high up to 16.29 cpu load average over 1 minute interval ! Seems for LXC container based VPSes they report cpu load of the host node itself and not the VPS so 16.29 load average is on the VPS host node that is being divided into LXC container guest VPSes.
    • Pure-ftpd failed to install
    skysilk-basic-medium-price-01.png

    Before Centmin Mod 123.09beta01 install

    Seems to be using Quadranet's network
    Code (Text):
    curl -s https://ipinfo.io/64.52.xxx.xxx
    {
      "ip": "64.52.xxx.xxx",
      "hostname": "64.52.xxx.xxx.static.skysilk.com",
      "city": "",
      "region": "",
      "country": "US",
      "loc": "37.7510,-97.8220",
      "org": "AS8100 QuadraNet, Inc"
    }
    

    System seems to be a Lenovo branded server
    Code (Text):
    System Information
      Operating System              Linux 4.15.17-3-pve x86_64
      Model                         LENOVO ThinkServer RD640
      Motherboard                   LENOVO ThinkServer RD640
      Memory                        157 GB
      BIOS                          LENOVO A1TSE6A
    

    Like OpenVZ, LXC containers use the host node's Linux Kernel which seems to be 4.15 based
    Code (Text):
    uname -r
    4.15.17-3-pve
    

    Code (Text):
    lscpu
    Architecture:          x86_64
    CPU op-mode(s):        32-bit, 64-bit
    Byte Order:            Little Endian
    CPU(s):                32
    On-line CPU(s) list:   0-31
    Thread(s) per core:    2
    Core(s) per socket:    8
    Socket(s):             2
    NUMA node(s):          2
    Vendor ID:             GenuineIntel
    CPU family:            6
    Model:                 45
    Model name:            Intel(R) Xeon(R) CPU E5-2680 0 @ 2.70GHz
    Stepping:              7
    CPU MHz:               3251.603
    BogoMIPS:              5387.00
    Virtualization:        VT-x
    L1d cache:             32K
    L1i cache:             32K
    L2 cache:              256K
    L3 cache:              20480K
    NUMA node0 CPU(s):     0-7,16-23
    NUMA node1 CPU(s):     8-15,24-31
    

    Code (Text):
    free -ml
                  total        used        free      shared  buff/cache   available
    Mem:          12000          46       11937       11403          16       11953
    Low:          12000          62       11937
    High:             0           0           0
    Swap:          1023           0        1023
    

    Code (Text):
    df -hT
    Filesystem     Type   Size  Used Avail Use% Mounted on
    /dev/rbd163    ext4   196G  611M  186G   1% /
    none           tmpfs  492K     0  492K   0% /dev
    tmpfs          tmpfs   79G     0   79G   0% /dev/shm
    tmpfs          tmpfs   79G  8.1M   79G   1% /run
    tmpfs          tmpfs   79G     0   79G   0% /sys/fs/cgroup
    tmpfs          tmpfs  1.2G     0  1.2G   0% /run/user/0
    

    Code (Text):
    cat /etc/redhat-release
    CentOS Linux release 7.3.1611 (Core)
    

    Code (Text):
    yum history list
    Loaded plugins: fastestmirror
    Repodata is over 2 weeks old. Install yum-cron? Or run: yum makecache fast
    ID     | Login user               | Date and time    | Action(s)      | Altered
    -------------------------------------------------------------------------------
         7 | System <unset>           | 2017-09-02 00:24 | Install        |    1
         6 | System <unset>           | 2017-09-02 00:23 | Install        |    1
         5 | System <unset>           | 2017-09-02 00:21 | Install        |   20
         4 | System <unset>           | 2017-09-02 00:20 | Install        |    1
         3 | System <unset>           | 2017-09-02 00:19 | Update         |   17
         2 | System <unset>           | 2017-05-04 02:37 | Erase          |    1 EE
         1 | 1000                     | 2017-05-04 02:36 | Install        |  157
    history list
    


    Centmin Mod 123.09beta01 install
    Code (Text):
    yum -y update; curl -O https://centminmod.com/betainstaller.sh && chmod 0700 betainstaller.sh && bash betainstaller.sh
    

    Install times
    Code (Text):
    ---------------------------------------------------------------------------
    Total Curl Installer YUM or DNF Time: 327.0022 seconds
    Total YUM Time: 12.962132543 seconds
    Total YUM or DNF + Source Download Time: 114.1677
    Total Nginx First Time Install Time: 1121.6911
    Total PHP First Time Install Time: 1166.1443
    Download Zip From Github Time: 0.0000
    Total Time Other eg. source compiles: 407.2919
    Total Centmin Mod Install Time: 2809.2950
    ---------------------------------------------------------------------------
    Total Install Time (curl yum + cm install + zip download): 3136.2972 seconds
    ---------------------------------------------------------------------------
    4 Intel(R) Xeon(R) CPU E5-2680 0 @ 2.70GHz
    1 3103.955 1 3122.966 1 3135.987 1 3146.808
    ---------------------------------------------------------------------------
    

    Post install check list though pure-ftpd didn't install properly - no version output
    Code (Text):
    *************************************************
    * Post-Install Check List....
    *************************************************
    
    --------------------------------------------------------
    Check ccache Version:
    --------------------------------------------------------
    ccache version 3.4.3
    
    Copyright (C) 2002-2007 Andrew Tridgell
    Copyright (C) 2009-2018 Joel Rosdahl
    
    This program is free software; you can redistribute it and/or modify it under
    the terms of the GNU General Public License as published by the Free Software
    Foundation; either version 3 of the License, or (at your option) any later
    version.
    
    --------------------------------------------------------
    Check Nginx Version:
    --------------------------------------------------------
    nginx version: nginx/1.15.3 (070918-173243)
    built by gcc 7.3.1 20180303 (Red Hat 7.3.1-5) (GCC)
    built with OpenSSL 1.1.0i  14 Aug 2018
    TLS SNI support enabled
    configure arguments: --with-ld-opt='-Wl,-E -L/usr/local/zlib-cf/lib -L/usr/local/lib -ljemalloc -Wl,-z,relro -Wl,-rpath,/usr/local/zlib-cf/lib:/usr/local/lib' --with-cc-opt='-I/usr/local/zlib-cf/include -I/usr/local/include -m64 -march=native -g -O3 -fstack-protector-strong -flto -fuse-ld=gold --param=ssp-buffer-size=4 -Wformat -Werror=format-security -Wimplicit-fallthrough=0 -fcode-hoisting -Wp,-D_FORTIFY_SOURCE=2 -gsplit-dwarf' --sbin-path=/usr/local/sbin/nginx --conf-path=/usr/local/nginx/conf/nginx.conf --build=070918-173243 --with-compat --with-http_stub_status_module --with-http_secure_link_module --with-libatomic --with-http_gzip_static_module --with-http_sub_module --with-http_addition_module --with-http_image_filter_module=dynamic --with-http_geoip_module --with-stream_geoip_module --with-stream_realip_module --with-stream_ssl_preread_module --with-threads --with-stream=dynamic --with-stream_ssl_module --with-http_realip_module --add-dynamic-module=../ngx-fancyindex-0.4.2 --add-module=../ngx_cache_purge-2.4.2 --add-dynamic-module=../ngx_devel_kit-0.3.0 --add-dynamic-module=../set-misc-nginx-module-0.32 --add-dynamic-module=../echo-nginx-module-0.61 --add-module=../redis2-nginx-module-0.15 --add-module=../ngx_http_redis-0.3.7 --add-module=../memc-nginx-module-0.18 --add-module=../srcache-nginx-module-0.31 --add-dynamic-module=../headers-more-nginx-module-0.33 --with-pcre-jit --with-http_ssl_module --with-http_v2_module --with-openssl=../openssl-1.1.0i --with-openssl-opt='enable-ec_nistp_64_gcc_128'
    
    --------------------------------------------------------
    Check PHP-FPM Version:
    --------------------------------------------------------
    PHP 5.6.37 (cli) (built: Sep  7 2018 18:08:28)
    Copyright (c) 1997-2016 The PHP Group
    Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies
        with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2016, by Zend Technologies
    
    --------------------------------------------------------
    Check MariaDB installed RPM Versions:
    --------------------------------------------------------
    MariaDB-server-10.1.35-1.el7.centos.x86_64
    MariaDB-common-10.1.35-1.el7.centos.x86_64
    MariaDB-devel-10.1.35-1.el7.centos.x86_64
    MariaDB-shared-10.1.35-1.el7.centos.x86_64
    MariaDB-client-10.1.35-1.el7.centos.x86_64
    MariaDB-compat-10.1.35-1.el7.centos.x86_64
    
    --------------------------------------------------------
    Check Memcached Server Version:
    --------------------------------------------------------
    memcached 1.5.10
    
    --------------------------------------------------------
    Check CSF Firewall Version:
    --------------------------------------------------------
    csf: v12.06 (generic)
    
    --------------------------------------------------------
    Check Siege Benchmark Version:
    --------------------------------------------------------
    SIEGE 4.0.4
    
    Copyright (C) 2017 by Jeffrey Fulmer, et al.
    This is free software; see the source for copying conditions.
    There is NO warranty; not even for MERCHANTABILITY or FITNESS
    FOR A PARTICULAR PURPOSE.
    
    
    --------------------------------------------------------
    Check mysqlreport version:
    --------------------------------------------------------
    mysqlreport v3.5-maria11 Jul 4 2013
    
    --------------------------------------------------------
    Check pure-ftpd Version:
    --------------------------------------------------------
    
    --------------------------------------------------------
    Check YUM Repo List
    --------------------------------------------------------
    Loaded plugins: fastestmirror, priorities, versionlock
    Loading mirror speeds from cached hostfile
     * base: mirrors.oit.uci.edu
     * epel: mirrors.develooper.com
     * extras: mirror.sfo12.us.leaseweb.net
     * rpmforge: mirror.hmc.edu
     * updates: repos.lax.quadranet.com
    280 packages excluded due to repository priority protections
    repo id                 repo name                                    status
    base/7/x86_64           CentOS-7 - Base                              7,658+2,253
    centos-sclo-rh/x86_64   CentOS-7 - SCLo rh                              7,897+98
    centos-sclo-sclo/x86_64 CentOS-7 - SCLo sclo                                 773
    *epel/x86_64            Extra Packages for Enterprise Linux 7 - x86_  11,696+974
    extras/7/x86_64         CentOS-7 - Extras                                    402
    mariadb                 MariaDB                                             72+3
    rpmforge                RHEL 7 - RPMforge.net - dag                      137+108
    updates/7/x86_64        CentOS-7 - Updates                             1,084+249
    repolist: 29,719
    
    --------------------------------------------------------
    mytimes check:
    /usr/bin/mytimes
    --------------------------------------------------------
    Fri Sep  7 18:14:02 UTC 2018    [UTC]
    Sat Sep  8 04:14:02 AEST 2018   [Australia/Brisbane]
    Fri Sep  7 11:14:02 PDT 2018    [America/Los_Angeles]
    Fri Sep  7 13:14:02 CDT 2018    [America/Chicago]
    Fri Sep  7 14:14:02 EDT 2018    [America/New_York]
    Fri Sep  7 14:14:02 EDT 2018    [America/Montreal]
    Fri Sep  7 19:14:02 BST 2018    [Europe/London]
    Fri Sep  7 20:14:02 CEST 2018   [Europe/Berlin]
    Sat Sep  8 01:14:02 +07 2018    [Asia/Bangkok]
    Sat Sep  8 01:14:02 +07 2018    [Asia/Ho_Chi_Minh]
    Sat Sep  8 01:14:02 WIB 2018    [Asia/Jakarta]
    Sat Sep  8 02:14:02 +08 2018    [Asia/Kuala_Lumpur]
    Sat Sep  8 02:14:02 +08 2018    [Asia/Singapore]
    --------------------------------------------------------
    


    Unfortunately, using LXC containers instead of KVM VPS also means you don't get all the permissions like you would for KVM/Xen VPSes
    Code (Text):
    ./centmin.sh: line 2135: /proc/sys/vm/drop_caches: Read-only file system
    


    Sar stats for cpu load during Centmin Mod install are very high up to 16.29 cpu load average over 1 minute interval ! Seems for LXC container based VPSes they report cpu load of the host node itself and not the VPS so 16.29 load average is on the VPS host node that is being divided into LXC container guest VPSes.
    Code (Text):
    sar -q | sed -e "s|$(hostname)|hostname|g"
    Linux 4.15.17-3-pve (hostname)  09/07/18        _x86_64_        (32 CPU)
    
    17:18:44          LINUX RESTART
    
    17:18:56      runq-sz  plist-sz   ldavg-1   ldavg-5  ldavg-15   blocked
    17:19:00            3      6286      6.21      5.84      6.00         0
    17:23:32            1      6196      7.17      6.68      6.31         0
    17:23:34            4      6215      7.17      6.68      6.31         1
    17:24:10            6      6209      7.49      6.79      6.36         1
    17:24:12            2      6199      7.37      6.77      6.36         1
    17:25:01            6      6260      7.64      6.92      6.43         0
    17:25:42            3      6221      9.47      7.53      6.66         0
    17:25:48            9      6217      9.03      7.47      6.64         0
    17:26:53            5      6238      8.15      7.58      6.74         0
    17:27:00            5      6221      8.93      7.75      6.80         0
    17:27:01            4      6231      8.62      7.71      6.79         0
    17:27:15            5      6220      8.29      7.67      6.78         0
    Average:            4      6226      7.96      7.12      6.51         0
    
    17:27:16          LINUX RESTART
    
    17:27:18      runq-sz  plist-sz   ldavg-1   ldavg-5  ldavg-15   blocked
    17:27:18            3      6225      8.43      7.70      6.80         0
    17:27:20            1      6226      8.43      7.70      6.80         0
    Average:            2      6226      8.43      7.70      6.80         0
    
    17:27:34          LINUX RESTART
    
    17:27:42      runq-sz  plist-sz   ldavg-1   ldavg-5  ldavg-15   blocked
    17:27:43            1      6238      7.02      7.42      6.73         0
    17:28:01            7      6241      6.95      7.38      6.73         0
    17:29:01            5      6246      6.92      7.22      6.71         0
    17:30:01           15      6251      9.37      7.79      6.94         2
    17:31:01            6      6264      8.78      7.96      7.05         0
    17:32:01           11      6252      8.19      7.89      7.08         0
    17:32:12            5      6218      7.70      7.79      7.06         0
    17:32:39            3      6211      7.81      7.79      7.08         0
    17:33:01            9      6247      7.26      7.65      7.05         0
    17:34:01            6      6256      6.78      7.43      7.01         0
    17:35:01            8      6291      7.60      7.48      7.05         0
    17:36:01            3      6261      7.09      7.35      7.03         0
    17:37:01            5      6278      7.34      7.30      7.03         0
    17:38:01            4      6337      8.43      7.60      7.15         0
    17:39:02           10      6365      7.40      7.39      7.10         0
    17:40:01            6      6380      6.71      7.21      7.06         1
    17:41:01            3      6343      7.13      7.38      7.13         0
    17:42:01            4      6293      7.41      7.44      7.17         0
    17:43:01            4      6291      6.52      7.20      7.10         0
    17:44:01            5      6230      6.48      7.09      7.07         2
    17:44:30            2      6209      6.64      7.07      7.07         0
    17:45:01           17      6258      8.88      7.53      7.22         0
    17:46:01            4      6329     11.35      8.60      7.62         0
    17:47:01            5      6300      8.97      8.40      7.61         0
    17:47:39            3      6273      8.10      8.23      7.58         0
    17:47:40            3      6257      8.10      8.23      7.58         0
    17:48:01            4      6286      7.73      8.13      7.56         0
    17:49:01            3      6247      7.28      7.93      7.53         0
    17:50:01            9      6314      5.98      7.48      7.40         0
    17:50:23            2      6241      8.01      7.85      7.53         0
    17:50:29            6      6221      7.92      7.84      7.53         1
    17:51:01            5      6259      6.41      7.48      7.42         0
    17:52:01            4      6265      5.53      7.04      7.27         0
    17:53:01            4      6221      5.65      6.78      7.16         0
    17:54:01            4      6199      5.10      6.43      7.02         0
    17:54:26            3      6211      4.86      6.27      6.95         1
    17:55:02            9      6324      8.53      7.04      7.19         1
    17:56:01            3      6304     10.39      7.90      7.48         1
    17:57:01            6      6271      9.97      8.29      7.64         1
    17:58:01            8      6284      8.91      8.28      7.68         0
    17:59:01            5      6295     10.74      8.99      7.96         0
    18:00:01            5      6307     10.00      9.07      8.06         0
    18:01:01            4      6303     10.77      9.45      8.25         0
    18:02:01           14      6319      9.86      9.42      8.31         6
    18:03:01            8      6331     16.29     10.98      8.90         0
    18:04:01            3      6308     11.49     10.56      8.89         0
    18:05:01            9      6308      9.39     10.12      8.84         0
    18:06:01            6      6334      9.05      9.92      8.86         0
    18:07:01           16      6394      8.64      9.65      8.83         4
    18:08:01            9      6382      8.83      9.50      8.83         1
    18:09:01           18      6394      9.12      9.40      8.83         1
    18:09:23            9      6295      9.17      9.39      8.85         1
    18:09:37            2      6288      8.44      9.23      8.80         0
    18:10:01           14      6369      8.66      9.19      8.79         2
    18:11:02            8      6366      8.70      9.12      8.80         0
    18:11:54            4      6269      6.79      8.53      8.61         0
    18:12:01            5      6258      6.64      8.47      8.59         1
    18:12:25           10      6266      7.80      8.58      8.62         0
    18:12:26           10      6276      7.80      8.58      8.62         0
    18:12:36            3      6257      8.13      8.62      8.64         0
    18:12:38            4      6253      8.36      8.66      8.65         0
    18:12:39            2      6244      8.36      8.66      8.65         0
    18:13:01            7      6279      7.66      8.48      8.59         1
    18:13:08            3      6257      7.68      8.47      8.59         0
    18:13:11            5      6300      7.95      8.51      8.60         1
    18:13:15            5      6266      8.11      8.54      8.61         1
    18:13:22            4      6279      7.70      8.44      8.58         6
    18:14:01            7      6346      6.67      8.10      8.46         0
    18:14:05            3      6325      6.94      8.13      8.46         0
    18:15:01            7      6333      5.64      7.55      8.24         0
    18:20:01           12      6261      4.45      5.64      7.23         1
    18:25:01           11      6270      6.95      6.34      7.11         0
    18:30:01            9      6307      6.37      6.38      6.91         0
    Average:            6      6285      7.98      8.10      7.78         0
    

    Sar cpu utilisation though reports alot idle at times ?
    Code (Text):
    sar -p | sed -e "s|$(hostname)|hostname|g"
    Linux 4.15.17-3-pve (hostname)  09/07/18        _x86_64_        (32 CPU)
    
    17:18:44          LINUX RESTART
    
    17:18:56        CPU     %user     %nice   %system   %iowait    %steal     %idle
    17:19:00        all     20.27      0.00      5.99      1.92      0.00     71.83
    17:23:32        all     12.44      0.01      7.09      2.71      0.00     77.75
    17:23:34        all     16.16      0.00      4.68      0.70      0.00     78.45
    17:24:10        all     13.68      0.00      5.64      2.67      0.00     78.00
    17:24:12        all     16.15      0.00      4.66      1.09      0.00     78.11
    17:25:01        all     15.91      0.15      7.51      1.81      0.00     74.61
    17:25:42        all     79.41      0.00      6.89      0.07      0.00     13.63
    17:25:48        all      8.82      0.00      6.37      0.62      0.00     84.19
    17:26:53        all     11.71      0.17      9.66      0.92      0.00     77.54
    17:27:00        all     72.33      0.00     13.22      0.07      0.00     14.38
    17:27:01        all     14.75      0.00     15.41      0.33      0.00     69.51
    17:27:15        all     12.23      0.00      8.24      0.57      0.00     78.96
    Average:        all     19.20      0.04      7.45      2.03      0.00     71.28
    
    17:27:16          LINUX RESTART
    
    17:27:18        CPU     %user     %nice   %system   %iowait    %steal     %idle
    17:27:18        all     24.46      0.00      5.04      0.00      0.00     70.50
    17:27:20        all     16.82      0.00      6.36      1.67      0.00     75.15
    Average:        all     19.08      0.00      5.97      1.17      0.00     73.77
    
    17:27:34          LINUX RESTART
    
    17:27:42        CPU     %user     %nice   %system   %iowait    %steal     %idle
    17:27:43        all     72.58      0.00     12.25      0.00      0.00     15.17
    17:28:01        all      7.53      0.00      6.04      0.76      0.00     85.67
    17:29:01        all      8.38      0.00      5.03      0.97      0.00     85.63
    17:30:01        all     59.07      0.02     12.76      1.94      0.00     26.22
    17:31:01        all     31.05      0.00      8.90      0.84      0.00     59.21
    17:32:01        all     17.82      0.01      5.45      0.51      0.00     76.21
    17:32:12        all     30.50      0.00      4.23      0.86      0.00     64.40
    17:32:39        all     19.56      0.03      4.93      1.51      0.00     73.97
    17:33:01        all      6.10      0.00      4.24      0.72      0.00     88.95
    17:34:01        all      7.00      0.00      3.63      0.69      0.00     88.69
    17:35:01        all      7.67      0.16      3.77      0.94      0.00     87.46
    17:36:01        all      9.94      0.00      4.37      0.74      0.00     84.95
    17:37:01        all      7.95      0.01      4.00      0.91      0.00     87.13
    17:38:01        all      7.78      0.15      4.13      1.03      0.00     86.90
    17:39:02        all      7.20      0.00      4.02      1.18      0.00     87.60
    17:40:01        all      9.12      0.05      3.99      0.83      0.00     86.00
    17:41:01        all     14.06      0.17      5.08      0.90      0.00     79.79
    17:42:01        all     10.08      0.27      4.55      0.87      0.00     84.22
    17:43:01        all     10.75      0.14      4.08      1.16      0.00     83.87
    17:44:01        all      8.96      0.00      4.25      0.77      0.00     86.01
    17:44:30        all      8.58      0.00      5.30      0.83      0.00     85.28
    17:45:01        all     77.04      0.00     13.78      0.09      0.00      9.09
    17:46:01        all     71.33      0.00     16.02      0.08      0.00     12.56
    17:47:01        all     10.98      0.01      4.20      1.11      0.00     83.71
    17:47:39        all     25.26      0.00      4.02      0.55      0.00     70.18
    17:47:40        all     12.38      0.00     10.48      0.00      0.00     77.14
    17:48:01        all     11.75      0.02      5.61      1.04      0.00     81.57
    17:49:01        all     20.28      0.01      6.74      2.26      0.00     70.71
    17:50:01        all     17.99      0.19      7.13      1.70      0.00     72.99
    17:50:23        all     20.27      0.00      9.42      2.04      0.00     68.27
    17:50:29        all     24.52      0.00      4.74      0.89      0.00     69.85
    17:51:01        all      9.13      0.00      4.75      0.88      0.00     85.25
    17:52:01        all      8.07      0.11      4.06      0.97      0.00     86.78
    17:53:01        all      8.60      0.01      3.50      0.64      0.00     87.24
    17:54:01        all     12.66      0.00      7.58      0.74      0.00     79.02
    17:54:26        all     19.03      0.00     11.94      0.93      0.00     68.10
    17:55:02        all     43.09      0.00      7.68      0.46      0.00     48.76
    17:56:01        all     26.70      0.00      6.69      0.92      0.00     65.68
    17:57:01        all     14.81      0.01      7.09      0.92      0.00     77.16
    17:58:01        all     13.88      0.00      6.32      0.60      0.00     79.20
    17:59:01        all     12.97      0.00      6.55      0.63      0.00     79.85
    18:00:01        all     13.64      0.00      6.36      0.69      0.00     79.30
    18:01:01        all     13.85      0.00      6.61      0.63      0.00     78.91
    18:02:01        all     15.59      0.00      6.26      0.66      0.00     77.49
    18:03:01        all     22.45      0.15      6.26      0.70      0.00     70.45
    18:04:01        all     15.20      0.00      6.14      0.83      0.00     77.82
    18:05:01        all     13.19      0.02      6.28      1.24      0.00     79.29
    18:06:01        all     12.53      0.00      6.96      0.91      0.00     79.60
    18:07:01        all     16.19      0.00      6.63      0.83      0.00     76.34
    18:08:01        all     17.96      0.00      6.40      0.74      0.00     74.90
    18:09:01        all     22.15      0.00      6.27      1.01      0.00     70.56
    18:09:23        all     26.25      0.00     24.68      0.57      0.00     48.50
    18:09:37        all     12.35      0.00     20.40      0.53      0.00     66.72
    18:10:01        all     19.43      0.00      8.18      1.15      0.00     71.24
    18:11:02        all     32.62      0.00      8.58      1.06      0.00     57.74
    18:11:54        all     22.34      0.00      9.84      1.00      0.00     66.83
    18:12:01        all     24.05      0.00      8.67      0.79      0.00     66.49
    18:12:25        all     29.39      0.00     11.48      1.14      0.00     57.99
    18:12:26        all     45.87      0.00     15.18      0.33      0.00     38.61
    18:12:36        all     24.77      0.00     13.21      1.15      0.00     60.87
    18:12:38        all     68.09      0.00     12.65      0.56      0.00     18.70
    18:12:39        all     14.29      0.00     17.86      1.43      0.00     66.43
    18:13:01        all     18.31      0.13      8.27      1.16      0.00     72.13
    18:13:08        all     18.87      0.00      9.81      0.58      0.00     70.74
    18:13:11        all     56.30      0.00     13.02      0.21      0.00     30.46
    18:13:15        all     10.96      0.00      6.51      1.40      0.00     81.13
    18:13:22        all     14.71      0.00      9.86      1.37      0.00     74.06
    18:14:01        all     23.64      0.21      7.71      0.80      0.00     67.63
    18:14:05        all     16.16      0.00      6.09     15.94      0.00     61.81
    18:15:01        all      9.16      0.00      4.76      0.92      0.00     85.17
    18:20:01        all      9.84      0.01      4.42      1.76      0.00     83.98
    18:25:01        all     10.13      0.02      4.87      1.18      0.00     83.80
    18:30:01        all      9.58      0.06      5.25      1.26      0.00     83.85
    18:35:01        all     10.19      0.01      4.27      1.06      0.00     84.47
    Average:        all     15.81      0.03      6.06      1.05      0.00     77.04
    


    sysbench benchmarks

    cpu
    Code (Text):
    ./sysbench.sh cpu
    -------------------------------------------
    System Information
    -------------------------------------------
    
    4.15.17-3-pve
    
    CentOS Linux release 7.5.1804 (Core)
    
    Centmin Mod
    Architecture:          x86_64
    CPU op-mode(s):        32-bit, 64-bit
    Byte Order:            Little Endian
    CPU(s):                32
    On-line CPU(s) list:   0-31
    Thread(s) per core:    2
    Core(s) per socket:    8
    Socket(s):             2
    NUMA node(s):          2
    Vendor ID:             GenuineIntel
    CPU family:            6
    Model:                 45
    Model name:            Intel(R) Xeon(R) CPU E5-2680 0 @ 2.70GHz
    Stepping:              7
    CPU MHz:               2748.123
    CPU max MHz:           3500.0000
    CPU min MHz:           1200.0000
    BogoMIPS:              5387.00
    Virtualization:        VT-x
    L1d cache:             32K
    L1i cache:             32K
    L2 cache:              256K
    L3 cache:              20480K
    NUMA node0 CPU(s):     0-7,16-23
    NUMA node1 CPU(s):     8-15,24-31
    Flags:                 fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc cpuid aperfmperf pni pclmulqdq dtes64 monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr pdcm pcid dca sse4_1 sse4_2 x2apic popcnt tsc_deadline_timer aes xsave avx lahf_lm epb pti tpr_shadow vnmi flexpriority ept vpid xsaveopt ibpb ibrs stibp dtherm ida arat pln pts
    
    CPU Flags
     fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc cpuid aperfmperf pni pclmulqdq dtes64 monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr pdcm pcid dca sse4_1 sse4_2 x2apic popcnt tsc_deadline_timer aes xsave avx lahf_lm epb pti tpr_shadow vnmi flexpriority ept vpid xsaveopt ibpb ibrs stibp dtherm ida arat pln pts
    
    CPU NODE SOCKET CORE L1d:L1i:L2:L3 ONLINE MAXMHZ    MINMHZ
    0   0    0      0    0:0:0:0       yes    3500.0000 1200.0000
    1   0    0      1    1:1:1:0       yes    3500.0000 1200.0000
    2   0    0      2    2:2:2:0       yes    3500.0000 1200.0000
    3   0    0      3    3:3:3:0       yes    3500.0000 1200.0000
    4   0    0      4    4:4:4:0       yes    3500.0000 1200.0000
    5   0    0      5    5:5:5:0       yes    3500.0000 1200.0000
    6   0    0      6    6:6:6:0       yes    3500.0000 1200.0000
    7   0    0      7    7:7:7:0       yes    3500.0000 1200.0000
    8   1    1      8    8:8:8:1       yes    3500.0000 1200.0000
    9   1    1      9    9:9:9:1       yes    3500.0000 1200.0000
    10  1    1      10   10:10:10:1    yes    3500.0000 1200.0000
    11  1    1      11   11:11:11:1    yes    3500.0000 1200.0000
    12  1    1      12   12:12:12:1    yes    3500.0000 1200.0000
    13  1    1      13   13:13:13:1    yes    3500.0000 1200.0000
    14  1    1      14   14:14:14:1    yes    3500.0000 1200.0000
    15  1    1      15   15:15:15:1    yes    3500.0000 1200.0000
    16  0    0      0    0:0:0:0       yes    3500.0000 1200.0000
    17  0    0      1    1:1:1:0       yes    3500.0000 1200.0000
    18  0    0      2    2:2:2:0       yes    3500.0000 1200.0000
    19  0    0      3    3:3:3:0       yes    3500.0000 1200.0000
    20  0    0      4    4:4:4:0       yes    3500.0000 1200.0000
    21  0    0      5    5:5:5:0       yes    3500.0000 1200.0000
    22  0    0      6    6:6:6:0       yes    3500.0000 1200.0000
    23  0    0      7    7:7:7:0       yes    3500.0000 1200.0000
    24  1    1      8    8:8:8:1       yes    3500.0000 1200.0000
    25  1    1      9    9:9:9:1       yes    3500.0000 1200.0000
    26  1    1      10   10:10:10:1    yes    3500.0000 1200.0000
    27  1    1      11   11:11:11:1    yes    3500.0000 1200.0000
    28  1    1      12   12:12:12:1    yes    3500.0000 1200.0000
    29  1    1      13   13:13:13:1    yes    3500.0000 1200.0000
    30  1    1      14   14:14:14:1    yes    3500.0000 1200.0000
    31  1    1      15   15:15:15:1    yes    3500.0000 1200.0000
    
                  total        used        free      shared  buff/cache   available
    Mem:          12000         670        7061       11494        4268       11329
    Low:          12000        4938        7061
    High:             0           0           0
    Swap:          1023           0        1023
    
    Filesystem      Size  Used Avail Use% Mounted on
    /dev/rbd163     196G  4.5G  182G   3% /
    none            492K     0  492K   0% /dev
    tmpfs            79G     0   79G   0% /dev/shm
    tmpfs            79G  8.2M   79G   1% /run
    tmpfs            79G     0   79G   0% /sys/fs/cgroup
    tmpfs           1.2G     0  1.2G   0% /run/user/0
    
    
    sysbench cpu --cpu-max-prime=20000 --threads=1 run
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    prime: 20000
    events/s: 326.44
    time: 10.0028s
    min: 2.72
    avg: 3.06
    max: 5.85
    95th: 3.36
    
    | cpu sysbench | threads: | events/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- |
    | 1.0.15 | 1 | 326.44 | 10.0028s | 2.72 | 3.06 | 5.85 | 3.36 |
    
    sysbench,threads,events/s,time,min,avg,max,95th
    1.0.15,1,326.44,10.0028s,2.72,3.06,5.85,3.36
    
    sysbench cpu --cpu-max-prime=20000 --threads=4 run
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 4
    prime: 20000
    events/s: 1056.22
    time: 10.0025s
    min: 3.25
    avg: 3.79
    max: 17.10
    95th: 4.03
    
    | cpu sysbench | threads: | events/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- |
    | 1.0.15 | 4 | 1056.22 | 10.0025s | 3.25 | 3.79 | 17.10 | 4.03 |
    
    sysbench,threads,events/s,time,min,avg,max,95th
    1.0.15,4,1056.22,10.0025s,3.25,3.79,17.10,4.03
    

    memory
    Code (Text):
    ./sysbench.sh mem
    
    sysbench memory --threads=1 --memory-block-size=1K --memory-scope=global --memory-total-size=1G --memory-oper=read run
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    block-size: 1KiB
    total-size: 1024MiB
    operation: read
    scope: global
    total-ops: 1048576 (5255629.13 per second)
    transferred (5132.45 MiB/sec)
    time: 0.1975s
    min: 0.00
    avg: 0.00
    max: 1.73
    95th: 0.00
    
    | memory sysbench | sysbench | threads: | block-size: | total-size: | operation: | total-ops: | transferred | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | memory | 1.0.15 | 1 | 1KiB | 1024MiB | read | 1048576 | 5132.45 | 0.1975s | 0.00 | 0.00 | 1.73 | 0.00 |
    
    sysbench,sysbench,threads,block-size,total-size,operation,total-ops,transferred,time,min,avg,max,95th
    memory,1.0.15,1,1KiB,1024MiB,read,1048576,5132.45,0.1975s,0.00,0.00,1.73,0.00
    
    sysbench memory --threads=4 --memory-block-size=1K --memory-scope=global --memory-total-size=1G --memory-oper=read run
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 4
    block-size: 1KiB
    total-size: 1024MiB
    operation: read
    scope: global
    total-ops: 1048576 (13022586.23 per second)
    transferred (12717.37 MiB/sec)
    time: 0.0786s
    min: 0.00
    avg: 0.00
    max: 1.17
    95th: 0.00
    
    | memory sysbench | sysbench | threads: | block-size: | total-size: | operation: | total-ops: | transferred | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | memory | 1.0.15 | 4 | 1KiB | 1024MiB | read | 1048576 | 12717.37 | 0.0786s | 0.00 | 0.00 | 1.17 | 0.00 |
    
    sysbench,sysbench,threads,block-size,total-size,operation,total-ops,transferred,time,min,avg,max,95th
    memory,1.0.15,4,1KiB,1024MiB,read,1048576,12717.37,0.0786s,0.00,0.00,1.17,0.00
    

    file I/O
    Code (Text):
    ./sysbench.sh file
    
    sysbench fileio prepare
    sysbench fileio --file-total-size=2048M --file-test-mode=seqrd prepare
    
    sysbench fileio --threads=1 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=seqrd --time=10 --events=0 run
    raw log saved: /home/sysbench/sysbench-fileio-seqrd-threads-1-raw.log
    
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    Block-size 4KiB
    Using synchronous I/O mode
    Doing sequential read test
    reads/s: 2837.79
    writes/s: 0.00
    fsyncs/s: 0.00
    read-MiB/s: 11.09
    written-MiB/s: 0.00
    time: 10.0004s
    min: 0.20
    avg: 0.35
    max: 158.60
    95th: 0.65
    
    | fileio sysbench | sysbench | threads: | Block-size | synchronous | sequential | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | fileio | 1.0.15 | 1 | 4KiB | I/O | read | 2837.79 | 0.00 | 0.00 | 11.09 | 0.00 | 10.0004s | 0.20 | 0.35 | 158.60 | 0.65 |
    
    sysbench,sysbench,threads,Block-size,synchronous,sequential,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th
    fileio,1.0.15,1,4KiB,I/O,read,2837.79,0.00,0.00,11.09,0.00,10.0004s,0.20,0.35,158.60,0.65
    
    
    sysbench fileio cleanup
    sysbench fileio --file-total-size=2048M cleanup
    
    sysbench fileio prepare
    sysbench fileio --file-total-size=2048M --file-test-mode=seqwr prepare
    
    sysbench fileio --threads=1 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=seqwr --time=10 --events=0 run
    raw log saved: /home/sysbench/sysbench-fileio-seqwr-threads-1-raw.log
    
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    Block-size 4KiB
    Using synchronous I/O mode
    Doing sequential write (creation) test
    reads/s: 0.00
    writes/s: 332.24
    fsyncs/s: 434.08
    read-MiB/s: 0.00
    written-MiB/s: 1.30
    time: 10.0242s
    min: 0.00
    avg: 1.32
    max: 19.28
    95th: 6.43
    
    | fileio sysbench | sysbench | threads: | Block-size | synchronous | sequential | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | fileio | 1.0.15 | 1 | 4KiB | I/O | write | 0.00 | 332.24 | 434.08 | 0.00 | 1.30 | 10.0242s | 0.00 | 1.32 | 19.28 | 6.43 |
    
    sysbench,sysbench,threads,Block-size,synchronous,sequential,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th
    fileio,1.0.15,1,4KiB,I/O,write,0.00,332.24,434.08,0.00,1.30,10.0242s,0.00,1.32,19.28,6.43
    
    
    sysbench fileio cleanup
    sysbench fileio --file-total-size=2048M cleanup
    
    sysbench fileio prepare
    sysbench fileio --file-total-size=2048M --file-test-mode=rndrd prepare
    
    sysbench fileio --threads=1 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=rndrd --time=10 --events=0 run
    raw log saved: /home/sysbench/sysbench-fileio-rndrd-threads-1-raw.log
    
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    Block-size 4KiB
    Read/Write ratio for combined random IO test: 1.50
    Using synchronous I/O mode
    Doing random read test
    reads/s: 1778.31
    writes/s: 0.00
    fsyncs/s: 0.00
    read-MiB/s: 6.95
    written-MiB/s: 0.00
    time: 10.0001s
    min: 0.21
    avg: 0.56
    max: 11.51
    95th: 0.75
    
    | fileio sysbench | sysbench | threads: | Block-size | synchronous | random | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | fileio | 1.0.15 | 1 | 4KiB | I/O | read | 1778.31 | 0.00 | 0.00 | 6.95 | 0.00 | 10.0001s | 0.21 | 0.56 | 11.51 | 0.75 |
    
    sysbench,sysbench,threads,Block-size,synchronous,random,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th
    fileio,1.0.15,1,4KiB,I/O,read,1778.31,0.00,0.00,6.95,0.00,10.0001s,0.21,0.56,11.51,0.75
    
    
    sysbench fileio cleanup
    sysbench fileio --file-total-size=2048M cleanup
    
    sysbench fileio prepare
    sysbench fileio --file-total-size=2048M --file-test-mode=rndwr prepare
    
    sysbench fileio --threads=1 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=rndwr --time=10 --events=0 run
    raw log saved: /home/sysbench/sysbench-fileio-rndwr-threads-1-raw.log
    
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    Block-size 4KiB
    Read/Write ratio for combined random IO test: 1.50
    Using synchronous I/O mode
    Doing random write test
    reads/s: 0.00
    writes/s: 286.06
    fsyncs/s: 370.89
    read-MiB/s: 0.00
    written-MiB/s: 1.12
    time: 10.0064s
    min: 0.00
    avg: 1.55
    max: 20.56
    95th: 4.57
    
    | fileio sysbench | sysbench | threads: | Block-size | synchronous | random | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | fileio | 1.0.15 | 1 | 4KiB | I/O | write | 0.00 | 286.06 | 370.89 | 0.00 | 1.12 | 10.0064s | 0.00 | 1.55 | 20.56 | 4.57 |
    
    sysbench,sysbench,threads,Block-size,synchronous,random,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th
    fileio,1.0.15,1,4KiB,I/O,write,0.00,286.06,370.89,0.00,1.12,10.0064s,0.00,1.55,20.56,4.57
    
    
    
    sysbench fileio cleanup
    sysbench fileio --file-total-size=2048M cleanup
    
    sysbench fileio prepare
    sysbench fileio --file-total-size=2048M --file-test-mode=seqrd prepare
    
    sysbench fileio --threads=4 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=seqrd --time=10 --events=0 run
    raw log saved: /home/sysbench/sysbench-fileio-seqrd-threads-4-raw.log
    
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 4
    Block-size 4KiB
    Using synchronous I/O mode
    Doing sequential read test
    reads/s: 8037.51
    writes/s: 0.00
    fsyncs/s: 0.00
    read-MiB/s: 31.40
    written-MiB/s: 0.00
    time: 10.0004s
    min: 0.23
    avg: 0.50
    max: 8.75
    95th: 0.80
    
    | fileio sysbench | sysbench | threads: | Block-size | synchronous | sequential | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | fileio | 1.0.15 | 4 | 4KiB | I/O | read | 8037.51 | 0.00 | 0.00 | 31.40 | 0.00 | 10.0004s | 0.23 | 0.50 | 8.75 | 0.80 |
    
    sysbench,sysbench,threads,Block-size,synchronous,sequential,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th
    fileio,1.0.15,4,4KiB,I/O,read,8037.51,0.00,0.00,31.40,0.00,10.0004s,0.23,0.50,8.75,0.80
    
    
    sysbench fileio cleanup
    sysbench fileio --file-total-size=2048M cleanup
    
    sysbench fileio prepare
    sysbench fileio --file-total-size=2048M --file-test-mode=seqwr prepare
    
    sysbench fileio --threads=4 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=seqwr --time=10 --events=0 run
    raw log saved: /home/sysbench/sysbench-fileio-seqwr-threads-4-raw.log
    
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 4
    Block-size 4KiB
    Using synchronous I/O mode
    Doing sequential write (creation) test
    reads/s: 0.00
    writes/s: 253.94
    fsyncs/s: 367.78
    read-MiB/s: 0.00
    written-MiB/s: 0.99
    time: 10.0914s
    min: 0.00
    avg: 6.99
    max: 127.47
    95th: 27.17
    
    | fileio sysbench | sysbench | threads: | Block-size | synchronous | sequential | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | fileio | 1.0.15 | 4 | 4KiB | I/O | write | 0.00 | 253.94 | 367.78 | 0.00 | 0.99 | 10.0914s | 0.00 | 6.99 | 127.47 | 27.17 |
    
    sysbench,sysbench,threads,Block-size,synchronous,sequential,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th
    fileio,1.0.15,4,4KiB,I/O,write,0.00,253.94,367.78,0.00,0.99,10.0914s,0.00,6.99,127.47,27.17
    
    
    sysbench fileio cleanup
    sysbench fileio --file-total-size=2048M cleanup
    
    sysbench fileio prepare
    sysbench fileio --file-total-size=2048M --file-test-mode=rndrd prepare
    
    sysbench fileio --threads=4 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=rndrd --time=10 --events=0 run
    raw log saved: /home/sysbench/sysbench-fileio-rndrd-threads-4-raw.log
    
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 4
    Block-size 4KiB
    Read/Write ratio for combined random IO test: 1.50
    Using synchronous I/O mode
    Doing random read test
    reads/s: 7143.74
    writes/s: 0.00
    fsyncs/s: 0.00
    read-MiB/s: 27.91
    written-MiB/s: 0.00
    time: 10.0004s
    min: 0.19
    avg: 0.56
    max: 68.24
    95th: 1.08
    
    | fileio sysbench | sysbench | threads: | Block-size | synchronous | random | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | fileio | 1.0.15 | 4 | 4KiB | I/O | read | 7143.74 | 0.00 | 0.00 | 27.91 | 0.00 | 10.0004s | 0.19 | 0.56 | 68.24 | 1.08 |
    
    sysbench,sysbench,threads,Block-size,synchronous,random,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th
    fileio,1.0.15,4,4KiB,I/O,read,7143.74,0.00,0.00,27.91,0.00,10.0004s,0.19,0.56,68.24,1.08
    
    
    sysbench fileio cleanup
    sysbench fileio --file-total-size=2048M cleanup
    
    sysbench fileio prepare
    sysbench fileio --file-total-size=2048M --file-test-mode=rndwr prepare
    
    sysbench fileio --threads=4 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=rndwr --time=10 --events=0 run
    raw log saved: /home/sysbench/sysbench-fileio-rndwr-threads-4-raw.log
    
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 4
    Block-size 4KiB
    Read/Write ratio for combined random IO test: 1.50
    Using synchronous I/O mode
    Doing random write test
    reads/s: 0.00
    writes/s: 999.52
    fsyncs/s: 1330.03
    read-MiB/s: 0.00
    written-MiB/s: 3.90
    time: 10.0070s
    min: 0.00
    avg: 1.75
    max: 148.42
    95th: 5.67
    
    | fileio sysbench | sysbench | threads: | Block-size | synchronous | random | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | fileio | 1.0.15 | 4 | 4KiB | I/O | write | 0.00 | 999.52 | 1330.03 | 0.00 | 3.90 | 10.0070s | 0.00 | 1.75 | 148.42 | 5.67 |
    
    sysbench,sysbench,threads,Block-size,synchronous,random,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th
    fileio,1.0.15,4,4KiB,I/O,write,0.00,999.52,1330.03,0.00,3.90,10.0070s,0.00,1.75,148.42,5.67
    
    
    sysbench fileio cleanup
    sysbench fileio --file-total-size=2048M cleanup
    
    | fileio sysbench | sysbench | threads: | Block-size | synchronous | sequential | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    |fileio | 1.0.15 | 1 | 4KiB | I/O | read | 2837.79 | 0.00 | 0.00 | 11.09 | 0.00 | 10.0004s | 0.20 | 0.35 | 158.60 | 0.65 |
    |fileio | 1.0.15 | 1 | 4KiB | I/O | write | 0.00 | 332.24 | 434.08 | 0.00 | 1.30 | 10.0242s | 0.00 | 1.32 | 19.28 | 6.43 |
    |fileio | 1.0.15 | 4 | 4KiB | I/O | read | 8037.51 | 0.00 | 0.00 | 31.40 | 0.00 | 10.0004s | 0.23 | 0.50 | 8.75 | 0.80 |
    |fileio | 1.0.15 | 4 | 4KiB | I/O | write | 0.00 | 253.94 | 367.78 | 0.00 | 0.99 | 10.0914s | 0.00 | 6.99 | 127.47 | 27.17 |
    
    | fileio sysbench | sysbench | threads: | Block-size | synchronous | random | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    |fileio | 1.0.15 | 1 | 4KiB | I/O | read | 1778.31 | 0.00 | 0.00 | 6.95 | 0.00 | 10.0001s | 0.21 | 0.56 | 11.51 | 0.75 |
    |fileio | 1.0.15 | 1 | 4KiB | I/O | write | 0.00 | 286.06 | 370.89 | 0.00 | 1.12 | 10.0064s | 0.00 | 1.55 | 20.56 | 4.57 |
    |fileio | 1.0.15 | 4 | 4KiB | I/O | read | 7143.74 | 0.00 | 0.00 | 27.91 | 0.00 | 10.0004s | 0.19 | 0.56 | 68.24 | 1.08 |
    |fileio | 1.0.15 | 4 | 4KiB | I/O | write | 0.00 | 999.52 | 1330.03 | 0.00 | 3.90 | 10.0070s | 0.00 | 1.75 | 148.42 | 5.67 |
    

    file fsync
    Code (Text):
    ./sysbench.sh file-fsync
    
    sysbench fileio fsync prepare
    sysbench fileio --time=30 --file-num=1 --file-extra-flags= --file-total-size=4096 --file-block-size=4096 --file-fsync-all=on --file-test-mode=rndwr --file-fsync-freq=0 --file-fsync-end=0 --threads=1 --percentile=99 prepare
    
    sysbench fileio --threads=1 --time=30 --file-num=1 --file-extra-flags= --file-total-size=4096 --file-block-size=4096 --file-fsync-all=on --file-test-mode=rndwr --file-fsync-freq=0 --file-fsync-end=0 --percentile=99 run
    raw log saved: /home/sysbench/sysbench-fileio-fsync-threads-1-raw.log
    
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    Block-size 4KiB
    Read/Write ratio for combined random IO test: 1.50
    Using synchronous I/O mode
    Doing random write test
    reads/s: 0.00
    writes/s: 109.69
    fsyncs/s: 109.69
    read-MiB/s: 0.00
    written-MiB/s: 0.43
    time: 30.0114s
    min: 3.97
    avg: 9.11
    max: 25.93
    99th: 16.71
    
    | fileio sysbench | sysbench | threads: | Block-size | synchronous | random | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 99th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | fileio | 1.0.15 | 1 | 4KiB | I/O | write | 0.00 | 109.69 | 109.69 | 0.00 | 0.43 | 30.0114s | 3.97 | 9.11 | 25.93 | 16.71 |
    
    sysbench,sysbench,threads,Block-size,synchronous,random,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,99th
    fileio,1.0.15,1,4KiB,I/O,write,0.00,109.69,109.69,0.00,0.43,30.0114s,3.97,9.11,25.93,16.71
    
    
    sysbench fileio cleanup
    sysbench fileio --file-num=1 --file-extra-flags= --file-total-size=4096 --file-block-size=4096 cleanup
    

    mysql OLTP
    Code (Text):
    ./sysbench.sh mysqloltpnew
    
    setup sbt database & user
    mysqladmin create database: sbt
    Grants for [email protected]
    GRANT USAGE ON *.* TO 'sbtest'@'localhost' IDENTIFIED BY PASSWORD '*E6A410EB4C0B2737A6FC7845D7727289E65F2C8E'
    GRANT ALL PRIVILEGES ON `sbt`.* TO 'sbtest'@'localhost'
    
    MySQL Buffers
    aria_pagecache_buffer_size           1073741824
    aria_sort_buffer_size                268435456
    bulk_insert_buffer_size              8388608
    innodb_buffer_pool_dump_at_shutdown  OFF
    innodb_buffer_pool_dump_now          OFF
    innodb_buffer_pool_dump_pct          100
    innodb_buffer_pool_filename          ib_buffer_pool
    innodb_buffer_pool_instances         1
    innodb_buffer_pool_load_abort        OFF
    innodb_buffer_pool_load_at_startup   OFF
    innodb_buffer_pool_load_now          OFF
    innodb_buffer_pool_populate          OFF
    innodb_buffer_pool_size              1073741824
    innodb_change_buffer_max_size        25
    innodb_change_buffering              all
    innodb_log_buffer_size               8388608
    innodb_sort_buffer_size              2097152
    join_buffer_size                     262144
    join_buffer_space_limit              2097152
    key_buffer_size                      402653184
    mrr_buffer_size                      262144
    myisam_sort_buffer_size              268435456
    net_buffer_length                    16384
    optimizer_switch                     index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off
    preload_buffer_size                  32768
    read_buffer_size                     262144
    read_rnd_buffer_size                 524288
    sort_buffer_size                     524288
    sql_buffer_result                    OFF
    
    MySQL Limits
    aria_pagecache_division_limit         100
    delayed_insert_limit                  100
    expensive_subquery_limit              100
    ft_query_expansion_limit              20
    innodb_ft_result_cache_limit          2000000000
    join_buffer_space_limit               2097152
    key_cache_division_limit              100
    log_slow_rate_limit                   1
    min_examined_row_limit                0
    open_files_limit                      524288
    optimizer_selectivity_sampling_limit  100
    query_cache_limit                     1048576
    relay_log_space_limit                 0
    sql_select_limit                      18446744073709551615
    thread_pool_stall_limit               500
    updatable_views_with_limit            YES
    
    MySQL Maxes
    aria_max_sort_file_size           9223372036853727232
    extra_max_connections             1
    ft_max_word_len                   84
    group_concat_max_len              1024
    innodb_adaptive_max_sleep_delay   150000
    innodb_compression_pad_pct_max    50
    innodb_file_format_max            Antelope
    innodb_ft_max_token_size          84
    innodb_io_capacity_max            1400
    innodb_max_bitmap_file_size       104857600
    innodb_max_changed_pages          1000000
    innodb_max_dirty_pages_pct        75.000000
    innodb_max_dirty_pages_pct_lwm    0.001000
    innodb_max_purge_lag              0
    innodb_max_purge_lag_delay        0
    innodb_online_alter_log_max_size  134217728
    max_allowed_packet                134217728
    max_binlog_cache_size             18446744073709547520
    max_binlog_size                   1073741824
    max_binlog_stmt_cache_size        18446744073709547520
    max_connect_errors                100000
    max_connections                   750
    max_delayed_threads               20
    max_digest_length                 1024
    max_error_count                   64
    max_heap_table_size               536870912
    max_insert_delayed_threads        20
    max_join_size                     18446744073709551615
    max_length_for_sort_data          1024
    max_long_data_size                134217728
    max_prepared_stmt_count           16382
    max_relay_log_size                1073741824
    max_seeks_for_key                 4294967295
    max_session_mem_used              9223372036854775807
    max_sort_length                   1024
    max_sp_recursion_depth            0
    max_statement_time                0.000000
    max_tmp_tables                    32
    max_user_connections              0
    max_write_lock_count              4294967295
    myisam_max_sort_file_size         2147483648
    slave_max_allowed_packet          1073741824
    slave_parallel_max_queued         131072
    thread_pool_max_threads           1000
    wsrep_max_ws_rows                 0
    wsrep_max_ws_size                 2147483647
    
    MySQL Concurrency
    concurrent_insert           ALWAYS
    innodb_commit_concurrency   0
    innodb_concurrency_tickets  5000
    innodb_thread_concurrency   0
    thread_concurrency          10
    
    MySQL Read/Write
    delay_key_write           ON
    innodb_disallow_writes    OFF
    innodb_doublewrite        ON
    innodb_use_atomic_writes  OFF
    max_write_lock_count      4294967295
    net_write_timeout         60
    wsrep_causal_reads        OFF
    wsrep_dirty_reads         OFF
    
    MySQL Threads
    aria_repair_threads                      1
    binlog_optimize_thread_scheduling        ON
    debug_no_thread_alarm                    OFF
    innodb_encryption_threads                0
    innodb_mtflush_threads                   8
    innodb_purge_threads                     2
    innodb_read_io_threads                   2
    innodb_thread_concurrency                0
    innodb_thread_sleep_delay                10000
    innodb_write_io_threads                  2
    max_delayed_threads                      20
    max_insert_delayed_threads               20
    myisam_repair_threads                    1
    performance_schema_max_thread_classes    50
    performance_schema_max_thread_instances  -1
    slave_domain_parallel_threads            0
    slave_parallel_threads                   0
    thread_cache_size                        256
    thread_concurrency                       10
    thread_handling                          one-thread-per-connection
    thread_pool_idle_timeout                 60
    thread_pool_max_threads                  1000
    thread_pool_oversubscribe                3
    thread_pool_size                         32
    thread_pool_stall_limit                  500
    thread_stack                             295936
    wsrep_slave_threads                      1
    
    MySQL Binlog
    binlog_annotate_row_events               OFF
    binlog_cache_size                        32768
    binlog_checksum                          NONE
    binlog_commit_wait_count                 0
    binlog_commit_wait_usec                  100000
    binlog_direct_non_transactional_updates  OFF
    binlog_format                            STATEMENT
    binlog_optimize_thread_scheduling        ON
    binlog_row_image                         FULL
    binlog_stmt_cache_size                   32768
    encrypt_binlog                           OFF
    gtid_binlog_pos
    gtid_binlog_state
    innodb_api_enable_binlog                 OFF
    innodb_locks_unsafe_for_binlog           OFF
    log_bin                                  OFF
    log_bin_basename
    log_bin_index
    log_bin_trust_function_creators          OFF
    max_binlog_cache_size                    18446744073709547520
    max_binlog_size                          1073741824
    max_binlog_stmt_cache_size               18446744073709547520
    sql_log_bin                              ON
    sync_binlog                              0
    wsrep_forced_binlog_format               NONE
    
    MySQL InnoDB
    ignore_builtin_innodb                        OFF
    innodb_adaptive_flushing                     ON
    innodb_adaptive_flushing_lwm                 10.000000
    innodb_adaptive_hash_index                   ON
    innodb_adaptive_hash_index_partitions        1
    innodb_adaptive_max_sleep_delay              150000
    innodb_additional_mem_pool_size              8388608
    innodb_api_bk_commit_interval                5
    innodb_api_disable_rowlock                   OFF
    innodb_api_enable_binlog                     OFF
    innodb_api_enable_mdl                        OFF
    innodb_api_trx_level                         0
    innodb_autoextend_increment                  64
    innodb_autoinc_lock_mode                     1
    innodb_background_scrub_data_check_interval  3600
    innodb_background_scrub_data_compressed      OFF
    innodb_background_scrub_data_interval        604800
    innodb_background_scrub_data_uncompressed    OFF
    innodb_buf_dump_status_frequency             0
    innodb_buffer_pool_dump_at_shutdown          OFF
    innodb_buffer_pool_dump_now                  OFF
    innodb_buffer_pool_dump_pct                  100
    innodb_buffer_pool_filename                  ib_buffer_pool
    innodb_buffer_pool_instances                 1
    innodb_buffer_pool_load_abort                OFF
    innodb_buffer_pool_load_at_startup           OFF
    innodb_buffer_pool_load_now                  OFF
    innodb_buffer_pool_populate                  OFF
    innodb_buffer_pool_size                      1073741824
    innodb_change_buffer_max_size                25
    innodb_change_buffering                      all
    innodb_checksum_algorithm                    INNODB
    innodb_checksums                             ON
    innodb_cleaner_lsn_age_factor                HIGH_CHECKPOINT
    innodb_cmp_per_index_enabled                 OFF
    innodb_commit_concurrency                    0
    innodb_compression_algorithm                 zlib
    innodb_compression_failure_threshold_pct     5
    innodb_compression_level                     6
    innodb_compression_pad_pct_max               50
    innodb_concurrency_tickets                   5000
    innodb_corrupt_table_action                  assert
    innodb_data_file_path                        ibdata1:10M:autoextend
    innodb_data_home_dir
    innodb_default_encryption_key_id             1
    innodb_default_row_format                    dynamic
    innodb_defragment                            ON
    innodb_defragment_fill_factor                0.900000
    innodb_defragment_fill_factor_n_recs         20
    innodb_defragment_frequency                  40
    innodb_defragment_n_pages                    7
    innodb_defragment_stats_accuracy             0
    innodb_disable_sort_file_cache               OFF
    innodb_disallow_writes                       OFF
    innodb_doublewrite                           ON
    innodb_empty_free_list_algorithm             BACKOFF
    innodb_encrypt_log                           OFF
    innodb_encrypt_tables                        OFF
    innodb_encryption_rotate_key_age             1
    innodb_encryption_rotation_iops              100
    innodb_encryption_threads                    0
    innodb_fake_changes                          OFF
    innodb_fast_shutdown                         1
    innodb_fatal_semaphore_wait_threshold        600
    innodb_file_format                           Barracuda
    innodb_file_format_check                     ON
    innodb_file_format_max                       Antelope
    innodb_file_per_table                        ON
    innodb_flush_log_at_timeout                  1
    innodb_flush_log_at_trx_commit               2
    innodb_flush_method                          O_DIRECT
    innodb_flush_neighbors                       0
    innodb_flushing_avg_loops                    30
    innodb_force_load_corrupted                  OFF
    innodb_force_primary_key                     OFF
    innodb_force_recovery                        0
    innodb_foreground_preflush                   EXPONENTIAL_BACKOFF
    innodb_ft_aux_table
    innodb_ft_cache_size                         8000000
    innodb_ft_enable_diag_print                  OFF
    innodb_ft_enable_stopword                    ON
    innodb_ft_max_token_size                     84
    innodb_ft_min_token_size                     3
    innodb_ft_num_word_optimize                  2000
    innodb_ft_result_cache_limit                 2000000000
    innodb_ft_server_stopword_table
    innodb_ft_sort_pll_degree                    2
    innodb_ft_total_cache_size                   640000000
    innodb_ft_user_stopword_table
    innodb_idle_flush_pct                        100
    innodb_immediate_scrub_data_uncompressed     OFF
    innodb_instrument_semaphores                 OFF
    innodb_io_capacity                           700
    innodb_io_capacity_max                       1400
    innodb_kill_idle_transaction                 0
    innodb_large_prefix                          ON
    innodb_lock_schedule_algorithm               fcfs
    innodb_lock_wait_timeout                     50
    innodb_locking_fake_changes                  ON
    innodb_locks_unsafe_for_binlog               OFF
    innodb_log_arch_dir                          ./
    innodb_log_arch_expire_sec                   0
    innodb_log_archive                           OFF
    innodb_log_block_size                        512
    innodb_log_buffer_size                       8388608
    innodb_log_checksum_algorithm                INNODB
    innodb_log_compressed_pages                  ON
    innodb_log_file_size                         402653184
    innodb_log_files_in_group                    2
    innodb_log_group_home_dir                    ./
    innodb_lru_scan_depth                        1024
    innodb_max_bitmap_file_size                  104857600
    innodb_max_changed_pages                     1000000
    innodb_max_dirty_pages_pct                   75.000000
    innodb_max_dirty_pages_pct_lwm               0.001000
    innodb_max_purge_lag                         0
    innodb_max_purge_lag_delay                   0
    innodb_mirrored_log_groups                   1
    innodb_monitor_disable
    innodb_monitor_enable
    innodb_monitor_reset
    innodb_monitor_reset_all
    innodb_mtflush_threads                       8
    innodb_old_blocks_pct                        37
    innodb_old_blocks_time                       1000
    innodb_online_alter_log_max_size             134217728
    innodb_open_files                            1000
    innodb_optimize_fulltext_only                OFF
    innodb_page_size                             16384
    innodb_prefix_index_cluster_optimization     OFF
    innodb_print_all_deadlocks                   OFF
    innodb_print_lock_wait_timeout_info          OFF
    innodb_purge_batch_size                      300
    innodb_purge_threads                         2
    innodb_random_read_ahead                     OFF
    innodb_read_ahead_threshold                  56
    innodb_read_io_threads                       2
    innodb_read_only                             OFF
    innodb_replication_delay                     0
    innodb_rollback_on_timeout                   OFF
    innodb_rollback_segments                     128
    innodb_sched_priority_cleaner                19
    innodb_scrub_log                             OFF
    innodb_scrub_log_speed                       256
    innodb_show_locks_held                       10
    innodb_show_verbose_locks                    0
    innodb_simulate_comp_failures                0
    innodb_sort_buffer_size                      2097152
    innodb_spin_wait_delay                       6
    innodb_stats_auto_recalc                     ON
    innodb_stats_include_delete_marked           OFF
    innodb_stats_method                          nulls_equal
    innodb_stats_modified_counter                0
    innodb_stats_on_metadata                     OFF
    innodb_stats_persistent                      ON
    innodb_stats_persistent_sample_pages         20
    innodb_stats_sample_pages                    8
    innodb_stats_traditional                     ON
    innodb_stats_transient_sample_pages          8
    innodb_status_output                         OFF
    innodb_status_output_locks                   OFF
    innodb_strict_mode                           OFF
    innodb_support_xa                            ON
    innodb_sync_array_size                       1
    innodb_sync_spin_loops                       30
    innodb_table_locks                           ON
    innodb_thread_concurrency                    0
    innodb_thread_sleep_delay                    10000
    innodb_tmpdir
    innodb_track_changed_pages                   OFF
    innodb_undo_directory                        .
    innodb_undo_logs                             128
    innodb_undo_tablespaces                      0
    innodb_use_atomic_writes                     OFF
    innodb_use_fallocate                         OFF
    innodb_use_global_flush_log_at_trx_commit    ON
    innodb_use_mtflush                           OFF
    innodb_use_native_aio                        ON
    innodb_use_stacktrace                        OFF
    innodb_use_sys_malloc                        ON
    innodb_use_trim                              OFF
    innodb_version                               5.6.39-83.1
    innodb_write_io_threads                      2
    
    
    sysbench prepare database: sbt
    sysbench oltp_read_write.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-storage-engine=InnoDB --time=30 --threads=4 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql prepare
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    
    Initializing worker threads...
    
    Creating table 'sbtest1'...Creating table 'sbtest3'...
    
    Creating table 'sbtest4'...
    Creating table 'sbtest2'...
    Inserting 150000 records into 'sbtest3'
    Inserting 150000 records into 'sbtest1'
    Inserting 150000 records into 'sbtest4'
    Inserting 150000 records into 'sbtest2'
    Creating a secondary index on 'sbtest3'...
    Creating a secondary index on 'sbtest4'...
    Creating a secondary index on 'sbtest2'...
    Creating a secondary index on 'sbtest1'...
    Creating table 'sbtest7'...
    Creating table 'sbtest8'...
    Creating table 'sbtest6'...
    Creating table 'sbtest5'...
    Inserting 150000 records into 'sbtest6'
    Inserting 150000 records into 'sbtest8'
    Inserting 150000 records into 'sbtest5'
    Inserting 150000 records into 'sbtest7'
    Creating a secondary index on 'sbtest6'...
    Creating a secondary index on 'sbtest5'...
    Creating a secondary index on 'sbtest7'...
    Creating a secondary index on 'sbtest8'...
    
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    | Table Name  | Number of Rows | Storage Engine | Data Size | Index Size | Total   | ROW_FORMAT | TABLE_COLLATION |
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    | sbt.sbtest1 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Dynamic    | utf8_general_ci |
    | sbt.sbtest2 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8_general_ci |
    | sbt.sbtest3 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8_general_ci |
    | sbt.sbtest4 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8_general_ci |
    | sbt.sbtest5 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8_general_ci |
    | sbt.sbtest6 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8_general_ci |
    | sbt.sbtest7 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8_general_ci |
    | sbt.sbtest8 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8_general_ci |
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    
    sysbench mysql OLTP new benchmark:
    sysbench oltp_read_write.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-storage-engine=InnoDB --time=30 --threads=4 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql run
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    
    Running the test with following options:
    Number of threads: 4
    Report intermediate results every 1 second(s)
    Initializing random number generator from seed (1).
    
    
    Initializing worker threads...
    
    Threads started!
    
    [ 1s ] thds: 4 tps: 552.73 qps: 11091.57 (r/w/o: 7771.19/2210.93/1109.46) lat (ms,95%): 17.63 err/s: 0.00 reconn/s: 0.00
    [ 2s ] thds: 4 tps: 777.35 qps: 15585.96 (r/w/o: 10905.87/3125.40/1554.69) lat (ms,95%): 7.30 err/s: 0.00 reconn/s: 0.00
    [ 3s ] thds: 4 tps: 689.91 qps: 13767.14 (r/w/o: 9640.70/2746.63/1379.81) lat (ms,95%): 7.30 err/s: 0.00 reconn/s: 0.00
    [ 4s ] thds: 4 tps: 774.01 qps: 15473.10 (r/w/o: 10831.07/3094.02/1548.01) lat (ms,95%): 7.30 err/s: 0.00 reconn/s: 0.00
    [ 5s ] thds: 4 tps: 787.00 qps: 15750.00 (r/w/o: 11029.00/3147.00/1574.00) lat (ms,95%): 6.91 err/s: 0.00 reconn/s: 0.00
    [ 6s ] thds: 4 tps: 826.98 qps: 16545.66 (r/w/o: 11583.76/3307.93/1653.97) lat (ms,95%): 6.55 err/s: 0.00 reconn/s: 0.00
    [ 7s ] thds: 4 tps: 777.92 qps: 15555.39 (r/w/o: 10885.87/3113.68/1555.84) lat (ms,95%): 6.91 err/s: 0.00 reconn/s: 0.00
    [ 8s ] thds: 4 tps: 825.19 qps: 16493.77 (r/w/o: 11544.64/3298.75/1650.38) lat (ms,95%): 6.67 err/s: 0.00 reconn/s: 0.00
    [ 9s ] thds: 4 tps: 828.86 qps: 16583.18 (r/w/o: 11610.03/3315.44/1657.72) lat (ms,95%): 6.09 err/s: 0.00 reconn/s: 0.00
    [ 10s ] thds: 4 tps: 882.89 qps: 17666.72 (r/w/o: 12365.40/3535.54/1765.77) lat (ms,95%): 6.21 err/s: 0.00 reconn/s: 0.00
    [ 11s ] thds: 4 tps: 879.15 qps: 17581.97 (r/w/o: 12309.08/3514.59/1758.30) lat (ms,95%): 6.21 err/s: 0.00 reconn/s: 0.00
    [ 12s ] thds: 4 tps: 869.06 qps: 17374.29 (r/w/o: 12161.90/3474.26/1738.13) lat (ms,95%): 6.43 err/s: 0.00 reconn/s: 0.00
    [ 13s ] thds: 4 tps: 853.99 qps: 17074.71 (r/w/o: 11949.80/3416.94/1707.97) lat (ms,95%): 6.21 err/s: 0.00 reconn/s: 0.00
    [ 14s ] thds: 4 tps: 856.81 qps: 17142.13 (r/w/o: 12002.29/3426.23/1713.61) lat (ms,95%): 6.32 err/s: 0.00 reconn/s: 0.00
    [ 15s ] thds: 4 tps: 851.17 qps: 17006.49 (r/w/o: 11899.45/3404.70/1702.35) lat (ms,95%): 6.32 err/s: 0.00 reconn/s: 0.00
    [ 16s ] thds: 4 tps: 864.91 qps: 17310.24 (r/w/o: 12117.76/3462.65/1729.82) lat (ms,95%): 6.32 err/s: 0.00 reconn/s: 0.00
    [ 17s ] thds: 4 tps: 886.03 qps: 17712.58 (r/w/o: 12399.40/3541.12/1772.06) lat (ms,95%): 5.99 err/s: 0.00 reconn/s: 0.00
    [ 18s ] thds: 4 tps: 866.88 qps: 17353.62 (r/w/o: 12152.33/3467.52/1733.76) lat (ms,95%): 6.55 err/s: 0.00 reconn/s: 0.00
    [ 19s ] thds: 4 tps: 856.01 qps: 17106.12 (r/w/o: 11968.09/3426.02/1712.01) lat (ms,95%): 6.21 err/s: 0.00 reconn/s: 0.00
    [ 20s ] thds: 4 tps: 803.21 qps: 16102.23 (r/w/o: 11268.96/3226.85/1606.42) lat (ms,95%): 7.98 err/s: 0.00 reconn/s: 0.00
    [ 21s ] thds: 4 tps: 807.85 qps: 16128.95 (r/w/o: 11297.87/3215.39/1615.69) lat (ms,95%): 7.56 err/s: 0.00 reconn/s: 0.00
    [ 22s ] thds: 4 tps: 828.78 qps: 16572.58 (r/w/o: 11598.91/3316.12/1657.56) lat (ms,95%): 8.13 err/s: 0.00 reconn/s: 0.00
    [ 23s ] thds: 4 tps: 841.17 qps: 16816.47 (r/w/o: 11767.43/3366.70/1682.35) lat (ms,95%): 6.79 err/s: 0.00 reconn/s: 0.00
    [ 24s ] thds: 4 tps: 852.13 qps: 17046.67 (r/w/o: 11936.87/3405.53/1704.27) lat (ms,95%): 6.67 err/s: 0.00 reconn/s: 0.00
    [ 25s ] thds: 4 tps: 845.70 qps: 16900.01 (r/w/o: 11824.81/3384.80/1690.40) lat (ms,95%): 6.67 err/s: 0.00 reconn/s: 0.00
    [ 26s ] thds: 4 tps: 853.25 qps: 17078.04 (r/w/o: 11955.53/3415.01/1707.50) lat (ms,95%): 6.91 err/s: 0.00 reconn/s: 0.00
    [ 27s ] thds: 4 tps: 825.08 qps: 16506.67 (r/w/o: 11560.17/3296.33/1650.17) lat (ms,95%): 6.79 err/s: 0.00 reconn/s: 0.00
    [ 28s ] thds: 4 tps: 820.77 qps: 16410.39 (r/w/o: 11485.77/3283.08/1641.54) lat (ms,95%): 7.04 err/s: 0.00 reconn/s: 0.00
    [ 29s ] thds: 4 tps: 845.20 qps: 16902.05 (r/w/o: 11829.83/3381.81/1690.41) lat (ms,95%): 7.30 err/s: 0.00 reconn/s: 0.00
    [ 30s ] thds: 4 tps: 861.05 qps: 17218.91 (r/w/o: 12050.64/3446.18/1722.09) lat (ms,95%): 6.67 err/s: 0.00 reconn/s: 0.00
    SQL statistics:
        queries performed:
            read:                            345744
            write:                           98784
            other:                           49392
            total:                           493920
        transactions:                        24696  (822.96 per sec.)
        queries:                             493920 (16459.20 per sec.)
        ignored errors:                      0      (0.00 per sec.)
        reconnects:                          0      (0.00 per sec.)
    
    General statistics:
        total time:                          30.0071s
        total number of events:              24696
    
    Latency (ms):
             min:                                    2.12
             avg:                                    4.86
             max:                                  146.18
             95th percentile:                        6.79
             sum:                               119949.84
    
    Threads fairness:
        events (avg/stddev):           6174.0000/37.03
        execution time (avg/stddev):   29.9875/0.00
    
    
    sysbench mysql OLTP new summary:
    sysbench oltp_read_write.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-storage-engine=InnoDB --time=30 --threads=4 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql run
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 4
    read: 345744
    write: 98784
    other: 49392
    total: 493920
    transactions/s: 822.96
    queries/s: 16459.20
    time: 30.0071s
    min: 2.12
    avg: 4.86
    max: 146.18
    95th: 6.79
    
    | mysql sysbench | sysbench | threads: | read: | write: | other: | total: | transactions/s: | queries/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | oltp_read_write.lua | 1.0.15 | 4 | 345744 | 98784 | 49392 | 493920 | 822.96 | 16459.20 | 30.0071s | 2.12 | 4.86 | 146.18 | 6.79 |
    
    sysbench,sysbench,threads,read,write,other,total,transactions/s,queries/s,time,min,avg,max,95th
    oltp_read_write.lua,1.0.15,4,345744,98784,49392,493920,822.96,16459.20,30.0071s,2.12,4.86,146.18,6.79
    
    sysbench mysql cleanup database: sbt
    sysbench oltp_read_write.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-storage-engine=InnoDB --time=30 --threads=4 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql cleanup
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    
    Dropping table 'sbtest1'...
    Dropping table 'sbtest2'...
    Dropping table 'sbtest3'...
    Dropping table 'sbtest4'...
    Dropping table 'sbtest5'...
    Dropping table 'sbtest6'...
    Dropping table 'sbtest7'...
    Dropping table 'sbtest8'...
    
     
    Last edited: Sep 8, 2018
    style="display:inline-block;min-width:400px;max-width:970px;width:95%;height:90px" data-ad-client="ca-pub-6669518204467592" data-ad-slot="4024536743" data-ad-format="auto">
  4. eva2000

    eva2000 Administrator Staff Member

    40,625
    9,017
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +13,884
    Local Time:
    6:50 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    More info on LXD container usage instead of KVM/XEN/OpenVZ virtualisation what is the virtualization type offered with skysilk? : SkySilk Cloud Support posted 6 months ago
    Regarding high cpu load reported within LXC/LXC containers My server load is really high, is this normal? : SkySilk Cloud Support
    From SkySilk Benchmarks - New Linux cloud provider with cheap AMD EPYC instances : linux bandwidth is calculated and counted against inbound and outbound data transfers
     
    Last edited: Sep 8, 2018
  5. eva2000

    eva2000 Administrator Staff Member

    40,625
    9,017
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +13,884
    Local Time:
    6:50 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    next try their Standard Medium plan $40/month to compare with their Basic Medium plan $20/month

    skysilk-std-medium-price-01.png
    • Uses same Intel Xeon E5-2680v1 Sandy Bridge cpus and LXC container based CentOS 7.3 out of the box
    • PHP download/install routine failed 1st Centmin Mod 123.09beta01 attemp due to connection gone error. Though manually re-running command downloaded properly. So doing a 2nd install attempt
      Code (Text):
      US server detected
      Download php-5.6.37.tar.gz ...
      axel http://php.net/get/php-5.6.37.tar.gz/from/this/mirror -o php-5.6.37.tar.gz 
      Initializing download: http://php.net/get/php-5.6.37.tar.gz/from/this/mirror
      Connection gone while writing.
      
      Error: php-5.6.37.tar.gz download failed.
      
      ----------------------------------------------------------------------------------
      check Centmin Mod log for details at /root/centminlogs/
      Aborting script...
      ----------------------------------------------------------------------------------
      
    • sysbench file i/o for single thread was sequential read = 11.70MB/s with avg 0.33ms latency, sequential write = 1.00MB/s with average 1.74ms latency, random read = 6.79MB/s with average 0.57ms latency, and random write = 1.12MB/s with average 1.55ms latency and sysbench file fsyncs latency response time was very high with average 8.57 ms, max 135.72ms and 99th percentile at 17.01ms. This is compared to basic medium plan's sysbench file i/o for single thread was sequential read = 11.09MB/s with avg 0.35ms latency, sequential write = 1.30MB/s with average 1.32ms latency, random read = 6.95MB/s with average 0.56ms latency, and random write = 1.12MB/s with average 1.55ms latency and sysbench file fsyncs latency response time was very high with average 9.11 ms, max 25.93ms and 99th percentile at 16.71ms. File fsync latency is of a concern if you are working with MySQL database/servers - see Why Consumer SSD Reviews are Useless for Database Performance Use Case. To give you some context, a Linode 4GB $20/month KVM VPS for sysbench file fsyncs latency response time gives min: 0.15, avg: 0.21, max: 16.38 and 99th: 0.53 so 99th percentile fsync latency reponse time on Linode 4GB $20/month KVM VPS is 32x times faster than Skysilk's basic and standard medium VPS plans.
    • sysbench MySQL OLTP benchmarks for standard medium plan of transactions/s: 1128.35, queries/s: 22566.95, time: 30.0052s, and query time in milliseconds of min: 1.83, avg: 3.54, max: 244.44, 95th: 4.65 compared to basic medium plan of transactions/s: 822.96, queries/s: 16459.20, time: 30.0071s and query time in milliseconds of min: 2.12, avg: 4.86, max: 146.18, 95th: 6.79
    • Unfortunately, seems pure-ftpd failed to install properly
      Code (Text):
      --------------------------------------------------------
      Check pure-ftpd Version:
      --------------------------------------------------------
      421 Unable to switch capabilities : Operation not permitted
      
    Centmin Mod 123.09beta01 install 2nd attempt completed and much faster than Basic Medium plan benchmarked above. But still quite slow for 4 cpu VPS compared to relative times posted here.
    Code (Text):
    yum -y update; curl -O https://centminmod.com/betainstaller.sh && chmod 0700 betainstaller.sh && bash betainstaller.sh
    

    Code (Text):
    ---------------------------------------------------------------------------
    Total Curl Installer YUM or DNF Time: 283.4310 seconds
    Total YUM Time: 11.502405985 seconds
    Total YUM or DNF + Source Download Time: 108.7958
    Total Nginx First Time Install Time: 283.6383
    Total PHP First Time Install Time: 278.0569
    Download Zip From Github Time: 0.0000
    Total Time Other eg. source compiles: 369.3290
    Total Centmin Mod Install Time: 1039.8201
    ---------------------------------------------------------------------------
    Total Install Time (curl yum + cm install + zip download): 1323.2511 seconds
    ---------------------------------------------------------------------------
    4 Intel(R) Xeon(R) CPU E5-2680 0 @ 2.70GHz
    1 2987.448 1 3029.893 1 3175.915 1 3355.382
    ---------------------------------------------------------------------------
    

    Post install check list including properly installed PHP but seems Pure-ftpd failed to install properly
    Code (Text):
    *************************************************
    * Post-Install Check List....
    *************************************************
    
    --------------------------------------------------------
    Check ccache Version:
    --------------------------------------------------------
    ccache version 3.4.3
    
    Copyright (C) 2002-2007 Andrew Tridgell
    Copyright (C) 2009-2018 Joel Rosdahl
    
    This program is free software; you can redistribute it and/or modify it under
    the terms of the GNU General Public License as published by the Free Software
    Foundation; either version 3 of the License, or (at your option) any later
    version.
    
    --------------------------------------------------------
    Check Nginx Version:
    --------------------------------------------------------
    nginx version: nginx/1.15.3 (080918-110137)
    built by gcc 7.3.1 20180303 (Red Hat 7.3.1-5) (GCC)
    built with OpenSSL 1.1.0i  14 Aug 2018
    TLS SNI support enabled
    configure arguments: --with-ld-opt='-Wl,-E -L/usr/local/zlib-cf/lib -L/usr/local/lib -ljemalloc -Wl,-z,relro -Wl,-rpath,/usr/local/zlib-cf/lib:/usr/local/lib' --with-cc-opt='-I/usr/local/zlib-cf/include -I/usr/local/include -m64 -march=native -g -O3 -fstack-protector-strong -flto -fuse-ld=gold --param=ssp-buffer-size=4 -Wformat -Werror=format-security -Wimplicit-fallthrough=0 -fcode-hoisting -Wp,-D_FORTIFY_SOURCE=2 -gsplit-dwarf' --sbin-path=/usr/local/sbin/nginx --conf-path=/usr/local/nginx/conf/nginx.conf --build=080918-110137 --with-compat --with-http_stub_status_module --with-http_secure_link_module --with-libatomic --with-http_gzip_static_module --with-http_sub_module --with-http_addition_module --with-http_image_filter_module=dynamic --with-http_geoip_module --with-stream_geoip_module --with-stream_realip_module --with-stream_ssl_preread_module --with-threads --with-stream=dynamic --with-stream_ssl_module --with-http_realip_module --add-dynamic-module=../ngx-fancyindex-0.4.2 --add-module=../ngx_cache_purge-2.4.2 --add-dynamic-module=../ngx_devel_kit-0.3.0 --add-dynamic-module=../set-misc-nginx-module-0.32 --add-dynamic-module=../echo-nginx-module-0.61 --add-module=../redis2-nginx-module-0.15 --add-module=../ngx_http_redis-0.3.7 --add-module=../memc-nginx-module-0.18 --add-module=../srcache-nginx-module-0.31 --add-dynamic-module=../headers-more-nginx-module-0.33 --with-pcre-jit --with-http_ssl_module --with-http_v2_module --with-openssl=../openssl-1.1.0i --with-openssl-opt='enable-ec_nistp_64_gcc_128'
    
    --------------------------------------------------------
    Check PHP-FPM Version:
    --------------------------------------------------------
    PHP 5.6.37 (cli) (built: Sep  8 2018 11:10:01)
    Copyright (c) 1997-2016 The PHP Group
    Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies
        with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2016, by Zend Technologies
    
    --------------------------------------------------------
    Check MariaDB installed RPM Versions:
    --------------------------------------------------------
    MariaDB-server-10.1.35-1.el7.centos.x86_64
    MariaDB-common-10.1.35-1.el7.centos.x86_64
    MariaDB-devel-10.1.35-1.el7.centos.x86_64
    MariaDB-shared-10.1.35-1.el7.centos.x86_64
    MariaDB-client-10.1.35-1.el7.centos.x86_64
    MariaDB-compat-10.1.35-1.el7.centos.x86_64
    
    --------------------------------------------------------
    Check Memcached Server Version:
    --------------------------------------------------------
    memcached 1.5.10
    
    --------------------------------------------------------
    Check CSF Firewall Version:
    --------------------------------------------------------
    csf: v12.06 (generic)
    
    --------------------------------------------------------
    Check Siege Benchmark Version:
    --------------------------------------------------------
    SIEGE 4.0.4
    
    Copyright (C) 2017 by Jeffrey Fulmer, et al.
    This is free software; see the source for copying conditions.
    There is NO warranty; not even for MERCHANTABILITY or FITNESS
    FOR A PARTICULAR PURPOSE.
    
    
    --------------------------------------------------------
    Check mysqlreport version:
    --------------------------------------------------------
    mysqlreport v3.5-maria11 Jul 4 2013
    
    --------------------------------------------------------
    Check pure-ftpd Version:
    --------------------------------------------------------
    421 Unable to switch capabilities : Operation not permitted
    
    --------------------------------------------------------
    Check YUM Repo List
    --------------------------------------------------------
    Loaded plugins: fastestmirror, priorities, versionlock
    Loading mirror speeds from cached hostfile
     * base: mirrors.oit.uci.edu
     * epel: mirrors.develooper.com
     * extras: mirror.scalabledns.com
     * rpmforge: mirror.hmc.edu
     * updates: mirrors.usc.edu
    280 packages excluded due to repository priority protections
    repo id                 repo name                                    status
    base/7/x86_64           CentOS-7 - Base                              7,658+2,253
    centos-sclo-rh/x86_64   CentOS-7 - SCLo rh                              7,897+98
    centos-sclo-sclo/x86_64 CentOS-7 - SCLo sclo                                 773
    epel/x86_64             Extra Packages for Enterprise Linux 7 - x86_  11,697+974
    extras/7/x86_64         CentOS-7 - Extras                                    402
    mariadb                 MariaDB                                             72+3
    rpmforge                RHEL 7 - RPMforge.net - dag                      137+108
    updates/7/x86_64        CentOS-7 - Updates                             1,084+249
    repolist: 29,720
    
    --------------------------------------------------------
    mytimes check:
    /usr/bin/mytimes
    --------------------------------------------------------
    Sat Sep  8 11:14:34 UTC 2018  [UTC]
    Sat Sep  8 21:14:34 AEST 2018   [Australia/Brisbane]
    Sat Sep  8 04:14:34 PDT 2018    [America/Los_Angeles]
    Sat Sep  8 06:14:34 CDT 2018    [America/Chicago]
    Sat Sep  8 07:14:34 EDT 2018    [America/New_York]
    Sat Sep  8 07:14:34 EDT 2018    [America/Montreal]
    Sat Sep  8 12:14:34 BST 2018    [Europe/London]
    Sat Sep  8 13:14:34 CEST 2018   [Europe/Berlin]
    Sat Sep  8 18:14:34 +07 2018    [Asia/Bangkok]
    Sat Sep  8 18:14:34 +07 2018    [Asia/Ho_Chi_Minh]
    Sat Sep  8 18:14:34 WIB 2018    [Asia/Jakarta]
    Sat Sep  8 19:14:34 +08 2018    [Asia/Kuala_Lumpur]
    Sat Sep  8 19:14:34 +08 2018    [Asia/Singapore]
    --------------------------------------------------------
    


    sysbench benchmarks
    Code (Text):
    ./sysbench.sh cpu
    ./sysbench.sh mem
    ./sysbench.sh file
    ./sysbench.sh file-fsync
    ./sysbench.sh mysqloltpnew
    

    sysbench cpu
    Code (Text):
    ./sysbench.sh cpu
    -------------------------------------------
    System Information
    -------------------------------------------
    
    4.15.17-3-pve
    
    CentOS Linux release 7.5.1804 (Core)
    
    Centmin Mod
    Architecture:          x86_64
    CPU op-mode(s):        32-bit, 64-bit
    Byte Order:            Little Endian
    CPU(s):                32
    On-line CPU(s) list:   0-31
    Thread(s) per core:    2
    Core(s) per socket:    8
    Socket(s):             2
    NUMA node(s):          2
    Vendor ID:             GenuineIntel
    CPU family:            6
    Model:                 45
    Model name:            Intel(R) Xeon(R) CPU E5-2680 0 @ 2.70GHz
    Stepping:              7
    CPU MHz:               3149.280
    CPU max MHz:           3500.0000
    CPU min MHz:           1200.0000
    BogoMIPS:              5387.14
    Virtualization:        VT-x
    L1d cache:             32K
    L1i cache:             32K
    L2 cache:              256K
    L3 cache:              20480K
    NUMA node0 CPU(s):     0-7,16-23
    NUMA node1 CPU(s):     8-15,24-31
    Flags:                 fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc cpuid aperfmperf pni pclmulqdq dtes64 monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr pdcm pcid dca sse4_1 sse4_2 x2apic popcnt tsc_deadline_timer aes xsave avx lahf_lm epb pti tpr_shadow vnmi flexpriority ept vpid xsaveopt ibpb ibrs stibp dtherm ida arat pln pts
    
    CPU Flags
     fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc cpuid aperfmperf pni pclmulqdq dtes64 monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr pdcm pcid dca sse4_1 sse4_2 x2apic popcnt tsc_deadline_timer aes xsave avx lahf_lm epb pti tpr_shadow vnmi flexpriority ept vpid xsaveopt ibpb ibrs stibp dtherm ida arat pln pts
    
    CPU NODE SOCKET CORE L1d:L1i:L2:L3 ONLINE MAXMHZ    MINMHZ
    0   0    0      0    0:0:0:0       yes    3500.0000 1200.0000
    1   0    0      1    1:1:1:0       yes    3500.0000 1200.0000
    2   0    0      2    2:2:2:0       yes    3500.0000 1200.0000
    3   0    0      3    3:3:3:0       yes    3500.0000 1200.0000
    4   0    0      4    4:4:4:0       yes    3500.0000 1200.0000
    5   0    0      5    5:5:5:0       yes    3500.0000 1200.0000
    6   0    0      6    6:6:6:0       yes    3500.0000 1200.0000
    7   0    0      7    7:7:7:0       yes    3500.0000 1200.0000
    8   1    1      8    8:8:8:1       yes    3500.0000 1200.0000
    9   1    1      9    9:9:9:1       yes    3500.0000 1200.0000
    10  1    1      10   10:10:10:1    yes    3500.0000 1200.0000
    11  1    1      11   11:11:11:1    yes    3500.0000 1200.0000
    12  1    1      12   12:12:12:1    yes    3500.0000 1200.0000
    13  1    1      13   13:13:13:1    yes    3500.0000 1200.0000
    14  1    1      14   14:14:14:1    yes    3500.0000 1200.0000
    15  1    1      15   15:15:15:1    yes    3500.0000 1200.0000
    16  0    0      0    0:0:0:0       yes    3500.0000 1200.0000
    17  0    0      1    1:1:1:0       yes    3500.0000 1200.0000
    18  0    0      2    2:2:2:0       yes    3500.0000 1200.0000
    19  0    0      3    3:3:3:0       yes    3500.0000 1200.0000
    20  0    0      4    4:4:4:0       yes    3500.0000 1200.0000
    21  0    0      5    5:5:5:0       yes    3500.0000 1200.0000
    22  0    0      6    6:6:6:0       yes    3500.0000 1200.0000
    23  0    0      7    7:7:7:0       yes    3500.0000 1200.0000
    24  1    1      8    8:8:8:1       yes    3500.0000 1200.0000
    25  1    1      9    9:9:9:1       yes    3500.0000 1200.0000
    26  1    1      10   10:10:10:1    yes    3500.0000 1200.0000
    27  1    1      11   11:11:11:1    yes    3500.0000 1200.0000
    28  1    1      12   12:12:12:1    yes    3500.0000 1200.0000
    29  1    1      13   13:13:13:1    yes    3500.0000 1200.0000
    30  1    1      14   14:14:14:1    yes    3500.0000 1200.0000
    31  1    1      15   15:15:15:1    yes    3500.0000 1200.0000
    
                  total        used        free      shared  buff/cache   available
    Mem:          12000         645        6952         300        4401       11354
    Low:          12000        5047        6952
    High:             0           0           0
    Swap:          8191           0        8191
    
    Filesystem      Size  Used Avail Use% Mounted on
    /dev/rbd28      196G  4.5G  182G   3% /
    none            492K     0  492K   0% /dev
    tmpfs            63G     0   63G   0% /dev/shm
    tmpfs            63G  8.2M   63G   1% /run
    tmpfs            63G     0   63G   0% /sys/fs/cgroup
    tmpfs           1.2G     0  1.2G   0% /run/user/0
    
    
    sysbench cpu --cpu-max-prime=20000 --threads=1 run
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    prime: 20000
    events/s: 351.64
    time: 10.0027s
    min: 2.68
    avg: 2.84
    max: 3.99
    95th: 3.07
    
    | cpu sysbench | threads: | events/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- |
    | 1.0.15 | 1 | 351.64 | 10.0027s | 2.68 | 2.84 | 3.99 | 3.07 |
    
    sysbench,threads,events/s,time,min,avg,max,95th
    1.0.15,1,351.64,10.0027s,2.68,2.84,3.99,3.07
    
    sysbench cpu --cpu-max-prime=20000 --threads=4 run
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 4
    prime: 20000
    events/s: 1214.71
    time: 10.0030s
    min: 2.68
    avg: 3.29
    max: 27.12
    95th: 3.82
    
    | cpu sysbench | threads: | events/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- |
    | 1.0.15 | 4 | 1214.71 | 10.0030s | 2.68 | 3.29 | 27.12 | 3.82 |
    
    sysbench,threads,events/s,time,min,avg,max,95th
    1.0.15,4,1214.71,10.0030s,2.68,3.29,27.12,3.82
    

    sysbench memory
    Code (Text):
    ./sysbench.sh mem
    
    sysbench memory --threads=1 --memory-block-size=1K --memory-scope=global --memory-total-size=1G --memory-oper=read run
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    block-size: 1KiB
    total-size: 1024MiB
    operation: read
    scope: global
    total-ops: 1048576 (6130358.80 per second)
    transferred (5986.68 MiB/sec)
    time: 0.1693s
    min: 0.00
    avg: 0.00
    max: 0.02
    95th: 0.00
    
    | memory sysbench | sysbench | threads: | block-size: | total-size: | operation: | total-ops: | transferred | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | memory | 1.0.15 | 1 | 1KiB | 1024MiB | read | 1048576 | 5986.68 | 0.1693s | 0.00 | 0.00 | 0.02 | 0.00 |
    
    sysbench,sysbench,threads,block-size,total-size,operation,total-ops,transferred,time,min,avg,max,95th
    memory,1.0.15,1,1KiB,1024MiB,read,1048576,5986.68,0.1693s,0.00,0.00,0.02,0.00
    
    sysbench memory --threads=4 --memory-block-size=1K --memory-scope=global --memory-total-size=1G --memory-oper=read run
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 4
    block-size: 1KiB
    total-size: 1024MiB
    operation: read
    scope: global
    total-ops: 1048576 (11430235.94 per second)
    transferred (11162.34 MiB/sec)
    time: 0.0900s
    min: 0.00
    avg: 0.00
    max: 14.58
    95th: 0.00
    
    | memory sysbench | sysbench | threads: | block-size: | total-size: | operation: | total-ops: | transferred | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | memory | 1.0.15 | 4 | 1KiB | 1024MiB | read | 1048576 | 11162.34 | 0.0900s | 0.00 | 0.00 | 14.58 | 0.00 |
    
    sysbench,sysbench,threads,block-size,total-size,operation,total-ops,transferred,time,min,avg,max,95th
    memory,1.0.15,4,1KiB,1024MiB,read,1048576,11162.34,0.0900s,0.00,0.00,14.58,0.00
    

    sysbench file i/o
    Code (Text):
    ./sysbench.sh file
    
    sysbench fileio prepare
    sysbench fileio --file-total-size=2048M --file-test-mode=seqrd prepare
    
    sysbench fileio --threads=1 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=seqrd --time=10 --events=0 run
    raw log saved: /home/sysbench/sysbench-fileio-seqrd-threads-1-raw.log
    
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    Block-size 4KiB
    Using synchronous I/O mode
    Doing sequential read test
    reads/s: 2996.34
    writes/s: 0.00
    fsyncs/s: 0.00
    read-MiB/s: 11.70
    written-MiB/s: 0.00
    time: 10.0004s
    min: 0.20
    avg: 0.33
    max: 16.14
    95th: 0.45
    
    | fileio sysbench | sysbench | threads: | Block-size | synchronous | sequential | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | fileio | 1.0.15 | 1 | 4KiB | I/O | read | 2996.34 | 0.00 | 0.00 | 11.70 | 0.00 | 10.0004s | 0.20 | 0.33 | 16.14 | 0.45 |
    
    sysbench,sysbench,threads,Block-size,synchronous,sequential,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th
    fileio,1.0.15,1,4KiB,I/O,read,2996.34,0.00,0.00,11.70,0.00,10.0004s,0.20,0.33,16.14,0.45
    
    
    sysbench fileio cleanup
    sysbench fileio --file-total-size=2048M cleanup
    
    sysbench fileio prepare
    sysbench fileio --file-total-size=2048M --file-test-mode=seqwr prepare
    
    sysbench fileio --threads=1 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=seqwr --time=10 --events=0 run
    raw log saved: /home/sysbench/sysbench-fileio-seqwr-threads-1-raw.log
    
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    Block-size 4KiB
    Using synchronous I/O mode
    Doing sequential write (creation) test
    reads/s: 0.00
    writes/s: 255.19
    fsyncs/s: 332.26
    read-MiB/s: 0.00
    written-MiB/s: 1.00
    time: 10.0145s
    min: 0.00
    avg: 1.74
    max: 80.78
    95th: 7.70
    
    | fileio sysbench | sysbench | threads: | Block-size | synchronous | sequential | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | fileio | 1.0.15 | 1 | 4KiB | I/O | write | 0.00 | 255.19 | 332.26 | 0.00 | 1.00 | 10.0145s | 0.00 | 1.74 | 80.78 | 7.70 |
    
    sysbench,sysbench,threads,Block-size,synchronous,sequential,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th
    fileio,1.0.15,1,4KiB,I/O,write,0.00,255.19,332.26,0.00,1.00,10.0145s,0.00,1.74,80.78,7.70
    
    
    sysbench fileio cleanup
    sysbench fileio --file-total-size=2048M cleanup
    
    sysbench fileio prepare
    sysbench fileio --file-total-size=2048M --file-test-mode=rndrd prepare
    
    sysbench fileio --threads=1 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=rndrd --time=10 --events=0 run
    raw log saved: /home/sysbench/sysbench-fileio-rndrd-threads-1-raw.log
    
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    Block-size 4KiB
    Read/Write ratio for combined random IO test: 1.50
    Using synchronous I/O mode
    Doing random read test
    reads/s: 1739.16
    writes/s: 0.00
    fsyncs/s: 0.00
    read-MiB/s: 6.79
    written-MiB/s: 0.00
    time: 10.0003s
    min: 0.20
    avg: 0.57
    max: 119.66
    95th: 0.75
    
    | fileio sysbench | sysbench | threads: | Block-size | synchronous | random | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | fileio | 1.0.15 | 1 | 4KiB | I/O | read | 1739.16 | 0.00 | 0.00 | 6.79 | 0.00 | 10.0003s | 0.20 | 0.57 | 119.66 | 0.75 |
    
    sysbench,sysbench,threads,Block-size,synchronous,random,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th
    fileio,1.0.15,1,4KiB,I/O,read,1739.16,0.00,0.00,6.79,0.00,10.0003s,0.20,0.57,119.66,0.75
    
    
    sysbench fileio cleanup
    sysbench fileio --file-total-size=2048M cleanup
    
    sysbench fileio prepare
    sysbench fileio --file-total-size=2048M --file-test-mode=rndwr prepare
    
    sysbench fileio --threads=1 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=rndwr --time=10 --events=0 run
    raw log saved: /home/sysbench/sysbench-fileio-rndwr-threads-1-raw.log
    
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    Block-size 4KiB
    Read/Write ratio for combined random IO test: 1.50
    Using synchronous I/O mode
    Doing random write test
    reads/s: 0.00
    writes/s: 286.20
    fsyncs/s: 370.69
    read-MiB/s: 0.00
    written-MiB/s: 1.12
    time: 10.0121s
    min: 0.00
    avg: 1.55
    max: 20.29
    95th: 4.65
    
    | fileio sysbench | sysbench | threads: | Block-size | synchronous | random | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | fileio | 1.0.15 | 1 | 4KiB | I/O | write | 0.00 | 286.20 | 370.69 | 0.00 | 1.12 | 10.0121s | 0.00 | 1.55 | 20.29 | 4.65 |
    
    sysbench,sysbench,threads,Block-size,synchronous,random,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th
    fileio,1.0.15,1,4KiB,I/O,write,0.00,286.20,370.69,0.00,1.12,10.0121s,0.00,1.55,20.29,4.65
    
    
    
    sysbench fileio cleanup
    sysbench fileio --file-total-size=2048M cleanup
    
    sysbench fileio prepare
    sysbench fileio --file-total-size=2048M --file-test-mode=seqrd prepare
    
    sysbench fileio --threads=4 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=seqrd --time=10 --events=0 run
    raw log saved: /home/sysbench/sysbench-fileio-seqrd-threads-4-raw.log
    
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 4
    Block-size 4KiB
    Using synchronous I/O mode
    Doing sequential read test
    reads/s: 8264.63
    writes/s: 0.00
    fsyncs/s: 0.00
    read-MiB/s: 32.28
    written-MiB/s: 0.00
    time: 10.0003s
    min: 0.22
    avg: 0.48
    max: 16.63
    95th: 0.74
    
    | fileio sysbench | sysbench | threads: | Block-size | synchronous | sequential | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | fileio | 1.0.15 | 4 | 4KiB | I/O | read | 8264.63 | 0.00 | 0.00 | 32.28 | 0.00 | 10.0003s | 0.22 | 0.48 | 16.63 | 0.74 |
    
    sysbench,sysbench,threads,Block-size,synchronous,sequential,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th
    fileio,1.0.15,4,4KiB,I/O,read,8264.63,0.00,0.00,32.28,0.00,10.0003s,0.22,0.48,16.63,0.74
    
    
    sysbench fileio cleanup
    sysbench fileio --file-total-size=2048M cleanup
    
    sysbench fileio prepare
    sysbench fileio --file-total-size=2048M --file-test-mode=seqwr prepare
    
    sysbench fileio --threads=4 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=seqwr --time=10 --events=0 run
    raw log saved: /home/sysbench/sysbench-fileio-seqwr-threads-4-raw.log
    
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 4
    Block-size 4KiB
    Using synchronous I/O mode
    Doing sequential write (creation) test
    reads/s: 0.00
    writes/s: 248.69
    fsyncs/s: 357.53
    read-MiB/s: 0.00
    written-MiB/s: 0.97
    time: 10.0229s
    min: 0.00
    avg: 7.19
    max: 74.09
    95th: 29.72
    
    | fileio sysbench | sysbench | threads: | Block-size | synchronous | sequential | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | fileio | 1.0.15 | 4 | 4KiB | I/O | write | 0.00 | 248.69 | 357.53 | 0.00 | 0.97 | 10.0229s | 0.00 | 7.19 | 74.09 | 29.72 |
    
    sysbench,sysbench,threads,Block-size,synchronous,sequential,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th
    fileio,1.0.15,4,4KiB,I/O,write,0.00,248.69,357.53,0.00,0.97,10.0229s,0.00,7.19,74.09,29.72
    
    
    sysbench fileio cleanup
    sysbench fileio --file-total-size=2048M cleanup
    
    sysbench fileio prepare
    sysbench fileio --file-total-size=2048M --file-test-mode=rndrd prepare
    
    sysbench fileio --threads=4 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=rndrd --time=10 --events=0 run
    raw log saved: /home/sysbench/sysbench-fileio-rndrd-threads-4-raw.log
    
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 4
    Block-size 4KiB
    Read/Write ratio for combined random IO test: 1.50
    Using synchronous I/O mode
    Doing random read test
    reads/s: 7878.15
    writes/s: 0.00
    fsyncs/s: 0.00
    read-MiB/s: 30.77
    written-MiB/s: 0.00
    time: 10.0004s
    min: 0.18
    avg: 0.51
    max: 46.63
    95th: 0.68
    
    | fileio sysbench | sysbench | threads: | Block-size | synchronous | random | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | fileio | 1.0.15 | 4 | 4KiB | I/O | read | 7878.15 | 0.00 | 0.00 | 30.77 | 0.00 | 10.0004s | 0.18 | 0.51 | 46.63 | 0.68 |
    
    sysbench,sysbench,threads,Block-size,synchronous,random,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th
    fileio,1.0.15,4,4KiB,I/O,read,7878.15,0.00,0.00,30.77,0.00,10.0004s,0.18,0.51,46.63,0.68
    
    
    sysbench fileio cleanup
    sysbench fileio --file-total-size=2048M cleanup
    
    sysbench fileio prepare
    sysbench fileio --file-total-size=2048M --file-test-mode=rndwr prepare
    
    sysbench fileio --threads=4 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=rndwr --time=10 --events=0 run
    raw log saved: /home/sysbench/sysbench-fileio-rndwr-threads-4-raw.log
    
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 4
    Block-size 4KiB
    Read/Write ratio for combined random IO test: 1.50
    Using synchronous I/O mode
    Doing random write test
    reads/s: 0.00
    writes/s: 793.36
    fsyncs/s: 1060.87
    read-MiB/s: 0.00
    written-MiB/s: 3.10
    time: 10.0125s
    min: 0.00
    avg: 2.21
    max: 878.02
    95th: 5.28
    
    | fileio sysbench | sysbench | threads: | Block-size | synchronous | random | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | fileio | 1.0.15 | 4 | 4KiB | I/O | write | 0.00 | 793.36 | 1060.87 | 0.00 | 3.10 | 10.0125s | 0.00 | 2.21 | 878.02 | 5.28 |
    
    sysbench,sysbench,threads,Block-size,synchronous,random,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th
    fileio,1.0.15,4,4KiB,I/O,write,0.00,793.36,1060.87,0.00,3.10,10.0125s,0.00,2.21,878.02,5.28
    
    
    sysbench fileio cleanup
    sysbench fileio --file-total-size=2048M cleanup
    
    | fileio sysbench | sysbench | threads: | Block-size | synchronous | sequential | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    |fileio | 1.0.15 | 1 | 4KiB | I/O | read | 2996.34 | 0.00 | 0.00 | 11.70 | 0.00 | 10.0004s | 0.20 | 0.33 | 16.14 | 0.45 |
    |fileio | 1.0.15 | 1 | 4KiB | I/O | write | 0.00 | 255.19 | 332.26 | 0.00 | 1.00 | 10.0145s | 0.00 | 1.74 | 80.78 | 7.70 |
    |fileio | 1.0.15 | 4 | 4KiB | I/O | read | 8264.63 | 0.00 | 0.00 | 32.28 | 0.00 | 10.0003s | 0.22 | 0.48 | 16.63 | 0.74 |
    |fileio | 1.0.15 | 4 | 4KiB | I/O | write | 0.00 | 248.69 | 357.53 | 0.00 | 0.97 | 10.0229s | 0.00 | 7.19 | 74.09 | 29.72 |
    
    | fileio sysbench | sysbench | threads: | Block-size | synchronous | random | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    |fileio | 1.0.15 | 1 | 4KiB | I/O | read | 1739.16 | 0.00 | 0.00 | 6.79 | 0.00 | 10.0003s | 0.20 | 0.57 | 119.66 | 0.75 |
    |fileio | 1.0.15 | 1 | 4KiB | I/O | write | 0.00 | 286.20 | 370.69 | 0.00 | 1.12 | 10.0121s | 0.00 | 1.55 | 20.29 | 4.65 |
    |fileio | 1.0.15 | 4 | 4KiB | I/O | read | 7878.15 | 0.00 | 0.00 | 30.77 | 0.00 | 10.0004s | 0.18 | 0.51 | 46.63 | 0.68 |
    |fileio | 1.0.15 | 4 | 4KiB | I/O | write | 0.00 | 793.36 | 1060.87 | 0.00 | 3.10 | 10.0125s | 0.00 | 2.21 | 878.02 | 5.28 |
    
    

    sysbench file fsync
    Code (Text):
    ./sysbench.sh file-fsync
    
    sysbench fileio fsync prepare
    sysbench fileio --time=30 --file-num=1 --file-extra-flags= --file-total-size=4096 --file-block-size=4096 --file-fsync-all=on --file-test-mode=rndwr --file-fsync-freq=0 --file-fsync-end=0 --threads=1 --percentile=99 prepare
    
    sysbench fileio --threads=1 --time=30 --file-num=1 --file-extra-flags= --file-total-size=4096 --file-block-size=4096 --file-fsync-all=on --file-test-mode=rndwr --file-fsync-freq=0 --file-fsync-end=0 --percentile=99 run
    raw log saved: /home/sysbench/sysbench-fileio-fsync-threads-1-raw.log
    
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    Block-size 4KiB
    Read/Write ratio for combined random IO test: 1.50
    Using synchronous I/O mode
    Doing random write test
    reads/s: 0.00
    writes/s: 116.68
    fsyncs/s: 116.68
    read-MiB/s: 0.00
    written-MiB/s: 0.46
    time: 30.0041s
    min: 1.06
    avg: 8.57
    max: 135.72
    99th: 17.01
    
    | fileio sysbench | sysbench | threads: | Block-size | synchronous | random | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 99th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | fileio | 1.0.15 | 1 | 4KiB | I/O | write | 0.00 | 116.68 | 116.68 | 0.00 | 0.46 | 30.0041s | 1.06 | 8.57 | 135.72 | 17.01 |
    
    sysbench,sysbench,threads,Block-size,synchronous,random,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,99th
    fileio,1.0.15,1,4KiB,I/O,write,0.00,116.68,116.68,0.00,0.46,30.0041s,1.06,8.57,135.72,17.01
    
    
    sysbench fileio cleanup
    sysbench fileio --file-num=1 --file-extra-flags= --file-total-size=4096 --file-block-size=4096 cleanup
    

    mysql OLTP
    Code (Text):
    ./sysbench.sh mysqloltpnew
    
    setup sbt database & user
    mysqladmin create database: sbt
    Grants for [email protected]
    GRANT USAGE ON *.* TO 'sbtest'@'localhost' IDENTIFIED BY PASSWORD '*E6A410EB4C0B2737A6FC7845D7727289E65F2C8E'
    GRANT ALL PRIVILEGES ON `sbt`.* TO 'sbtest'@'localhost'
    
    MySQL Buffers
    aria_pagecache_buffer_size           1073741824
    aria_sort_buffer_size                268435456
    bulk_insert_buffer_size              8388608
    innodb_buffer_pool_dump_at_shutdown  OFF
    innodb_buffer_pool_dump_now          OFF
    innodb_buffer_pool_dump_pct          100
    innodb_buffer_pool_filename          ib_buffer_pool
    innodb_buffer_pool_instances         1
    innodb_buffer_pool_load_abort        OFF
    innodb_buffer_pool_load_at_startup   OFF
    innodb_buffer_pool_load_now          OFF
    innodb_buffer_pool_populate          OFF
    innodb_buffer_pool_size              1073741824
    innodb_change_buffer_max_size        25
    innodb_change_buffering              all
    innodb_log_buffer_size               8388608
    innodb_sort_buffer_size              2097152
    join_buffer_size                     262144
    join_buffer_space_limit              2097152
    key_buffer_size                      402653184
    mrr_buffer_size                      262144
    myisam_sort_buffer_size              268435456
    net_buffer_length                    16384
    optimizer_switch                     index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off
    preload_buffer_size                  32768
    read_buffer_size                     262144
    read_rnd_buffer_size                 524288
    sort_buffer_size                     524288
    sql_buffer_result                    OFF
    
    MySQL Limits
    aria_pagecache_division_limit         100
    delayed_insert_limit                  100
    expensive_subquery_limit              100
    ft_query_expansion_limit              20
    innodb_ft_result_cache_limit          2000000000
    join_buffer_space_limit               2097152
    key_cache_division_limit              100
    log_slow_rate_limit                   1
    min_examined_row_limit                0
    open_files_limit                      524288
    optimizer_selectivity_sampling_limit  100
    query_cache_limit                     1048576
    relay_log_space_limit                 0
    sql_select_limit                      18446744073709551615
    thread_pool_stall_limit               500
    updatable_views_with_limit            YES
    
    MySQL Maxes
    aria_max_sort_file_size           9223372036853727232
    extra_max_connections             1
    ft_max_word_len                   84
    group_concat_max_len              1024
    innodb_adaptive_max_sleep_delay   150000
    innodb_compression_pad_pct_max    50
    innodb_file_format_max            Antelope
    innodb_ft_max_token_size          84
    innodb_io_capacity_max            1600
    innodb_max_bitmap_file_size       104857600
    innodb_max_changed_pages          1000000
    innodb_max_dirty_pages_pct        75.000000
    innodb_max_dirty_pages_pct_lwm    0.001000
    innodb_max_purge_lag              0
    innodb_max_purge_lag_delay        0
    innodb_online_alter_log_max_size  134217728
    max_allowed_packet                134217728
    max_binlog_cache_size             18446744073709547520
    max_binlog_size                   1073741824
    max_binlog_stmt_cache_size        18446744073709547520
    max_connect_errors                100000
    max_connections                   750
    max_delayed_threads               20
    max_digest_length                 1024
    max_error_count                   64
    max_heap_table_size               536870912
    max_insert_delayed_threads        20
    max_join_size                     18446744073709551615
    max_length_for_sort_data          1024
    max_long_data_size                134217728
    max_prepared_stmt_count           16382
    max_relay_log_size                1073741824
    max_seeks_for_key                 4294967295
    max_session_mem_used              9223372036854775807
    max_sort_length                   1024
    max_sp_recursion_depth            0
    max_statement_time                0.000000
    max_tmp_tables                    32
    max_user_connections              0
    max_write_lock_count              4294967295
    myisam_max_sort_file_size         2147483648
    slave_max_allowed_packet          1073741824
    slave_parallel_max_queued         131072
    thread_pool_max_threads           1000
    wsrep_max_ws_rows                 0
    wsrep_max_ws_size                 2147483647
    
    MySQL Concurrency
    concurrent_insert           ALWAYS
    innodb_commit_concurrency   0
    innodb_concurrency_tickets  5000
    innodb_thread_concurrency   0
    thread_concurrency          10
    
    MySQL Read/Write
    delay_key_write           ON
    innodb_disallow_writes    OFF
    innodb_doublewrite        ON
    innodb_use_atomic_writes  OFF
    max_write_lock_count      4294967295
    net_write_timeout         60
    wsrep_causal_reads        OFF
    wsrep_dirty_reads         OFF
    
    MySQL Threads
    aria_repair_threads                      1
    binlog_optimize_thread_scheduling        ON
    debug_no_thread_alarm                    OFF
    innodb_encryption_threads                0
    innodb_mtflush_threads                   8
    innodb_purge_threads                     2
    innodb_read_io_threads                   2
    innodb_thread_concurrency                0
    innodb_thread_sleep_delay                10000
    innodb_write_io_threads                  2
    max_delayed_threads                      20
    max_insert_delayed_threads               20
    myisam_repair_threads                    1
    performance_schema_max_thread_classes    50
    performance_schema_max_thread_instances  -1
    slave_domain_parallel_threads            0
    slave_parallel_threads                   0
    thread_cache_size                        256
    thread_concurrency                       10
    thread_handling                          one-thread-per-connection
    thread_pool_idle_timeout                 60
    thread_pool_max_threads                  1000
    thread_pool_oversubscribe                3
    thread_pool_size                         32
    thread_pool_stall_limit                  500
    thread_stack                             295936
    wsrep_slave_threads                      1
    
    MySQL Binlog
    binlog_annotate_row_events               OFF
    binlog_cache_size                        32768
    binlog_checksum                          NONE
    binlog_commit_wait_count                 0
    binlog_commit_wait_usec                  100000
    binlog_direct_non_transactional_updates  OFF
    binlog_format                            STATEMENT
    binlog_optimize_thread_scheduling        ON
    binlog_row_image                         FULL
    binlog_stmt_cache_size                   32768
    encrypt_binlog                           OFF
    gtid_binlog_pos
    gtid_binlog_state
    innodb_api_enable_binlog                 OFF
    innodb_locks_unsafe_for_binlog           OFF
    log_bin                                  OFF
    log_bin_basename
    log_bin_index
    log_bin_trust_function_creators          OFF
    max_binlog_cache_size                    18446744073709547520
    max_binlog_size                          1073741824
    max_binlog_stmt_cache_size               18446744073709547520
    sql_log_bin                              ON
    sync_binlog                              0
    wsrep_forced_binlog_format               NONE
    
    MySQL InnoDB
    ignore_builtin_innodb                        OFF
    innodb_adaptive_flushing                     ON
    innodb_adaptive_flushing_lwm                 10.000000
    innodb_adaptive_hash_index                   ON
    innodb_adaptive_hash_index_partitions        1
    innodb_adaptive_max_sleep_delay              150000
    innodb_additional_mem_pool_size              8388608
    innodb_api_bk_commit_interval                5
    innodb_api_disable_rowlock                   OFF
    innodb_api_enable_binlog                     OFF
    innodb_api_enable_mdl                        OFF
    innodb_api_trx_level                         0
    innodb_autoextend_increment                  64
    innodb_autoinc_lock_mode                     1
    innodb_background_scrub_data_check_interval  3600
    innodb_background_scrub_data_compressed      OFF
    innodb_background_scrub_data_interval        604800
    innodb_background_scrub_data_uncompressed    OFF
    innodb_buf_dump_status_frequency             0
    innodb_buffer_pool_dump_at_shutdown          OFF
    innodb_buffer_pool_dump_now                  OFF
    innodb_buffer_pool_dump_pct                  100
    innodb_buffer_pool_filename                  ib_buffer_pool
    innodb_buffer_pool_instances                 1
    innodb_buffer_pool_load_abort                OFF
    innodb_buffer_pool_load_at_startup           OFF
    innodb_buffer_pool_load_now                  OFF
    innodb_buffer_pool_populate                  OFF
    innodb_buffer_pool_size                      1073741824
    innodb_change_buffer_max_size                25
    innodb_change_buffering                      all
    innodb_checksum_algorithm                    INNODB
    innodb_checksums                             ON
    innodb_cleaner_lsn_age_factor                HIGH_CHECKPOINT
    innodb_cmp_per_index_enabled                 OFF
    innodb_commit_concurrency                    0
    innodb_compression_algorithm                 zlib
    innodb_compression_failure_threshold_pct     5
    innodb_compression_level                     6
    innodb_compression_pad_pct_max               50
    innodb_concurrency_tickets                   5000
    innodb_corrupt_table_action                  assert
    innodb_data_file_path                        ibdata1:10M:autoextend
    innodb_data_home_dir
    innodb_default_encryption_key_id             1
    innodb_default_row_format                    dynamic
    innodb_defragment                            ON
    innodb_defragment_fill_factor                0.900000
    innodb_defragment_fill_factor_n_recs         20
    innodb_defragment_frequency                  40
    innodb_defragment_n_pages                    7
    innodb_defragment_stats_accuracy             0
    innodb_disable_sort_file_cache               OFF
    innodb_disallow_writes                       OFF
    innodb_doublewrite                           ON
    innodb_empty_free_list_algorithm             BACKOFF
    innodb_encrypt_log                           OFF
    innodb_encrypt_tables                        OFF
    innodb_encryption_rotate_key_age             1
    innodb_encryption_rotation_iops              100
    innodb_encryption_threads                    0
    innodb_fake_changes                          OFF
    innodb_fast_shutdown                         1
    innodb_fatal_semaphore_wait_threshold        600
    innodb_file_format                           Barracuda
    innodb_file_format_check                     ON
    innodb_file_format_max                       Antelope
    innodb_file_per_table                        ON
    innodb_flush_log_at_timeout                  1
    innodb_flush_log_at_trx_commit               2
    innodb_flush_method                          O_DIRECT
    innodb_flush_neighbors                       0
    innodb_flushing_avg_loops                    30
    innodb_force_load_corrupted                  OFF
    innodb_force_primary_key                     OFF
    innodb_force_recovery                        0
    innodb_foreground_preflush                   EXPONENTIAL_BACKOFF
    innodb_ft_aux_table
    innodb_ft_cache_size                         8000000
    innodb_ft_enable_diag_print                  OFF
    innodb_ft_enable_stopword                    ON
    innodb_ft_max_token_size                     84
    innodb_ft_min_token_size                     3
    innodb_ft_num_word_optimize                  2000
    innodb_ft_result_cache_limit                 2000000000
    innodb_ft_server_stopword_table
    innodb_ft_sort_pll_degree                    2
    innodb_ft_total_cache_size                   640000000
    innodb_ft_user_stopword_table
    innodb_idle_flush_pct                        100
    innodb_immediate_scrub_data_uncompressed     OFF
    innodb_instrument_semaphores                 OFF
    innodb_io_capacity                           800
    innodb_io_capacity_max                       1600
    innodb_kill_idle_transaction                 0
    innodb_large_prefix                          ON
    innodb_lock_schedule_algorithm               fcfs
    innodb_lock_wait_timeout                     50
    innodb_locking_fake_changes                  ON
    innodb_locks_unsafe_for_binlog               OFF
    innodb_log_arch_dir                          ./
    innodb_log_arch_expire_sec                   0
    innodb_log_archive                           OFF
    innodb_log_block_size                        512
    innodb_log_buffer_size                       8388608
    innodb_log_checksum_algorithm                INNODB
    innodb_log_compressed_pages                  ON
    innodb_log_file_size                         402653184
    innodb_log_files_in_group                    2
    innodb_log_group_home_dir                    ./
    innodb_lru_scan_depth                        1024
    innodb_max_bitmap_file_size                  104857600
    innodb_max_changed_pages                     1000000
    innodb_max_dirty_pages_pct                   75.000000
    innodb_max_dirty_pages_pct_lwm               0.001000
    innodb_max_purge_lag                         0
    innodb_max_purge_lag_delay                   0
    innodb_mirrored_log_groups                   1
    innodb_monitor_disable
    innodb_monitor_enable
    innodb_monitor_reset
    innodb_monitor_reset_all
    innodb_mtflush_threads                       8
    innodb_old_blocks_pct                        37
    innodb_old_blocks_time                       1000
    innodb_online_alter_log_max_size             134217728
    innodb_open_files                            1000
    innodb_optimize_fulltext_only                OFF
    innodb_page_size                             16384
    innodb_prefix_index_cluster_optimization     OFF
    innodb_print_all_deadlocks                   OFF
    innodb_print_lock_wait_timeout_info          OFF
    innodb_purge_batch_size                      300
    innodb_purge_threads                         2
    innodb_random_read_ahead                     OFF
    innodb_read_ahead_threshold                  56
    innodb_read_io_threads                       2
    innodb_read_only                             OFF
    innodb_replication_delay                     0
    innodb_rollback_on_timeout                   OFF
    innodb_rollback_segments                     128
    innodb_sched_priority_cleaner                19
    innodb_scrub_log                             OFF
    innodb_scrub_log_speed                       256
    innodb_show_locks_held                       10
    innodb_show_verbose_locks                    0
    innodb_simulate_comp_failures                0
    innodb_sort_buffer_size                      2097152
    innodb_spin_wait_delay                       6
    innodb_stats_auto_recalc                     ON
    innodb_stats_include_delete_marked           OFF
    innodb_stats_method                          nulls_equal
    innodb_stats_modified_counter                0
    innodb_stats_on_metadata                     OFF
    innodb_stats_persistent                      ON
    innodb_stats_persistent_sample_pages         20
    innodb_stats_sample_pages                    8
    innodb_stats_traditional                     ON
    innodb_stats_transient_sample_pages          8
    innodb_status_output                         OFF
    innodb_status_output_locks                   OFF
    innodb_strict_mode                           OFF
    innodb_support_xa                            ON
    innodb_sync_array_size                       1
    innodb_sync_spin_loops                       30
    innodb_table_locks                           ON
    innodb_thread_concurrency                    0
    innodb_thread_sleep_delay                    10000
    innodb_tmpdir
    innodb_track_changed_pages                   OFF
    innodb_undo_directory                        .
    innodb_undo_logs                             128
    innodb_undo_tablespaces                      0
    innodb_use_atomic_writes                     OFF
    innodb_use_fallocate                         OFF
    innodb_use_global_flush_log_at_trx_commit    ON
    innodb_use_mtflush                           OFF
    innodb_use_native_aio                        ON
    innodb_use_stacktrace                        OFF
    innodb_use_sys_malloc                        ON
    innodb_use_trim                              OFF
    innodb_version                               5.6.39-83.1
    innodb_write_io_threads                      2
    
    
    sysbench prepare database: sbt
    sysbench oltp_read_write.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-storage-engine=InnoDB --time=30 --threads=4 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql prepare
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    
    Initializing worker threads...
    
    Creating table 'sbtest1'...
    Creating table 'sbtest3'...
    Creating table 'sbtest2'...
    Creating table 'sbtest4'...
    Inserting 150000 records into 'sbtest4'
    Inserting 150000 records into 'sbtest1'
    Inserting 150000 records into 'sbtest3'
    Inserting 150000 records into 'sbtest2'
    Creating a secondary index on 'sbtest4'...
    Creating a secondary index on 'sbtest3'...
    Creating a secondary index on 'sbtest2'...
    Creating table 'sbtest8'...
    Inserting 150000 records into 'sbtest8'
    Creating table 'sbtest6'...
    Creating a secondary index on 'sbtest1'...
    Inserting 150000 records into 'sbtest6'
    Creating table 'sbtest7'...
    Inserting 150000 records into 'sbtest7'
    Creating table 'sbtest5'...
    Inserting 150000 records into 'sbtest5'
    Creating a secondary index on 'sbtest8'...
    Creating a secondary index on 'sbtest7'...
    Creating a secondary index on 'sbtest5'...
    Creating a secondary index on 'sbtest6'...
    
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    | Table Name  | Number of Rows | Storage Engine | Data Size | Index Size | Total   | ROW_FORMAT | TABLE_COLLATION |
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    | sbt.sbtest1 | 150000 Rows    | InnoDB         | 0.06MB    | 0.00MB     | 0.06MB  | Dynamic    | utf8_general_ci |
    | sbt.sbtest2 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Dynamic    | utf8_general_ci |
    | sbt.sbtest3 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Dynamic    | utf8_general_ci |
    | sbt.sbtest4 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8_general_ci |
    | sbt.sbtest5 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8_general_ci |
    | sbt.sbtest6 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8_general_ci |
    | sbt.sbtest7 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8_general_ci |
    | sbt.sbtest8 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8_general_ci |
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    
    sysbench mysql OLTP new benchmark:
    sysbench oltp_read_write.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-storage-engine=InnoDB --time=30 --threads=4 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql run
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    
    Running the test with following options:
    Number of threads: 4
    Report intermediate results every 1 second(s)
    Initializing random number generator from seed (1).
    
    
    Initializing worker threads...
    
    Threads started!
    
    [ 1s ] thds: 4 tps: 718.26 qps: 14405.18 (r/w/o: 10091.61/2873.06/1440.52) lat (ms,95%): 7.30 err/s: 0.00 reconn/s: 0.00
    [ 2s ] thds: 4 tps: 790.60 qps: 15817.03 (r/w/o: 11073.42/3162.40/1581.20) lat (ms,95%): 6.91 err/s: 0.00 reconn/s: 0.00
    [ 3s ] thds: 4 tps: 892.02 qps: 17862.34 (r/w/o: 12503.24/3575.07/1784.03) lat (ms,95%): 5.00 err/s: 0.00 reconn/s: 0.00
    [ 4s ] thds: 4 tps: 1094.91 qps: 21895.28 (r/w/o: 15326.80/4378.66/2189.83) lat (ms,95%): 4.49 err/s: 0.00 reconn/s: 0.00
    [ 5s ] thds: 4 tps: 1181.16 qps: 23614.11 (r/w/o: 16533.18/4718.62/2362.31) lat (ms,95%): 4.10 err/s: 0.00 reconn/s: 0.00
    [ 6s ] thds: 4 tps: 1209.97 qps: 24194.34 (r/w/o: 16932.54/4841.87/2419.93) lat (ms,95%): 3.96 err/s: 0.00 reconn/s: 0.00
    [ 7s ] thds: 4 tps: 1202.91 qps: 24050.12 (r/w/o: 16834.68/4809.62/2405.81) lat (ms,95%): 3.96 err/s: 0.00 reconn/s: 0.00
    [ 8s ] thds: 4 tps: 1267.10 qps: 25347.00 (r/w/o: 17741.40/5071.40/2534.20) lat (ms,95%): 3.82 err/s: 0.00 reconn/s: 0.00
    [ 9s ] thds: 4 tps: 1276.69 qps: 25534.71 (r/w/o: 17872.60/5108.74/2553.37) lat (ms,95%): 4.10 err/s: 0.00 reconn/s: 0.00
    [ 10s ] thds: 4 tps: 1144.20 qps: 22888.07 (r/w/o: 16024.85/4574.81/2288.41) lat (ms,95%): 4.10 err/s: 0.00 reconn/s: 0.00
    [ 11s ] thds: 4 tps: 1225.94 qps: 24506.90 (r/w/o: 17149.23/4905.78/2451.89) lat (ms,95%): 3.96 err/s: 0.00 reconn/s: 0.00
    [ 12s ] thds: 4 tps: 1190.76 qps: 23833.26 (r/w/o: 16690.68/4761.05/2381.53) lat (ms,95%): 4.03 err/s: 0.00 reconn/s: 0.00
    [ 13s ] thds: 4 tps: 1240.42 qps: 24786.43 (r/w/o: 17346.90/4958.69/2480.84) lat (ms,95%): 3.96 err/s: 0.00 reconn/s: 0.00
    [ 14s ] thds: 4 tps: 1257.53 qps: 25159.55 (r/w/o: 17614.38/5030.11/2515.06) lat (ms,95%): 3.89 err/s: 0.00 reconn/s: 0.00
    [ 15s ] thds: 4 tps: 1304.98 qps: 26116.57 (r/w/o: 18282.70/5223.91/2609.96) lat (ms,95%): 3.89 err/s: 0.00 reconn/s: 0.00
    [ 16s ] thds: 4 tps: 1253.44 qps: 25035.76 (r/w/o: 17517.13/5011.75/2506.88) lat (ms,95%): 3.82 err/s: 0.00 reconn/s: 0.00
    [ 17s ] thds: 4 tps: 1287.81 qps: 25758.17 (r/w/o: 18032.32/5150.23/2575.62) lat (ms,95%): 3.82 err/s: 0.00 reconn/s: 0.00
    [ 18s ] thds: 4 tps: 1190.01 qps: 23814.12 (r/w/o: 16672.08/4762.02/2380.01) lat (ms,95%): 4.10 err/s: 0.00 reconn/s: 0.00
    [ 19s ] thds: 4 tps: 1239.21 qps: 24794.25 (r/w/o: 17356.98/4958.85/2478.43) lat (ms,95%): 4.10 err/s: 0.00 reconn/s: 0.00
    [ 20s ] thds: 4 tps: 1210.97 qps: 24219.40 (r/w/o: 16958.58/4838.88/2421.94) lat (ms,95%): 4.03 err/s: 0.00 reconn/s: 0.00
    [ 21s ] thds: 4 tps: 1073.05 qps: 21452.95 (r/w/o: 15010.66/4296.19/2146.09) lat (ms,95%): 5.77 err/s: 0.00 reconn/s: 0.00
    [ 22s ] thds: 4 tps: 967.82 qps: 19359.40 (r/w/o: 13552.48/3871.28/1935.64) lat (ms,95%): 10.09 err/s: 0.00 reconn/s: 0.00
    [ 23s ] thds: 4 tps: 1085.46 qps: 21727.25 (r/w/o: 15209.47/4346.85/2170.93) lat (ms,95%): 5.09 err/s: 0.00 reconn/s: 0.00
    [ 24s ] thds: 4 tps: 1122.36 qps: 22435.19 (r/w/o: 15709.04/4481.43/2244.72) lat (ms,95%): 5.99 err/s: 0.00 reconn/s: 0.00
    [ 25s ] thds: 4 tps: 1127.14 qps: 22562.77 (r/w/o: 15784.94/4523.56/2254.28) lat (ms,95%): 5.88 err/s: 0.00 reconn/s: 0.00
    [ 26s ] thds: 4 tps: 835.94 qps: 16684.70 (r/w/o: 11685.09/3327.74/1671.87) lat (ms,95%): 6.91 err/s: 0.00 reconn/s: 0.00
    [ 27s ] thds: 4 tps: 1098.12 qps: 21981.42 (r/w/o: 15388.69/4396.48/2196.24) lat (ms,95%): 5.47 err/s: 0.00 reconn/s: 0.00
    [ 28s ] thds: 4 tps: 1169.17 qps: 23369.35 (r/w/o: 16351.34/4679.67/2338.33) lat (ms,95%): 5.67 err/s: 0.00 reconn/s: 0.00
    [ 29s ] thds: 4 tps: 1072.81 qps: 21446.19 (r/w/o: 15013.33/4287.24/2145.62) lat (ms,95%): 7.43 err/s: 0.00 reconn/s: 0.00
    [ 30s ] thds: 4 tps: 1122.04 qps: 22453.87 (r/w/o: 15723.61/4486.17/2244.09) lat (ms,95%): 5.37 err/s: 0.00 reconn/s: 0.00
    SQL statistics:
        queries performed:
            read:                            474012
            write:                           135432
            other:                           67716
            total:                           677160
        transactions:                        33858  (1128.35 per sec.)
        queries:                             677160 (22566.95 per sec.)
        ignored errors:                      0      (0.00 per sec.)
        reconnects:                          0      (0.00 per sec.)
    
    General statistics:
        total time:                          30.0052s
        total number of events:              33858
    
    Latency (ms):
             min:                                    1.83
             avg:                                    3.54
             max:                                  244.44
             95th percentile:                        4.65
             sum:                               119932.66
    
    Threads fairness:
        events (avg/stddev):           8464.5000/865.85
        execution time (avg/stddev):   29.9832/0.00
    
    
    sysbench mysql OLTP new summary:
    sysbench oltp_read_write.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-storage-engine=InnoDB --time=30 --threads=4 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql run
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    threads: 4
    read: 474012
    write: 135432
    other: 67716
    total: 677160
    transactions/s: 1128.35
    queries/s: 22566.95
    time: 30.0052s
    min: 1.83
    avg: 3.54
    max: 244.44
    95th: 4.65
    
    | mysql sysbench | sysbench | threads: | read: | write: | other: | total: | transactions/s: | queries/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | oltp_read_write.lua | 1.0.15 | 4 | 474012 | 135432 | 67716 | 677160 | 1128.35 | 22566.95 | 30.0052s | 1.83 | 3.54 | 244.44 | 4.65 |
    
    sysbench,sysbench,threads,read,write,other,total,transactions/s,queries/s,time,min,avg,max,95th
    oltp_read_write.lua,1.0.15,4,474012,135432,67716,677160,1128.35,22566.95,30.0052s,1.83,3.54,244.44,4.65
    
    sysbench mysql cleanup database: sbt
    sysbench oltp_read_write.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-storage-engine=InnoDB --time=30 --threads=4 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql cleanup
    sysbench 1.0.15 (using bundled LuaJIT 2.1.0-beta2)
    
    Dropping table 'sbtest1'...
    Dropping table 'sbtest2'...
    Dropping table 'sbtest3'...
    Dropping table 'sbtest4'...
    Dropping table 'sbtest5'...
    Dropping table 'sbtest6'...
    Dropping table 'sbtest7'...
    Dropping table 'sbtest8'...
    
     
    Last edited: Sep 8, 2018
  6. eva2000

    eva2000 Administrator Staff Member

    40,625
    9,017
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +13,884
    Local Time:
    6:50 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x

    Centmin Mod pure-ftpd failed to start



    pure-ftpd seems to have been installed in both basic medium and standard medium plans, but isn't able to start the service due to retrictions of being Proxmox/LXC container and the Linux Kernel used I think. The Linux Kernel used might be missing the setting CONFIG_SECURITY_CAPABILITIES=y
    Code (Text):
    systemctl status pure-ftpd.service
    ● pure-ftpd.service - Pure-FTPd FTP server
       Loaded: loaded (/usr/lib/systemd/system/pure-ftpd.service; enabled; vendor preset: disabled)
       Active: failed (Result: exit-code) since Sat 2018-09-08 11:14:21 UTC; 48min ago
      Process: 292835 ExecStart=/usr/sbin/pure-config.pl /etc/pure-ftpd/pure-ftpd.conf --daemonize (code=exited, status=252)
    
    Sep 08 11:14:21 host.domain.com systemd[1]: Starting Pure-FTPd FTP server...
    Sep 08 11:14:21 host.domain.com systemd[1]: pure-ftpd.service: control process exited, code=exited status=252
    Sep 08 11:14:21 host.domain.com systemd[1]: Failed to start Pure-FTPd FTP server.
    Sep 08 11:14:21 host.domain.com systemd[1]: Unit pure-ftpd.service entered failed state.
    Sep 08 11:14:21 host.domain.com systemd[1]: pure-ftpd.service failed.
    

    check the log output with error = host.domain.com pure-ftpd[297358]: ([email protected]?) [ERROR] Unable to switch capabilities : Operation not permitted
    Code (Text):
    journalctl -xe --no-pager | tail -30
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    --
    -- Unit pure-ftpd.service has begun starting up.
    Sep 08 12:04:21 host.domain.com pure-ftpd[297358]: ([email protected]?) [ERROR] Unable to switch capabilities : Operation not permitted
    Sep 08 12:04:21 host.domain.com systemd[1]: pure-ftpd.service: control process exited, code=exited status=252
    Sep 08 12:04:21 host.domain.com systemd[1]: Failed to start Pure-FTPd FTP server.
    -- Subject: Unit pure-ftpd.service has failed
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    --
    -- Unit pure-ftpd.service has failed.
    --
    -- The result is failed.
    Sep 08 12:04:21 host.domain.com systemd[1]: Unit pure-ftpd.service entered failed state.
    Sep 08 12:04:21 host.domain.com systemd[1]: pure-ftpd.service failed.
    Sep 08 12:05:01 host.domain.com systemd[1]: Started Session 821 of user root.
    -- Subject: Unit session-821.scope has finished start-up
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    --
    -- Unit session-821.scope has finished starting up.
    --
    -- The start-up result is done.
    Sep 08 12:05:01 host.domain.com systemd[1]: Starting Session 821 of user root.
    -- Subject: Unit session-821.scope has begun start-up
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    --
    -- Unit session-821.scope has begun starting up.
    Sep 08 12:05:01 host.domain.com CROND[297367]: (root) CMD (/usr/lib64/sa/sa1 1 1)
    

    Googling also confirms the issue needing a source recompile of pure-ftpd ! instead of Centmin Mod yum package installed pure-ftpd at
    Not a problem if you plan to use Centmin Mod 123.09beta01 or newer with root user and SFTP. But if you want to use pure-ftpd and virtual FTP user for each Nginx vhost, then using Skysilk with LXC container based VPSes will be a problem.

    FYI, I had no problems when i tested Ubuntu LXD containers on ssdnodes VPS for my LEMP stack comparison benchmarks. Pure-ftpd restarts though there's a message for pure-ftpd.service: Failed to set invocation ID on control group /system.slice/pure-ftpd.service, ignoring: Operation not permitted which are normal according to LXC/LXD main developer when I asked way back at Centos 7.5 container operation not permitted?
    On LXD container based Centmin Mod 123.09beta01 install on ssdnodes's KVM VPS which uses Ubuntu LXD - status = active and running
    Code (Text):
    systemctl status pure-ftpd
    ● pure-ftpd.service - Pure-FTPd FTP server
       Loaded: loaded (/usr/lib/systemd/system/pure-ftpd.service; enabled; vendor preset: enabled)
       Active: active (running) since Sat 2018-09-08 07:53:33 UTC; 4h 41min ago
      Process: 355 ExecStart=/usr/sbin/pure-config.pl /etc/pure-ftpd/pure-ftpd.conf --daemonize (code=exited, status=0/SUCCESS)
     Main PID: 623 (pure-ftpd)
        Tasks: 1 (limit: 4915)
       CGroup: /system.slice/pure-ftpd.service
               └─623 pure-ftpd (SERVER)
    
    Sep 08 07:53:24 cmm systemd[1]: pure-ftpd.service: Failed to reset devices.list: Operation not permitted
    Sep 08 07:53:24 cmm systemd[1]: pure-ftpd.service: Failed to set invocation ID on control group /system.slice/pure-ftpd.service, ignoring: Operation not permitted
    Sep 08 07:53:24 cmm systemd[1]: Starting Pure-FTPd FTP server...
    Sep 08 07:53:32 cmm systemd[1]: pure-ftpd.service: PID file /var/run/pure-ftpd.pid not readable (yet?) after start: No such file or directory
    Sep 08 07:53:33 cmm systemd[1]: Started Pure-FTPd FTP server.
    

    Kernel used on LXD container's CentOS 7 OS with ssdnodes's Ubuntu 18.0.4
    Code (Text):
    uname -r
    4.15.0-22-generic
    
     
    Last edited: Sep 8, 2018