How to practically check whether server can handle many MySQL connections simultaneously


Problem :

I am new at server-side scripting. On my website, I have MySQL database of users. My website is supposed to host an event where all the users will be logging in and answering some questions. So there will be a lot of MySQL queries submitted, to check whether what they have entered is correct or not. And in the event, the users can submit again and again until the answer is correct.

My question is, instead of going into the specifications of server to estimate the maximum concurrent MySQL connections, is there a way to practically get that? What I mean is, is there some way (some function or algorithm), which will put similar load on the server as number of users submitting queries simultaneously. Sort of like a test run. And in the test run, I should be able to know the maximum concurrent MySQL connections that the server can handle without crashing or slowing down.

I tried to understand mysqlslap, but I find it very difficult to understand. I have also visited this link, but that is on linux server. I am working with phpMyAdmin + MySQL. So is there any easy tutorial for phpMyAdmin somewhere? Or maybe someone can mention what to do shortly. Please consider that I am a newbie at this.



Solution :

You seem to be asking two different kind of questions; what the maximum number of simultaneous mysql connections is and how you can stress-test your server.

The answer to the first question is easy, there is a mysql setting called max_connections that sets the maximum number of connections and you can check that in phpMyAdmin by going to the Variables tab and searching for max connections.

If you need to change that value you need to look for your config file. That can be for example /etc/my.cnf but that depends on the server and whether you are using MariaDB or MySQL.

When you stress-test your server, mysql will probably not be the problem, but things like memory, etc.


Mysql Tutorials

Mysql Howto..

How to combine 100 thousand MySQL rows

How to submit forms with answers in each different result of a 'select mysql query' and insert the answers in mysql database

how to hide duplicate record in mysql?

How do you handle complex data structures (OOP) in a mySQL DB?

How to design DB for question-answer (MySql)

How to Disable Html codes in chat script

How to Display Image which is stored on the server referenced through MySQL

how to combine tables with 1 to many relationship into 1 line of record

In php how to display mysql results?

How to select distinct rows for avg aggragate function in mysql when using joins?

MySql-How to parse date which is attached with another string

MySQL - How do I to select data from a table, ordering by the difference between the values of two columns?

How to take dump of serverdb in mysql

how to remove leading and trailing slash in mysql

How to produce the result as a JSON string in php [closed]

How to combine two independent mysql count query result in a single view

How to save uploaded image names in MySQL database

How to filter DELETE statement using another table's value in MySQL?

mysql how to merge similar records within a table

How would Sphinx Search index / handle JSON files?

How to Avoid Lock wait timeout exceeded exception.?

How to build my JSON data with only one MySQL request?

how to prevent from getting wrong ID

how to compare based on Date with DATETIME field of MYSQL?

how to trigger MySQL query

How to select based on different column data

how to select table with limit and return the outside limit into record named 'other' with MYSQL

How to check not equalto in Mysql?

How to truncate a table using Doctrine?

How to know if MySQLnd is the active driver?