Google Cloud's C3D Instances Provide Strong Performance Value For PingCAP's TiDB

Written by Michael Larabel in Software on 28 March 2024 at 05:00 AM EDT. Page 2 of 2. 1 Comment.
TiDB Community Server benchmark with settings of Test: oltp_read_write, Threads: 32. c3d-standard-60 was the fastest.
TiDB Community Server benchmark with settings of Test: oltp_read_write, Threads: 64. c3d-standard-60 was the fastest.

With the OLTP sysbench read/write test of TiDB, the EPYC Genoa-based GCE C3D VMs immediately delivered excellent performance - similar to the prior C3D benchmarks on Phoronix.

TiDB Community Server benchmark with settings of Test: oltp_read_write, Threads: 128. c3d-standard-60 was the fastest.

With the TiDB benchmarks using sysbench, the C3D EPYC Genoa instance easily proved to be the most capable of the GCE VMs tested in the ~60 vCPU range. With the OLTP read/write test at 128 threads, the C3D standard instance was 24% faster than the next fastest type tested, the Tau T2D powered by AMD EPYC Milan where each vCPU is a physical core.

TiDB Community Server benchmark with settings of Test: oltp_read_write, Threads: 128. c3d-standard-60 was the fastest.

The general purpose N2D-standard-64 powered by AMD EPYC Milan did offer the best value in some of the database benchmarks followed by the new C3D instances.

TiDB Community Server benchmark with settings of Test: oltp_read_write, Threads: 256. c3d-standard-60 was the fastest.
TiDB Community Server benchmark with settings of Test: oltp_point_select, Threads: 64. c3d-standard-60 was the fastest.
TiDB Community Server benchmark with settings of Test: oltp_update_index, Threads: 64. c3d-standard-60 was the fastest.
TiDB Community Server benchmark with settings of Test: oltp_update_index, Threads: 64. c3d-standard-60 was the fastest.
TiDB Community Server benchmark with settings of Test: oltp_point_select, Threads: 128. c3d-standard-60 was the fastest.
TiDB Community Server benchmark with settings of Test: oltp_point_select, Threads: 128. c3d-standard-60 was the fastest.
TiDB Community Server benchmark with settings of Test: oltp_point_select, Threads: 512. c3d-standard-60 was the fastest.
TiDB Community Server benchmark with settings of Test: oltp_point_select, Threads: 512. c3d-standard-60 was the fastest.

Across the various sysbench tests carried out on TiDB, the Google Cloud C3D performance was performing best of the tested instances.

TiDB Community Server benchmark with settings of Test: oltp_update_index, Threads: 512. c3d-standard-60 was the fastest.
TiDB Community Server benchmark with settings of Test: oltp_update_non_index, Threads: 512. c3d-standard-60 was the fastest.

Not that I was that surprised given all of my AMD EPYC 9004 series benchmarking over the past year, for those who want to harness the power of the EPYC Zen 4 processors in the cloud, the GCE C3D VMs perform very well for TiDB as well as other database and server workloads.

Geometric Mean Of All Test Results benchmark with settings of Result Composite, TiDB C3D GCE Benchmarks. c3d-standard-60 was the fastest.

The C3D-standard-60 instance offered around 21% better performance and value than similar ~60 vCPU-sized instances tested on Google Cloud. Those who wish to learn more about TiDB can do so as well at PingCAP.com.

If you enjoyed this article consider joining Phoronix Premium to view this site ad-free, multi-page articles on a single page, and other benefits. PayPal or Stripe tips are also graciously accepted. Thanks for your support.

Related Articles
About The Author
Michael Larabel

Michael Larabel is the principal author of Phoronix.com and founded the site in 2004 with a focus on enriching the Linux hardware experience. Michael has written more than 20,000 articles covering the state of Linux hardware support, Linux performance, graphics drivers, and other topics. Michael is also the lead developer of the Phoronix Test Suite, Phoromatic, and OpenBenchmarking.org automated benchmarking software. He can be followed via Twitter, LinkedIn, or contacted via MichaelLarabel.com.