how to calculate TPS of insert/update and delete, IO tps, network tps

Comments

• Options

  Pravesh

  June 2016

   

  Did you check system tables like "dc_requests_issued", "dc_io_info_by_second" & "dc_network_info_by_second".

   

  Or have you already checked these and it didn't help?

  0
• Options

  Rajzz

  June 2016

  Thanks for the pravesh,

   

  Yes i checked these tables. But I am unawarw that which column to consider in both io_info and network_info tables. 

  0
• Options

  Pravesh

  June 2016

  I think you will need columns "total_read_bytes_start_value", "total_read_bytes_end_value" and "start_time", "end_time".

   

  Difference of "total_read_bytes_end_value" and "total_read_bytes_start_value" for a time duration (end_time - start_time) should give you total read bytes.

   

  Similarly, you can calculate total written bytes (total_written_bytes_end_value and total_written_bytes_start_value).

   

  For network usage, similar columns would be "tx_bytes_*_value" and "rx_bytes_*_value".

   

  You can also refer to system views "io_usage" and "network_usage" which are built upon the same system tables and simple to understand. However, they will give you minute wise information.

   

  Hope this helps.

   

   

   

  0