maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #05950
Increase in IOPS between 5.5 and 10.4
-
To:
"maria-discuss@xxxxxxxxxxxxxxxxxxx" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
-
From:
martin doc <db1280@xxxxxxxxxxx>
-
Date:
Thu, 12 Nov 2020 12:05:36 +0000
-
Accept-language:
en-AU, en-US
-
Arc-authentication-results:
i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none
-
Arc-message-signature:
i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=pf89UF9T8yuz3d/bINOZMLFEDp/vlVRsenWERxr4njA=; b=eHEfa9+PxKE0WzWGryxr0VG5+4+m4yG4AbX4zOumdITNZs8h5I1X4ORdip2nHyOeQJ7XQps2k9NC917B83ovMzd3GD/CdPxST32yM28uL6wuPMlgu0URarJBJ4LID+ffrgCN6iJy4Q0UjG42+Szr9CjMxam7o9YtxDU0CZJXcTE0IELE620rE/X7k3Vtvho2wFibDqP/RxMXU9AKm+2pgz+PESRex1PIyMKmmpfA+jWuhH/CGg3dg80ZVJIBOksVRE7QLp4W1mb4C3fbI5axRw0gUfu4AIEbP+39D40JgHOUUsYIArUmvLRy+jMCbwaIMYvF5rPb/NI/50QBIOJJGA==
-
Arc-seal:
i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=V2UbF8ldJQtBX2S3cggzpNgRRvR4As41fG+PoU1ocbLmmhS/vTaZ8bhfvBLsHO9TR3GDRX7Hv4ipZE+EoI12iklkU3+PJjfXoLxK+7ptTvns6SMBdlHxKiyAKRys7acTtOmhQJbGpY6a7gdi/Kx7IigJjvGkOC4tMgwRetsoqwyg3j4JJTP1uFTmKPIJkqsnCgRgpikJDK0O+7UT297J7mXhWN7mSwlP5OX4Q+ROytxEjmWfff38KuWTle+/GvdeSiDPsKxmDaLg7Sdeqg4MwH7raEsgDwdNXC/cEwPOBYxERjGSoCkVNRXHftNXJdexeUOrVL4QpsErQp/Bq2r1tg==
-
Thread-index:
AQHWuOvblCE2hMHE2EqxjSm3LOPn6g==
-
Thread-topic:
Increase in IOPS between 5.5 and 10.4
Recently upgraded a cluster of MariaDB servers from 5.5 to 10.4 and with grafana, I can see that all of the 10.4 instances use about 20% IOPS for the same workload. i.e, if inserting 100,000 rows took 200,000 IOPs with 5.5 then on 10.4 it takes 240,000.
Has anyone else noticed this?
Or know how to tune MariaDB to get better IOPS out of 10.4?
Follow ups
