Perform Performance testing for PSP using sysbench on smblade1.

Description

Add a new jenkins job to automate Performance testing for PDP.

How to document

None

How to test

None

Activity

Show:

naeem.akhter January 27, 2025 at 11:24 AM

Setup and automation is in place as per current scope and understanding.

naeem.akhter January 27, 2025 at 11:23 AM

Now we need to integrate the daily results with InfluxDB and Grafana to have a visual representation of results on daily basis. For this I will open a new ticket.

For improvements to existing automated setup for PSP Performance Testing, we will revisit the configuration and setups once we have data and results for few weeks available to us in for Grafana dashboard and results.

So marking this story as done.

naeem.akhter January 27, 2025 at 11:18 AM

We had setup daily jobs for performance testing of on 10.30.2.5 (smblade1). As of now, daily jobs using installation from nightly builds are running for following configs.

REPORT_INTERVAL=10 TABLE_SIZE=100000 TABLE_COUNT=24 RUN_TIME=1800 THREADS_NUM=(30) SYSBENCH_WORKLOADS=("oltp_read_write" "oltp_write_only" "oltp_read_only" "oltp_insert" "oltp_delete") ACCESS_METHODS=("heap" "tde_heap")

naeem.akhter January 14, 2025 at 2:22 PM

We has a little demo and a discussion in TDE weekly meeting to see what have been done so far, and whether this is the right approach moving forward to performance tests. So this is what we agreed upon.

  1. We won’t use AWS VM/images for these performance tests, as results won’t be consistent and realistic.

  2. We would be using dedicated hardware, that is we are already using for MySQL. (called something like Blade Server).

  3. Jenkins will still be used for launching and kickoff. Maybe be a periodic automated job or on demand.

  4. pgbenach shouldn’t be used for these tests anymore, instead we will go for Sysbench as it fulfills our requirements.

I will coordinate with Zsolt, for setting up this for PG just like they did it for MySQL.

Kai Wagner January 6, 2025 at 10:14 AM

What’s the state here?

Done

Details

Assignee

Reporter

Labels

Components

Sprint

Priority

Smart Checklist

Created November 4, 2024 at 1:07 PM
Updated January 27, 2025 at 11:24 AM
Resolved January 27, 2025 at 11:24 AM

Flag notifications