Optimize MySQL & PHP website

[Zakhar]

I'm a complete alien when it comes to developing, always outsource.

I have a website that has been running slow for almost a month now.

This is the chat log from HG:

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.

^ Again, don't even ask me what the above means - that's basically the problem.

I have set up an FTP host thingy for whoever knows how to fix this to access the code - please keep in mind its not a website I made from scratch I bought the theme/template.

I want the speed to be improved as right now it takes around 30seconds to load page to page which is highly unprofessional, it was once going at lightening speed.

It's on a dedicated host - so the hosting is not the issue for certain.

Please send me your PM's or post below - whichever way you wish, thanks.

P.S - Try not the over-price yourself, I know exactly how much I should be paying for a job like this.

 

[hustleharderrrr]

P.S - Try not the over-price yourself, I know exactly how much I should be paying for a job like this.

But you don't know what the issue is? Nice joke :ranger:

 

[kuzmanin]

You mentioned mysql
In most of the cases the real problem is there
Do you have access to mysql config?
If yes I will be happy to take a look at this problem.

 

[dataengineer]

I can sort it out. Contact me S K Y P E: ifacedev

 

[primadg]

Looks like your problem is in MySQL DB.

It could be:
- the tables without indexes.
- not optimized DB requests

PM me for skype info

My best regards,
Valera

 

[vikasvyas47]

hello
i have good experience in php and mysql add me on skype for further detail talks

skype : vikasvyas47

 

[lancis]

What caused the change in speed?
Did you order a redesign? User base grow? Anything else you can point at?

30 seconds is a lot of time even for the worst of PHP scripts. Usually MYSQL requests are the ones to cause this. Ask your hoster to activate the slow query log (details here http://dev.mysql.com/doc/refman/5.5/en/slow-query-log.html) and if mysql is the cause you'll know where to fix.