一台服务器每秒可以处理多少个MySql查询? [英] How many MySql queries/second can be handled by a server?

问题描述

我已经开始开发浏览器(数据库)游戏.我的问题是一个常规托管可以处理多少个查询(当我指的是常规托管时，我的意思是您每月可以找到约7 $的共享托管). 至于查询，没有什么复杂的(简单的SELECT和WHERE操作).

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).

那么...? 10个? 100? 10000?

So... ? 10? 100 ? 10000?

推荐答案

Yoshinori Matsunobu in one of his articles claims 105,000 queries per second using SQL, and 750,000 queries per second using native InnoDB API.

所有查询都是简单的PK查找.

All queries are simple PK lookups.

在共享主机上，这些数字当然会低得多.当然，确切多少取决于共享托管.

On a shared hosting these numbers will of course be much lower. How much exactly of course depends on the shared hosting.

这篇关于一台服务器每秒可以处理多少个MySql查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！