Hello.
I have a performance problem with the latest version of spip:
http://files.spip.org/spip/stable/spip-3.0.zip?1352900441
The installation is done on a ubuntu 12.04 virtual machine running with
2G of ram.
The database is hosted on a separate host (but the situation is the same
if it s the same box).
Installation has been performed with:
apt-get install -y zip
apt-get install -y php5-mysql
apt-get install -y mysql-client
apt-get install -y libapache2-mod-php5
wget -q -O spip-3.0.zip
http://files.spip.org/spip/stable/spip-3.0.zip?1352900441
unzip -q spip-3.0.zip
sudo mv spip /var/www
for i in IMG tmp local config ; do sudo chmod -R go+w
/var/www/spip/$i ; done
Then i edited /var/www/spip/config/mes_options.php with my sql infos:
<?php
define('_INSTALL_SERVER_DB','mysql');
define('_INSTALL_HOST_DB', '10.55.60.158');
define('_INSTALL_USER_DB','eihaehusinielai');
define('_INSTALL_PASS_DB','tootheeraireife');
define('_INSTALL_NAME_DB','spip');
?>
With my browser, i go to http://mysite/spip/ecrire and set my name and
password.
When i reach this stage, any public pages (http://mysite/spip/) takes
ages to load (like several minutes).
Pages in http://mysite/spip/ecrire are fetched fast enough, as well as
some php code outside of the spip subdirectories, but any public pages
in http://mysite/spip/ takes several minutes to be render.
I do not experience this behaviour if i use the packaged version of spip
on ubuntu (version 2. something).
I experience the problem systematically (i try 4 or 5 times) with spip 3.0
The machine hosting apache and spip is "in the cloud" (as well as the
database one), and its ip is not the same as the one the web client use
to connect to it.
In this case, the ip of the box as the box knows it is 10.55.60.137
The ip to connect to the box from the internet is: 91.189.93.71
It looks to me this information may be important because of the
following fact:
- if i use links from the spip box and ask links
http://10.55.60.137/spip/ , the page load immediately.
- links http://91.189.93.71/spip/ from my laptop takes a long time.
- If i fetch with telnet manually, from my laptop, i have the output
immediately using http 1.0
melmoth@x220:~$ telnet 91.189.93.71 80
Trying 91.189.93.71...
Connected to 91.189.93.71.
Escape character is '^]'.
GET /spip/ HTTP/1.0
HTTP/1.1 200 OK
Date: Fri, 16 Nov 2012 21:49:39 GMT
Server: Apache/2.2.22 (Ubuntu)
X-Powered-By: PHP/5.3.10-1ubuntu3.4
Vary: Cookie,Accept-Encoding
- If i to the same with http1.1, it s slower, i have the html coming
after a pause, and the connection does not stop untill after several
seconds once the html has been sent.
melmoth@x220:~$ telnet 91.189.93.71 80
Trying 91.189.93.71...
Connected to 91.189.93.71.
Escape character is '^]'.
GET /spip/ HTTP/1.1
Host: 91.189.93.71
<=== Here, it is stuck for a (long) while
- If i use Host: 10.55.60.137 during the http1.1 request, it s a bit
faster (but i am still experiencing a pause once the html has been
generated).
Any one has some idea as to what could be the cause, and how to cope
with it ?