With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf
Solved
Slow performing home page on fast server
Posted on 2011-03-04
I have been experiencing slow website but only when it is viewed for the first time on the network. It may take 6-15sec for the home page to popup, after that it's very very fast. Perhaps one of the experts can solve the issue, or at least point out what the problem may be.
Hosting:
VPS: 768MB RAM
HDD: RAID 10
CPU dual xeon
Idle CPU utilization: 0.1-0.2%
OS: CentOS 5.x 64bit
Website: Joomla 1.5.22 with demo content, cache disabled, no gzip compression
Template: Original template, no modifications
Network 1:
Speed: 100Mbps up/down
ping to target VPS: 2ms – 20ms, no timeouts
hops: 8 (both machines are in the same city)
DNS used: local DNS on Windows 2008 server R2, or 4.2.2.1
Workstation: Win7 pro 74bit, i5 8BG RAM
Browsers: MSIE, Chrome, FF (all latest versions)
Network 2,3,4
ISP: true for all
Speed: 6-20Mbps down, 1-5Mbps up
ping to target VPS 2-4ms
hops: 8-9
browsers: MSIE, FF, Chrome (latest versions)
Symptoms:
Nslookup performed on the workstation prior to opening home page returns correct IP address without any delays, www.intodns.com didn't report any issues with DNS set up, 100% returned pings with avg of 2ms.
At this time workstation is aware about the DNS/IP address of the target website, yet when home page is opened in any web browser for the first time it takes anywhere from 6-15 seconds while browsers display "waiting for www.example.com"...
After home page opens for the first time everything else works super-fast. I can reopen the site without any problems; clearing dns cache will not affect it (done on DNS server as well as on the workstation).
At this time page can be reopened any time and it is very fast. No proxy connection enabled in all browsers.
The problem can be reproduced on every network, condition is it needs to be a first request in a longer period of time, I'd say 6+ hours.
I have talked with the hosting company, everything looks good on their end, DNS is set up properly, VPS is not overloaded, and underlying hardware is also in good shape. I am suspecting routing cache problem on their end, but can't test it remotely. They keep saying everything is fine on the VPS.
What could be a problem here, it's been over two months, and no one knows what's causing the slowness. The problem is not only related to Joomla site, I used it as an example. Other PHP/mysql site are also lagging upon initial view.
Hosting:
VPS: 768MB RAM
HDD: RAID 10
CPU dual xeon
Idle CPU utilization: 0.1-0.2%
OS: CentOS 5.x 64bit
Website: Joomla 1.5.22 with demo content, cache disabled, no gzip compression
Template: Original template, no modifications
Network 1:
Speed: 100Mbps up/down
ping to target VPS: 2ms – 20ms, no timeouts
hops: 8 (both machines are in the same city)
DNS used: local DNS on Windows 2008 server R2, or 4.2.2.1
Workstation: Win7 pro 74bit, i5 8BG RAM
Browsers: MSIE, Chrome, FF (all latest versions)
Network 2,3,4
ISP: true for all
Speed: 6-20Mbps down, 1-5Mbps up
ping to target VPS 2-4ms
hops: 8-9
browsers: MSIE, FF, Chrome (latest versions)
Symptoms:
Nslookup performed on the workstation prior to opening home page returns correct IP address without any delays, www.intodns.com didn't report any issues with DNS set up, 100% returned pings with avg of 2ms.
At this time workstation is aware about the DNS/IP address of the target website, yet when home page is opened in any web browser for the first time it takes anywhere from 6-15 seconds while browsers display "waiting for www.example.com"...
After home page opens for the first time everything else works super-fast. I can reopen the site without any problems; clearing dns cache will not affect it (done on DNS server as well as on the workstation).
At this time page can be reopened any time and it is very fast. No proxy connection enabled in all browsers.
The problem can be reproduced on every network, condition is it needs to be a first request in a longer period of time, I'd say 6+ hours.
I have talked with the hosting company, everything looks good on their end, DNS is set up properly, VPS is not overloaded, and underlying hardware is also in good shape. I am suspecting routing cache problem on their end, but can't test it remotely. They keep saying everything is fine on the VPS.
What could be a problem here, it's been over two months, and no one knows what's causing the slowness. The problem is not only related to Joomla site, I used it as an example. Other PHP/mysql site are also lagging upon initial view.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
- +1
5 Comments
Active 1 day ago
Usually a lag before initial page view is caused by initiating a connection to the database. Is the database on the web server? If you remote into the web server an view the site is it also really slow for first load?
well you could narrow it down by putting up a html page with a few average size images on it, this takes the db out of the equation.
Also in FF you could install the "Firebug" add-on which shows you the net times for the content that is loaded... this may also help.
Is it slow for every person the first time?
As you have a VPS you could try installing mytop on the server and then connect that to the mysql servers so that you can what what the database is doing when the first load occurs, it will show you the queries executing.
Also in FF you could install the "Firebug" add-on which shows you the net times for the content that is loaded... this may also help.
Is it slow for every person the first time?
As you have a VPS you could try installing mytop on the server and then connect that to the mysql servers so that you can what what the database is doing when the first load occurs, it will show you the queries executing.
Active today
You can use this page http://www.uptrends.com/aspx/free-html-site-page-load-check-tool.aspx to see what takes a long time to load on your page. But the first time is always going to be the longest loading time because after that all the common graphics and scripts are in the browser cache and doesn't have to be downloaded any more.
The problem was directly related to underlying hardware, VPS got moved to another host problem and the problem disappeared.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Google Drive is extremely cheap offsite storage, and it's even possible to get extra storage for free for two years. You can use the free account 15GB, and if you have an Android device..when you install Google Drive for the first time it will give…
In part one, we reviewed the prerequisites required for installing SQL Server vNext.
In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Learn how to navigate the file tree with the shell.
Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment.
To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month6 days, 8 hours left to enroll
704 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.