hello I have a website which uses a invisionboard forum and is hosted on a Pentium 4 2.4Ghz, 1GB RAM . The website has around 25K members and the database size is almost around 230 MB by now . there are no other sites hosted on this server . BUt many times recently the database is failing . When i contacted the datacentre they said , it is because of too many multiple http connections at the same time . What could be a possible remedy for this ? Should the RAM be increases ? Should the processor be a higher one ? is there any mysql optimization for which it is failing because i have seen much bigger sites hosted using Invisionboard and i dont think it is because of Invisionboard
1st thing is to make sure database is checked and optimized (simple mySQL commands). 2nd, make sure there aren't any excessively slow queries that should be fixed. 3rd step is to increase the RAM.
first one , i of course do ... i will increase or decrease the time gap now more any advice on how to find which queries are slow ?
You might consider tracking the time it takes for each query and then averaging them out to determine whichever takes the most time. Basically start timer at beginning of query, end at the end, subtract the difference and insert into a logging table and then do the averages.