blink10
asked on
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?
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?
Dave Baldwin
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?
ASKER
I use a hosting provider...and it is only accessed over the internet.
How do I determine the network path?
How do I determine the network path?
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 http://www.uptrends.com/aspx/free-html-site-page-load-check-tool.aspx to get an idea of how your site responds from different places around the world.
ASKER
The biggest problem I am having is inconsistency.
Try doing searches here and you will see the problem:
http://www.billsprice.com/index.php
Try doing searches here and you will see the problem:
http://www.billsprice.com/index.php
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.
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.
ASKER
Those pictures are from datafeeds I have no control of their size.
I am thinking of moving to Amazon cloud...do you have any thoughts on that?
I am thinking of moving to Amazon cloud...do you have any thoughts on that?
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.
>>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):
https://www.experts-exchange.com/Database/MySQL/
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):
https://www.experts-exchange.com/Database/MySQL/
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
If its a virtual machine then it could be the physical server its running on is having performance issues.