Jump to content

MySQL TPS vs Number of concurrent users


Recommended Posts

Posted

Hi,

I would like to know how to equate concurrent users to TPS (transactions per second) as defined by sysbench in MySQL.

Eg, how many TPS does each 100 concurrent users require in IP.Board?

I just want to understand what kind of hardware I'm going to need for each x users.

Posted

This would vary greatly depending on what those users are doing.

If you can provide how many users you will have in a 15 minute window on your community, we can help guide you to your hardware needs.

Posted

This would vary greatly depending on what those users are doing.

If you can provide how many users you will have in a 15 minute window on your community, we can help guide you to your hardware needs.

Let's say 100 users in a 15 minute window. Mainly reading, 20% writes. I"m just looking for broad numbers. I understand what you're saying in general. Let's say I'm getting 100 TPS on MySQL using sysbench. How many users would that support?

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...