itsliamoco Posted July 27, 2014 Share Posted July 27, 2014 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? 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 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. 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
Archived
This topic is now archived and is closed to further replies.