PatrickE Posted April 29, 2007 Share Posted April 29, 2007 Alright, I upgraded my server to MySQL 5.0.37 to take advantage of the new query profiling feature. It appears to me that the "init" stage seems to be taking the longest. Here is the profile of an update query to my players table. Status Duration checking permissions 0.00008500 Opening tables 0.00001600 System lock 0.00004300 Table lock 0.00001400 init 7.72684800 Updating 0.00006300 end 0.00014500 query end 0.00003400 freeing items 0.00001400 closing tables 0.00001500 logging slow query 0.00001400 cleaning up 0.00001200 Do any of you have an idea of what I can do to lower the time for it? Quote Link to comment https://forums.phpfreaks.com/topic/49210-interpreting-query-profiling-data/ Share on other sites More sharing options...
bubblegum.anarchy Posted April 30, 2007 Share Posted April 30, 2007 Upgrade the server processor. Quote Link to comment https://forums.phpfreaks.com/topic/49210-interpreting-query-profiling-data/#findComment-241314 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.