itsliamoco Posted July 27, 2014 Share Posted July 27, 2014 (edited) Let's say I have 1 table and 100 rows in this table. The table is simple and only contains an Auto Increment ID field and a load_count field. Every time a web page is loaded this query is executed and load_count is increased by 1 ... UPDATE table_name SET load_count = load_count + 1 WHERE ID = $number How can I test the limit my server can handle this query per second. Will I run into errors at 10 page loads per second or at 1000? How can I emulate 'x' number of page loads per second and record results for how MySQL performs? Edited July 27, 2014 by itsliamoco Quote Link to comment https://forums.phpfreaks.com/topic/290133-testing-mysql-updates-per-second-limit/ Share on other sites More sharing options...
vpalukuru9 Posted July 30, 2014 Share Posted July 30, 2014 Mysql has a utility called mysqlslap which can be used to test the load of the server. You can check more details about this at http://dev.mysql.com/doc/refman/5.1/en/mysqlslap.html Quote Link to comment https://forums.phpfreaks.com/topic/290133-testing-mysql-updates-per-second-limit/#findComment-1486452 Share on other sites More sharing options...
Psycho Posted July 30, 2014 Share Posted July 30, 2014 FYI: You should have logs for your webserver that contain records of every page request. Quote Link to comment https://forums.phpfreaks.com/topic/290133-testing-mysql-updates-per-second-limit/#findComment-1486483 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.