Geek Answers Handbook

How to calculate transactions per second per second and database growth

I need to know about calculating project database load. Suppose the following events fire when the insert is completed.

  • Insert new record into table1
  • Get uniqueid from pasted and paste uniqueid into another table, with some other options
  • table1 is a cumulative information support, therefore it select count(1) from table1 where anotherColumn = xxyyxleaves
  • After receiving the counting result, update another table using this counter.

I need to calculate how many transactions are open and what database loading is at 100 or 1000 times when this script is run at the same time.

Thanks...

+5
source share
4 answers

From your question, I understand that you want to get statistics regarding the number of transactions per second (TPS). These are standard statistics about the capabilities of your computer infrastructure and database servers. If I understood correctly, this mathematical formula could help.

TPS = number of transactions / amount (each transaction time in seconds)

This will let you know how many transactions per second looked into your server over the elapsed time (period of the DateTime interval)

On the other hand, if you want to calculate the server load based on the number of users and then simulate it, you might want to find specialized loadTest tools.

Let me know if I answer your question correctly or let me know what I missed in your question.

EDIT 1 :

EDIT 2 : QaLoad de Microfocus
JAVA-: Apache JMeter
, , -, SSL, Kerberos, SOAP, XML .., .

0

, Spotlight, , , x .

, , , , , .

0

, . , .

.

, , , db , , , , , .

0

; , , , .., . , min 555 max 2000 sql, . , , , ...

...

0

More articles:


All Articles