Questions tagged [load-testing]
The load-testing tag has no usage guidance.
10
questions
0
votes
0
answers
18
views
Best way to model load test for performace requirements of database
For instance, imagine this requirement for a certain query in the database:
The database needs to handle L of those queries a year.
a% of the queries need to have less than 30ms
What is the best way ...
4
votes
1
answer
175
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 ...
- 41
0
votes
1
answer
36
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 ...
- 294
0
votes
1
answer
856
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
...
2
votes
0
answers
237
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, ...
1
vote
1
answer
335
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, ...
- 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-...
- 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 ...
- 125
0
votes
2
answers
988
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. ...
- 111
0
votes
1
answer
197
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?
...
- 1,873