I am looking to store information in a database table that will be constantly receiving and sending data back and forth to an iPhone App/Python Socket. The problem is, if I were to have my own servers, what is the maximum queries I can sustain?
我希望将信息存储在一个数据库表中，该表将不断地接收和发送数据到iPhone应用程序/Python套接字中。问题是，如果我有自己的服务器，我能支持的最大查询是什么?
The reason I'm asking is because if I were to have thousands of people using the clients and multiple queries are going a second, I'm afraid something will go wrong.
我之所以问这个问题，是因为如果我有成千上万的人使用客户端，并且有多个查询在进行，我担心会出现问题。
Is there a different way of storing user information without MySQL? Or is MySQL OK for what I am doing?
没有MySQL还有其他存储用户信息的方式吗?或者MySQL可以满足我的要求吗?
Thank you!
谢谢你！
2 个解决方案
#1
1
Mysql have sysvar_max_connections system parameter that is handling this.
Mysql有sysvar_max_connections系统参数来处理这个问题。
#2
1
The maximum load is going to vary based on the design of your application and the power of the hardware that you put it on. A well designed application on reasonable hardware will far outperform what you need to get the project off the ground.
最大负载将根据应用程序的设计和所使用的硬件的功率而变化。在合理的硬件上设计良好的应用程序将远远超过项目启动所需的性能。
If you are unexpectedly successful, you will have money to put into real designers, real programmers and a real business plan. Until then, just have fun hacking away and see if you can bring your idea to reality.
如果你获得了意想不到的成功，你就有足够的资金投入真正的设计师、真正的程序员和真正的商业计划。在那之前，只要有有趣的黑客行为，看看你能不能把你的想法变成现实。
#1
1
Mysql have sysvar_max_connections system parameter that is handling this.
Mysql有sysvar_max_connections系统参数来处理这个问题。
#2
1
The maximum load is going to vary based on the design of your application and the power of the hardware that you put it on. A well designed application on reasonable hardware will far outperform what you need to get the project off the ground.
最大负载将根据应用程序的设计和所使用的硬件的功率而变化。在合理的硬件上设计良好的应用程序将远远超过项目启动所需的性能。
If you are unexpectedly successful, you will have money to put into real designers, real programmers and a real business plan. Until then, just have fun hacking away and see if you can bring your idea to reality.
如果你获得了意想不到的成功，你就有足够的资金投入真正的设计师、真正的程序员和真正的商业计划。在那之前，只要有有趣的黑客行为，看看你能不能把你的想法变成现实。