By pieter333 on

Hi,

At home I have a development ubuntu linux server. Drupal 6.2 works like a charm.
If I copy the drupal files to my laptop that has also an ubuntu linux apache2 installation with php5 and I fill in the development server as mysql host, the pages load incredible slow!!!

A page load takes 20-35 seconds!! If I open the drupal website at the dev. server IP it loads in about 2 seconds.

I searched a lot on google and this forum but couldn't find anything... :-(

I did the same with my symfony website and that loads by remote mysql connection just normal. Also a little test script with mysql_connection() and mysql_query() works also very fast.

If i look at the drupal query log it's a query total of about 3 seconds. So how is it possible that I have to wait 20-35 seconds before I get a response in my browser?

Who can help me?
Thanks a lot already!!!

Greetings,
Pieter

⋅ Categories: Drupal 6.x

Comments

une’s picture

une commented

if u search at the host forum about "dreamhost" you will see that drupal runs very slow at that host because they have seperate machines for database and application
so it runs slow
more specific than that i dont know
just search the forums and you'll be fine

pieter333’s picture

pieter333 commented

Thanks for your reply, but I don't think that is the problem. If I look at the dreamhost topics I read about slow database servers that is the main reason. I'm the only person that use the development server, so I don't understand that it's running remote so very sow..

gpk’s picture

gpk commented

I wonder what the round trip time for a single query is. A typical page in Drupal might take upwards of 100 queries depending on the modules you have installed etc. Many are very small/quick (e.g. a lot of lookups in the table {url_alias} via http://api.drupal.org/api/function/drupal_lookup_path) at under a ms each. But if the network round trip time for these is 0.2 seconds say then 100 of them gives you 20 seconds already ... devel.module should highlight this for you.

gpk
----
www.alexoria.co.uk

gpk
----
www.alexoria.co.uk

nitram_cero’s picture

nitram_cero commented

I have the exact same problem.

My assosiate and I are about to develop some extensions in php, while sharing the database (that I have in a dedicated server, at my home). It turns out that for my assosiate... it's dreadfully slow. It's not a connection thing. It's REALLY slow even at high upload speeds.

I'm guessing all SQL is sent in plain-text, and also has SSL overhead.

Is there a way to configure MySQL to compress the packets to decrease trip times?

Thanks!

gpk’s picture

gpk commented

I suspect it's a latency problem compounded by 100 - 200 queries per page (each with this latency), during which time the script has to wait idle.

gpk
----
www.alexoria.co.uk

gpk
----
www.alexoria.co.uk

mm167’s picture

mm167 commented

do u use ip address (192.168.x.x) OR domain + machine name (say db.mysite.com) to connect the Drapal to your mySql server?

btw, how u link up your drupal server and mysql server?
1 hub/switch in between?
many hubs/switches in between?

if u have MySql Query Browser, u will see what's wrong easily.

nitram_cero’s picture

nitram_cero commented

The connection is thru Internet. I'm guessing that's not an option.
If it's necessary to have a local mysql connection, that's a major drawback.

We won't be able to develop and share work thru a versioning system (i.e. SVN/CVS)

It's kind of utopic now that I think of it. Oh well...

mm167’s picture

mm167 commented

what do u mean by "connect thru Internet"?

data goes out of you LAN, go out to Internet, ....back to your LAN ??

why not put them in the same sub-net (LAN)?

loze’s picture

loze commented

Was there ever a solution for this?
I'm having the same problem

mpaler’s picture

mpaler commented

unacceptable response times for remote mysql to localhost. D6.14

EDIT -- several hours later

It's hard to believe no one has figured out whether this is a Drupal issue or a server/mysql/network issue. I'm suspecting it's a drupal & network latency issue but I'm just not smart enough to figure that out for certain.

I've seen numerous posts on the web suggesting the addition of "skip-name-resolve" to my.cnf.

http://bobbyallen.wordpress.com/2007/11/02/slow-connections-on-remote-my...

I've tried that to no avail.

I would love to know for certain if this is the dead end it seems like...

Civicsolar
http://www.civicsolar.com

gpk’s picture

gpk commented

I'd suggest you need first to do various timing tests e.g. with Drupal query log (devel.module) and/or MySQL query browser as noted above.

gpk
----
www.alexoria.co.uk

bradezone’s picture

bradezone commented

So I'm having this problem as well. When I enable Devel and print the SQL query log, I get this:

Executed 168 queries in 7802.27 milliseconds. Queries taking longer than 5 ms and queries executed more than once, are highlighted. Page execution time was 9248.33 ms.

9 seconds. way longer than the 1 or 2 seconds it loads if using localhost as the mysql server. Pretty much all of the queries take at least 30 ms. As you can see there are 168 of them total. Most are "cache_get", "cache_set", and "drupal_lookup_path" calls. But there are several others as well.

Methinks it would best be solved if Drupal used more file-caching than DB caching.
I found a page that goes over some modules that improve speed. Haven't used many of these yet, but hopefully they will help:
http://groups.drupal.org/node/21897

Bradezone :: for all your Brade needs

blue92877’s picture

blue92877 commented

Using Drupal 6 installed on in a Godaddy.com hosting account, my page loads are also taking between 20 and 30 seconds. I'm using Google Chrome developer tools to look at the load times of the page components. There are about 20 seconds of latency and then the page loads in full in 2 to 8 seconds. As typical for a godaddy hosting account, the mysql server and the web server are not the same machine.

Anyone figured out a practical way to speed up Drupal's load times? I've already done everything possible under Performance (caching, compression, etc), and I have installed only the necessary modules.

I would think that having a hosting provider like Godaddy is more common than having your own t3 server setup with web and database hosting on the same machine. As such, What are some ideas on making Drupal more efficient to eliminate latency times?

Blue

gpk’s picture

gpk commented

>done everything possible under Performance (caching, compression, etc), and I have installed only the necessary modules
If the bottleneck is the link between the webserver and the database server then the only options are to increase the bandwidth between the 2 (Godaddy's problem) or reduce the number of queries and/or the amount of data transferred. I'm no expert here but there are obviously limits to how you can affect the queries without rewriting all of Drupal. I think D7 has got rid of many of the path lookup queries, beyond that page caching should be a big help for anonymous users (only 1 or 2 queries are required per page view) and there may also be a module to do page caching for logged in users. Block caching may also help where appropriate. However given how dynamic a system Drupal is there are probably limits to what improvements you can achieve here without changing hosting package or host.

gpk
----
www.alexoria.co.uk