Optimize website which runs on a script [ MySQL & PHP ]

It's a forum type of site I tried to ask the people that made the script and they've turned around and said
"hey its your host" I'm on a dedicated server and this site isn't even fetching that many users.

They clearly don't know customer support but I'm not going to sit here and cry about it.

I need someone that can optimise this site - this is what hostgator said to me about the problem:

Jesse H.:MySQL & PHP are causing the high load. It looks like you need to further optimize to prevent this.
Jesse H.: /home/zakhar/public_html/administrator/members_manage.php
Jesse H.: /home/zakhar/public_html/view.php
Jesse H.: /home/zakhar/public_html/account.php
Jesse H.:We are not trained on code optimization, so you will need to have someone evaluate the code and let them know it is causing your site to have high loads and run slowly or complete cause the site to time out.

Your goal would be to optimise it so it doesn't go around in circles like it is at the moment - to improve the speed.

Leave your message below, I'll select someone that seems up for the job. (Payments to be made through PP)

If I could take a look at the code I could probably speed it up. I've done a bunch of PHP script upgrades, and one thing I usually had to deal with was optimization.

Dante848 said:

If I could take a look at the code I could probably speed it up. I've done a bunch of PHP script upgrades, and one thing I usually had to deal with was optimization.

Click to expand...

Would you need access to the admin panel for this? I need someone that is confident they can take care of it.

I'm not a developer nor have I got any skills/experiences in that field. Cheers

have you tried it on another host to isolate that issue?

It really depends on the script, how interactive it is with the server and other files on it. If it is a shallow script, probably not.

Ask your host to enable MySQL slow log, if it isn't already, and have then provide you a copy. With this log you will be able to determine which queries are causing bottlenecks.

MrBlue said:

Ask your host to enable MySQL slow log, if it isn't already, and have then provide you a copy. With this log you will be able to determine which queries are causing bottlenecks.

Click to expand...

I'll do this right now =) thanks a lot!

sukataetumba said:

have you tried it on another host to isolate that issue?

Click to expand...

I went from WiredTree to Hostgator both packages were on a dedicated server costing more than $100 a month.

The fastest solution:

1. Enable more request on mysql, go on stackoverflow and read on how to do this. It will take a couple minutes
2. If you are actually getting too many request, consider doing a master-slave scenario. Clone your db to other servers to serve your db.

Optimizing the code really depends on a lot of things. The number of reads, can we some how cache it?

What script do you use?

melvinn said:

The fastest solution:

1. Enable more request on mysql, go on stackoverflow and read on how to do this. It will take a couple minutes
2. If you are actually getting too many request, consider doing a master-slave scenario. Clone your db to other servers to serve your db.

Optimizing the code really depends on a lot of things. The number of reads, can we some how cache it?

Click to expand...

Unfortunately I do not understand computer language.

Let's pretend BHW is the website we are talking about - every time a thread is clicked, the website takes 2-5minutes to load up the page it's confused it doesn't pick up that URL right away it must be doing something.

what do you mean by too many requests? right now the website gets a maximum of 10 people live mode on g.analytics - it used to take 400+ at one time without any problems? I don't know what happened. Same hosting, same plan .. everything.

Zakhar said:

Unfortunately I do not understand computer language.

Let's pretend BHW is the website we are talking about - every time a thread is clicked, the website takes 2-5minutes to load up the page it's confused it doesn't pick up that URL right away it must be doing something.

what do you mean by too many requests? right now the website gets a maximum of 10 people live mode on g.analytics - it used to take 400+ at one time without any problems? I don't know what happened. Same hosting, same plan .. everything.

Click to expand...

If you aren't getting that many visitors and it is still taking to much time to load, it is surely the code placement, I see it a lot with PHP. Also, you could try using CloudFlare. The DNS takes only a minute or two to move over, and the speed increase is dramatically better.

Dante848 said:

If you aren't getting that many visitors and it is still taking to much time to load, it is surely the code placement, I see it a lot with PHP. Also, you could try using CloudFlare. The DNS takes only a minute or two to move over, and the speed increase is dramatically better.

Click to expand...

CloudFlare? is that a hosting company even if I do move my coding will be the same? I'm a complete newbie at this. that's why I wanted someone to get this misery over and done with ^_^ unless there was a simple way for me to make it faster I'd do that right away

I have the SQL slow log, as MrBlue said above - if someone can take a look at this? let me know!

Cheers