Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Get exact queries for deletes and updates during oltp testings #553

Open
FK510 opened this issue Dec 20, 2024 · 0 comments
Open

Get exact queries for deletes and updates during oltp testings #553

FK510 opened this issue Dec 20, 2024 · 0 comments

Comments

@FK510
Copy link

FK510 commented Dec 20, 2024

Unable to get exact amount of queries per seconds when i am trying to run a oltp test,

For ex:
Looking to get the output to be with fixed queries as below, how do i get this, i tried modifying various variables but none worked,

20,000 Selects,
2000 inserts,
500 updates,
500 deletes.

Also i want my output to show updates,deletes,commits separately like selects and inserts and not shown as Others instead,
Here is how i want in my output to look like,

Running the test with following options:
Number of threads: 8
Report intermediate results every 10 second(s)
Initializing random number generator from current time

Initializing worker threads...

Threads started!

[ 10s ]thds: 8 tps: 145.77 qps: 23000.00(r/w/o: 20000.00/2000.00/500.00/500.00) lat (ms,95%): 65.65 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: *******
write: ******
delete: *****
update: *****
total: ********
transactions: **** (145.79 per sec.)
queries: ******** (24347.35 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)

Can anyone help creating what files to modify to get the output or create a branch with changes. It will be great. Thanks

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant