Hologram Posted June 2, 2009 Share Posted June 2, 2009 Hi all, we have got following email from the hosting company: >Hi, >your database **** overloads our server mysql***, maybe >due to wrong table arrangement - 85% of all queries waiting for writing >fall on your database. >Your database on our server mysql*** has over 80% of all time lock tables. Anyone experienced in this issue? The average number of queries per script is about 30. Sometimes it's over 45. It is too much? I know there is double calling to mysql_connect within the script, so it is possible there are two connections into database within the script. I am trying to resolve it. Can it cause this problem? We are using database abstract layer from phpbb to access database, so I assume there wouldn't be any problem in it. Number of visits is quite small, about 350 daily. Any help appreciated, thanks. Quote Link to comment https://forums.phpfreaks.com/topic/160612-database-overloading/ Share on other sites More sharing options...
fenway Posted June 6, 2009 Share Posted June 6, 2009 Nowhere near enough info... read the main sticky on this board. At the very least, we'll need some example queries that are causing issues and their table structures, etc. Quote Link to comment https://forums.phpfreaks.com/topic/160612-database-overloading/#findComment-850500 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.