mysql, simultaneous queries

Navigation
-2

how many queries does mysql support simultaneously?

I know that the connection is not the same as simultaneous consultation, and that if there are 3,000 users on a website, it does not even remotely mean that the 3,000 make a query at the same time, but I would like to know how many users can do for example an insert to a table "at the same time", could there be any conflict? If yes, if I have an alternative to this, for example save queries in a queue and execute them one by one.

If this depends on the hardware then if I require at least 15 simultaneous queries, what hardware do I require?

all the above for an online registration for example.

Greetings and thanks.

    
asked by Eduardo Valdez 14.09.2017 в 01:11
source

1 answer

0

This is not an answer in itself, but what you asked includes several different topics. Among those that I see one is cocurrency in databases and another is traffic in the web server (or load and balancing support), I suppose you have a web server, * otherwise ignore the information about this XD.

I leave you these links where you talk and explain the issue of concurrency in Databases: [ link

And here the topic of web traffic: - https: //es.wikipedia.org/wiki/Tr%C3%A1fico_web -

And here some traffic measurement tools: - https: //www.ciudadano2cero.com/alojamiento-web-trafico-herramientas -

I hope it serves you.

    
answered by 14.09.2017 / 02:22
source
How to convert an array of pairs [key, value] into an object? Error inputText