Page 1 of 1

Some weird goings on with speed and connectivity

Posted: Thu Oct 26, 2006 2:02 pm
by Raphilass
Hi, as i am new tot his please go easy.

First I just have to say how cool i think this blog system is, I have been looking for a solution for a little while now and when it is working this is by far the best.

I have managed to get this installed and working on several platforms over the previous week, these are (I am using serendipity 1.02)

Windows XP IIS5 PHP 4.4.4
A Webhost using linux / PHP 4.4.1 (had to remove the .htaccess file to get it to work here)

and finally my problem platform, an easyspace hosting account.

I have successfully uploaded the files and installed onto this platform several times now. The install identifies some folder permissions to change which is done easily and the installation completes without further error.

The site runs quite slowly compared to the streamline.net account and the supersized account i set up as comparisons ie these respond pretty much instantly the easyspace takes 5 to 10 seconds to load a page.

Sometimes the page loads correctly, sometimes it loads without the applying the CSS and sometimes it does not load at all giving me a database error (shown below)
Warning: mysql_connect(): Unknown MySQL Server Host 'mysql.nicholsonprints.co.uk' (0) in /www.nicholsonprints.co.uk/testsite/incl ... ql.inc.php on line 251

Warning: mysql_select_db(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /www.nicholsonprints.co.uk/testsite/incl ... ql.inc.php on line 252

Warning: mysql_select_db(): A link to the server could not be established in /www.nicholsonprints.co.uk/testsite/incl ... ql.inc.php on line 252
DATABASE_ERROR
I can't really change my webhost as it is a friends account and they probably won't want to....I am not sure what version of PHP and MySQL is installed but will post back when i figure that out.

Any help would be greatly appreciated, as i said earlier I think this is a fantastic product and have already thought of a couple of projects I want to use it for....but i need to get this sorted first.

Thanks for your help...

PHP and MySQL Info

Posted: Thu Oct 26, 2006 2:10 pm
by Raphilass
Just a quick post of the PHP and MySQL inof, this is taken from file created by the following command and is not the complete file, just the important info i think;

<?php
phpinfo();
?>

If any more information is required please let me know and I will try to find out, gonna try this witht he beta version fromt he site now to see if there is any improvement.

cheers
PHP Version 4.3.10

System Linux boron.iomart.com 2.4.21-27.0.2.ELsmp #1 SMP Wed Jan 19 15:27:58 EST 2005 i686
Build Date Feb 10 2005 21:59:27
Configure Command './configure' '--with-mysql' '--with-fastcgi' '--enable-fastcgi' '--enable-trans-sid' '--enable-ftp' '--with-gd' '--with-jpeg-dir=/usr' '--with-png-dir=/usr' '--with-zlib' '--with-gdbm' '--enable-magic-quotes' '--with-xml' '--with-mcrypt' '--enable-xslt' '--with-xslt-sablot' '--with-ttf'
Server API CGI/FastCGI
Virtual Directory Support disabled
Configuration File (php.ini) Path /usr/local/lib/php.ini
PHP API 20020918
PHP Extension 20020429
Zend Extension 20021010
Debug Build no
Thread Safety disabled
Registered PHP Streams php, http, ftp, compress.zlib

This program makes use of the Zend Scripting Language Engine:
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies

mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 3.23.49
MYSQL_MODULE_TYPE builtin
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_INCLUDE no value
MYSQL_LIBS no value

Re: Some weird goings on with speed and connectivity

Posted: Thu Oct 26, 2006 2:31 pm
by garvinhicking
Hi!

The problem is definitely with the database server on that webhost. It seems to be both slow and unresponsive in terms of connectivity.

The only way to fix this, is to fix the Database Server. Recent MySQL versions are faster than older ones, plus RAM should always be accessible.

Plus, if the DB server is not on the same server as the webserver, the link speed between Webserver and DB server needs to have as little network hops as possible. If the webserver needs to connect trhough 4 or 5 network hubs, you cannot expect good speed at all.

Best regards,
Garvin

Does this mean its bitch att he web host time

Posted: Thu Oct 26, 2006 2:51 pm
by Raphilass
Thanks for the quick response, much appreciated.

So i guess all i can do is contact their support and see what they can do.
Will see what they say, I am really starting to hate easyspace, will have to look around and see if I can find another host that supports my friends actinic catalogue so i can move him.

Re: Does this mean its bitch att he web host time

Posted: Thu Oct 26, 2006 3:47 pm
by garvinhicking
Hi!

That's true, it is definitely a technical problem that only the admin of the server can solve...

HTH,
Garvin