Perform Performance testing for PSP using sysbench on smblade1.
Description
How to document
How to test
is blocked by
Activity
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.
We won’t use AWS VM/images for these performance tests, as results won’t be consistent and realistic.
We would be using dedicated hardware, that is we are already using for MySQL. (called something like Blade Server).
Jenkins will still be used for launching and kickoff. Maybe be a periodic automated job or on demand.
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?
Details
Details
Assignee
Reporter
Labels
Components
Sprint
Priority
Parent
Smart Checklist
Open Smart Checklist
Smart Checklist

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