How many MySql queries/second can be handled by a server?

mysql select optimization database-performance
XCS picture XCS · Dec 30, 2010 · Viewed 21.1k times · Source

I've started developing a browser (database) game. My question is how many queries can a regular hosting handle (when I mean regular, I mean a shared hosting you cand find for about 7$/month). As for the queries, nothing complicated (simple SELECT and WHERE operations).

So... ? 10? 100 ? 10000?

Answer

Michael Goldshteyn picture Michael Goldshteyn · Dec 30, 2010

This is completely dependant on the server hardware, it's caching ability and configuration, and the type of hardware it uses for non-volatile storage (e.g., a RAID array of hard drives with spindles or SSDs?), not to mention the type of query and database being queried, including:

  • Number of joins
  • Indexes
  • Number of rows in the tables queried
  • Size of the result set
  • Concurrent load
  • etc...

Without knowing all of these factors, it is impossible to estimate performance. The best estimate comes from actual profiling, performed under normal operating conditions with the type of queries that will actually be presented.

Related questions

Using index, using temporary, using filesort - how to fix this?

I'm working on a event tracking system which uses a handful of lookup tables as well as the primary logging table. In a report I'm writing, an object can be selected to view statistics against. The interface shows all objects …

Read More
SELECT COUNT() vs mysql_num_rows();

I have a large table (60+) millions of records. I'm using PHP script to navigate through this table. PHP script (with pagination) loads very fast because: The table engine is InnoDB thus SELECT COUNT() is very slow and mysql_num_rows() …

Read More
MySQL - UPDATE query based on SELECT Query

I need to check (from the same table) if there is an association between two events based on date-time. One set of data will contain the ending date-time of certain events and the other set of data will contain the …

Read More