Question: Consider a database system that serves transactions of 2 distinct kinds. Each query transaction requires 3 5 ms of CPU processing and reading 2 3

Consider a database system that serves transactions of 2 distinct kinds. Each query transaction requires 35 ms of CPU processing and reading 230 blocks from disk (where each block occupies 4KB, and the disk can deliver 100 MB/s). Each update transaction requires 0.3ms of CPU processing, reading 1 block from disk, and it also requires sending a log record to a dedicated archival storage, an operation which occupies this resource for 30 ms. Each client generates transactions without any think time between one response and the next request. (a) Suppose that each client generates requests for which the transaction mix consists of 25% update transactions and 75% query transactions. If there are 3 clients, use the lowload bounds to estimate the throughput and latency obtained. (b) Still with 25% update transactions, what is the largest number of clients for which average response time will be below 2s?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!