Skip to main content

Questions tagged [load-testing]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
39 views

Why load test on postgres database getting worse result while changing default parametes to get better performance?

I want to have a load test on my postgresql database named dvdrental.While using postgres default parameters in postgresql.conf file , my database performance is pretty better than other situations.My ...
mahdi's user avatar
  • 1
4 votes
1 answer
206 views

Performance Regression Testing / Load Testing on SQL Server

What tools or best practices exist to demonstrate a new server instance is "as capable" as an older one? We're moving from an EC2 hosted instance of MS SQL Server to an RDS instance, and ...
Iridescent's user avatar
0 votes
1 answer
57 views

How to loadtest network throughput between two systems when one is a cloud database server?

I am troubleshooting query performance issues when running large queries against an AWS Redshift cluster. The majority of the time is spent transferring the data over the network and processing the ...
Appleoddity's user avatar
0 votes
1 answer
1k views

Replication testing is a Materialized view Refresh equivalent of continious update?

In my database I have the following a materialized view named materialized_view_test and the data are being feeded from 3 tables: select * from a_table join b_table on b_table.a_id=a_table.id ...
Dimitrios Desyllas's user avatar
2 votes
0 answers
318 views

How I can find out which postgresql I am connected into when behind a load balancer?

I have the following database replication setup: As you can see I do a master-slave replication and I use aload balancer in order to connect into read-only replicas. So I want to test this setup, ...
Dimitrios Desyllas's user avatar
1 vote
1 answer
382 views

How to determine the root cause of a performance spike during a heavy load on DB2?

I am testing the performance of an application that links to a DB2 database engine at the back end. Looking at the transaction timer logs, I see that on the 37'th minute into the test run, ...
DraxDomax's user avatar
  • 129
1 vote
2 answers
1k views

mysql performance test

We are planing to test the performance of the new DB server. For that we have the below the plan: get production sql queries replay those sql queries against the different DB I was planing to use pt-...
Trying's user avatar
  • 203
1 vote
1 answer
2k views

MongoDB query execution time

I'm using Locustio service as load testing tool for my app. Without details, I'm using the same aggregation query with simulated 100 users, in this case RPS (requests per second) is about 20. In first ...
vadimb's user avatar
  • 125
0 votes
2 answers
1k views

Mysql show no more than 5 concurrent connection

I'm performing some load tests on my brand new server Apache/PHP/Mysql (Bitnami LAMP stack ). I'm using AWS with 1 EC2 instance behind a loadBalancer. At the moment I'm using loader.io for the tests. ...
Stefano Giacone's user avatar
0 votes
1 answer
211 views

Is it possible to generate workload for hammerora (hammerdb for oracle) from AWR tables?

I'm trying to generate workload from our production databases but rather than running a trace file in production, I would prefer using the AWR tables since we have a license for it. Is it possible? ...
Nicolas de Fontenay's user avatar