Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Website Running Slow

Posted on 2011-10-10
Medium Priority
Last Modified: 2012-08-14
We have a Drupal website that runs on Apache 2.2 and uses mysql database and php. It runs on a VmWare server with 1gb of Ram and 4 processors. But we are experiencing slowness when connecting to the website, we believe it's a network issue because we did a lot of testing on those servers, the database server running mysql and application server running the drupal website, but everything seemed normal.  Those apps running on windows server 2008.

What could cause the network traffic to slowdown?
Question by:klajdi
  • 2
  • 2

Expert Comment

by:Prashant Shrivastava
ID: 36942939
If you are running with 1GB RAM then I will suggest to increase this ASAP as if more and more people will connect this will become slower.However I am not sure if have done already but you need to consider many things before running MySQL on a virtual platform.

For Now I suggest just add RAM and enjoy :).

Author Comment

ID: 36943027

I meant 4gb already on the server not 1gb my mistake. What should i consider running MySql on a virtual platform. With still 4gb and it still runs slow. What could be the issue?

Accepted Solution

Michael Knight earned 2000 total points
ID: 36943075
How many computers on the network? Connection speed down/up? What tests have you run on the network itself? Anything fishy in the router logs?

Drupal sites are awesome but do require a bit of tweaking for performance. Going through all the steps really does help. I've noticed the major performance buff is achieved by turning enabling JS/CSS caching:

Enable CSS and JavaScript caching
1.Log in as a user with the admin role.
2.Go to Administer > Site Configuration > Performance (admin/settings/performance).
3.Set both Optimize CSS and Optimize JavaScript to Enabled.
This will aggregate and cache CSS and JavaScript files to reduce the number of requests made to your web server. (it's slow at first until th ecache is built)

Other performance enhancements are using http compression (mod_deflat, mod_gzip, etc.) on the Apache end
eAccelerator, APC, or xcache will tune performance on the PHP side

I have an Open Atrium (drupal) install running on a Ubuntu virtual server on an ubuntu host. I noticed the more I started to flesh out the site, the slower it got even on the LAN, so I knew it wasn't a network issue. The above tunes smoothed things out greatly.

If you're still not convinced it's a drupal thing, then your only other network considerations would be overall LAN traffic (a rouge workstation somewhere spamming the network) and bandwidth.

Author Comment

ID: 36943676

The changes you already mentioned are done. And also we are using eAccelerator and some other optimization changes in Mysql. We run the same setup on a testing environment but on physical servers and not on virtual environment with VmWare.

So we are thinking it's more of a network issue. What is a good open source to monitor the lan traffic and debug the issue?



Expert Comment

by:Prashant Shrivastava
ID: 36945491

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
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 Month13 days, 15 hours left to enroll

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question