ProblemHelpPlease Posted March 2, 2011 Share Posted March 2, 2011 Is it possible for a PHP script to be written that can create a log (say every second over 12 hours), that would record the current number of mysql connections to a server.I have been using the Connection Health section of MySQL Administrator but this does not store the information or assign a timecode to each entry. Link to comment Share on other sites More sharing options...
birbal Posted March 2, 2011 Share Posted March 2, 2011 i think you can add such scripts after each mysql_connect (on successfull connect) which will write into a file (xml file) using file_put_contents or any file handling functionsafter storing the log i think it will be easy to manupulate how many connection has been established in certain amount of time. Link to comment Share on other sites More sharing options...
ProblemHelpPlease Posted March 2, 2011 Author Share Posted March 2, 2011 I can see that it may work that way but would take a while to retro fit to the site, and I am looking for connections to the enitire server which has multiple sites. Link to comment Share on other sites More sharing options...
ProblemHelpPlease Posted March 2, 2011 Author Share Posted March 2, 2011 Problem solved, I have managed to work out how to write a PHP script to do this. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.