Server Performance Issues....

I have been running into server performance issues....

I am running just mysql and apache thoughts on how to identify the problem?

I have ran top and even when nothing is using alot of CPU or Memory I still run into performance issues when querying SQL. The weird thing is I can query the same item and sometimes its a fraction of a second and other times 5-6 seconds return time.

Is there anyway to ensure enough resources for my frontend applications?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dave BaldwinFixer of ProblemsCommented:
What is the network path from you to the server?  Is it on your LAN or over the internet?  Do you have any way to account for other traffic on the network?
blink10Author Commented:
I use a hosting provider...and it is only accessed over the internet.

How do I determine the network path?
Dave BaldwinFixer of ProblemsCommented:
You can do a 'traceroute' but that only tells about the path between you and the hosting.  Since it is on hosting somewhere else, it is difficult to tell what kind of response you will get because of both other sites on the server and network traffic.  You can use this site to get an idea of how your site responds from different places around the world.
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

blink10Author Commented:
The biggest problem I am having is inconsistency.

Try doing searches here and you will see the problem:
Dave BaldwinFixer of ProblemsCommented:
If you are on shared hosting with other web sites, your response time will be inconsistent.  You're sharing the server and the time with others.  I just did a 'traceroute' from this computer to your site and I get 16 hops which is ok.

A bigger problem you have in response time is images that are way larger than the displayed image.  I looked at dress shoes and the thumbnail is about 150x150 but the actual image is more like 2100x2000.  The image you're loading is 196 times more data than the image on the screen.  You need to create thumbnails that are the right size to speed up the loading of your pages.
blink10Author Commented:
Those pictures are from datafeeds I have no control of their size.

I am thinking of moving to Amazon you have any thoughts on that?
Dave BaldwinFixer of ProblemsCommented:
I really don't know anything about the Amazon Cloud.  I personally avoid anything with the word 'cloud' in it because it seems to be marketing more than anything else.  You can click on "Request Attention" to get more people to look at your question and maybe add some zones to it.
Anthony PerkinsCommented:
>>I am running just mysql and apache thoughts on how to identify the problem?
Zones: Apache Web Server, MS SQL Server<<
Since this has nothing whatsoever to do with MS SQL Server, you may have better luck if you post in a more appropriate zone such as (you guessed it):
A change in hosts might resolve some of your issues, I can't comment on the amazon service because I haven't used them.

This sounds more like a hosting problem than a local server problem, another approach would be to contact your current host, and ask them if they can offer any solutions.
I was going to have a look, but got a 404 error on your link when index.php is included in the path.  Also, not including index.php resulted in an under construction page.  So my comments are based just on your problem description, but here are a couple of things to look at:
1.  In shared hosting, sometimes they do not have enough memory allocated for your account.  This can impact response time from your sql query.  Sometimes your host can increase your allocation or max query size or php memory (depending on what they constrain.)  I would talk with them about what they can do.  
2.  Your sql query could be inefficient.  For example, make sure you are just requesting the info you really need, and not just a select * from mytable.
3.  Track the times when you are seeing slow responses vs fast responses.  E.g., if you are seeing slow responses in the middle of the night, it may be that all the system resources are being used by others who are running backup processes during that time.  Or you may find the busy time is during the evening or perhaps during the day.
4.  Watch whether you will continue to get slow response times.  It may be that now that we are past the holidays other sites on the same server may not see the same traffic and you may no longer experience slow response times.
5.  If the data (e.g., images) you are getting is from feeds (per your comment later), then it is not necessarily the database query itself that is slow.  In fact, it may not be your server that is slow.  Instead, it could be the response time from the feed that is slow.  This could mean either their server is slow or there may be many network hops between your feed and your site.  The workaround for this is to see if you can cache some of the data on your server.

Well, as I say, these comments are just from your description and the comments in the trail above, all without seeing the site itself.  But I hope they help anyway.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Is your server a physical server or a virtual machine.

If its a virtual machine then it could be the physical server its running on is having performance issues.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Apache Web Server

From novice to tech pro — start learning today.