| Author |
|
[JAZ]
Psycle Developer
Date Registered:
11.2001
Location:
Balaguer (Spain)
Posts: 1373
![[JAZ] ist offline](images/offline.gif) |
|
| Speed of Psycledelics' server |  |
Continued from the thread in here : http://psycle.pastnotecut.org/thread.php...=1209&boardid=2
I think we should talk about this a bit further (well... the best talk will be the one directly with the hoster, but nevertheless...)
The HTML server, as said by SAS, is working correctly, downloads are fast, and if we check the only page that is an .html ( the mascotte on "about" ), it loads almost instantly too.
So we are back to the same old thing: Either the PHP parser or the database server are the problem. Since the PHP parser is different in the two HTML servers (for obvious reasons), and we still get bad results, It looks quite evident that the database is the culprit. (Or at least for the most part).
We could try (for testing!) to run one ourselves and see if we get better or worse results.
Also, I wonder why in pastnotecut we tend to get those "Error 500" and not in project-psy.com. A lower timeout?
__________________
<[JAZ]> Pa pi pa pa pa pi pa.... ;·D
|
|
 18.11.2003, 20:41 |
![Profile of [JAZ]](images/profil.gif) ![Add [JAZ] to your Buddy-List](images/homie.gif) |
heatseeker
Date Registered:
11.2001
Location:
Canada / Montreal
Posts: 95
|
|
| | |
quote:
So we are back to the same old thing: Either the PHP parser or the database server are the problem. Since the PHP parser is different in the two HTML servers (for obvious reasons), and we still get bad results, It looks quite evident that the database is the culprit. (Or at least for the most part).
We could try (for testing!) to run one ourselves and see if we get better or worse results.
i think both (php parser + DB server) are guilty. I personnaly requested the song's table from my computer, creating sql INSERT queries: i had the final result in 1 minute if i remember well.
If you try to export datas from song's table with phpmyadmin on the DB server, you get nothing (the page stops).
Yes we could test different configurations [hoster's phpParser/project-psy DB] [project-psy's phpParser/project-psy DB] etc... if project-psy is available for that.
In any case, we have to resolve the problem with the hoster.
Maybe ksn, master in diplomatic speeches  could prepare a little email that we will complete with technical description/suggestions?
__________________
heatseeker.
2 whisky valent mieux qu'1 !
|
|
| 18.11.2003, 22:41 |
 |
ksn
Date Registered:
11.2001
Location:
France
Posts: 623
|
|
|
| 18.11.2003, 22:45 |
 |
heatseeker
Date Registered:
11.2001
Location:
Canada / Montreal
Posts: 95
|
|
|
quote:
Also, I wonder why in pastnotecut we tend to get those "Error 500" and not in project-psy.com. A lower timeout?
the timeout is at 60s i think. Sometimes (like yesterday), the DB crashes down. the hoster has to give us an explanation AND a solution... 
__________________
heatseeker.
2 whisky valent mieux qu'1 !
|
|
| 18.11.2003, 23:00 |
|
heatseeker
Date Registered:
11.2001
Location:
Canada / Montreal
Posts: 95
|
|
|
quote:
Original by ksn
come on ! stay in the light !
__________________
heatseeker.
2 whisky valent mieux qu'1 !
|
|
| 18.11.2003, 23:02 |
|
SAS
Date Registered:
11.2001
Location:
Berlin, Germany
Posts: 275
|
|
| | |
quote:
Original by [JAZ]
Also, I wonder why in pastnotecut we tend to get those "Error 500" and not in project-psy.com. A lower timeout?
well, the max execution time on the servers are *slightly* different...
PNC: max_execution_time 18
project-psy: max_execution_time 50000(!!)
max. 18 seconds for php execution is a damn short time. By default it's usually 30 sec. Okay.. 50000 secs may be too much, but every php-developer feels like heaven 
also important: php is running in safe mode on pnc.
memory limit on pnc is 4MB, on project-psy.com 40 MB.
quote:
Original by heatseeker
i think both (php parser + DB server) are guilty. I personnaly requested the song's table from my computer, creating sql INSERT queries: i had the final result in 1 minute if i remember well.
If you try to export datas from song's table with phpmyadmin on the DB server, you get nothing (the page stops).
Yes we could test different configurations [hoster's phpParser/project-psy DB] [project-psy's phpParser/project-psy DB] etc... if project-psy is available for that.
well, the DB on project-psy.com isn't configured for outside access (%) - you can only access it from servers in a definded IP range (only the whole network of hoster's DataCenter). And that's something i can't change. Right now, the mirror on project-psy.com is getting the database contents from pnc. And that already slows the mirror down...
To your export problem: install mysql on your home pc and try to export via the command-line. Or, if you have some other hoster that allows either cgi-scripts or the PHP - exec(); command, try to export via scripts. I have some script running on project-psy, that makes you at least able, to export and import the whole database from pnc. But it takes some time.. (can remember, moving the db-contents back to pnc, took almost 45 minutes, but it worked)
__________________
i appear, just to disappear again...
|
|
| 19.11.2003, 07:52 |
   |
heatseeker
Date Registered:
11.2001
Location:
Canada / Montreal
Posts: 95
|
|
|
18s.. you right. just saw it. damn.. they really don't want to see their server working
i have mysql (it's good to have it if i work on the new site version  ).
45 minutes for the entire db?.... mmh...
45 minutes for around 4megs... ugly
__________________
heatseeker.
2 whisky valent mieux qu'1 !
|
|
| 19.11.2003, 11:39 |
|
BJohan
Date Registered:
11.2001
Location:
travelling in france
Posts: 213
|
|
|
hello,
there's been a maintainance operation last night on the sql servers...
i haven't seen any sensible improvement in the "normal"/"usual" speed today, but they may have fixed the overloading problems that sometimes make it very slow.
http://translate.google.com/translate?u=...tml&langpair=fr
(waiters should be read serveurs, in the translation ;p)
Last edited by BJohan on 26.02.2004, 12:26 o'clock.
|
|
| 26.02.2004, 12:19 |
&img=5) |
BJohan
Date Registered:
11.2001
Location:
travelling in france
Posts: 213
|
|
|
quote:
Original by heatseeker
18s.. you right. just saw it. damn.. they really don't want to see their server working
18s ? what timeout is that for exactly?
max time that the http server wait for the php server to execute a single php page?
well, i'd say if the damn php server isn't able to complete any page with db queries in less than 5 seconds, it's because the poor machines (php and/or db) are already *over* loaded enough... and it's better to make the user know things are really going bad and prevent him from using the site instead of letting him contribute to make the php/db backends collapse more.
|
|
| 26.02.2004, 12:42 |
|
DJMirage
Date Registered:
07.2002
Location:
Netherlands
Posts: 35
|
|
|
havent been here in a while, but i ahve to say that the speed has greatly improved since the last time :o
very funky
__________________
my site
|
|
| 03.12.2004, 10:16 |
 |
SAS
Date Registered:
11.2001
Location:
Berlin, Germany
Posts: 275
|
|
|
hmm.. haven't recoginized much speed improvement lately. It's still damn slow most of the time. I think that ksn should seriously think about moving the site. And when I see the price for that kind of account here (not sure if ksn pays the same), i think you'll get almost nothing for a high price.
I guess moving the site isn't such a bad idea.
btw:
Here in Germany, you'll get your own server (AMD AthlonXP 3000+,1Gig RAM, 160 Gig HDD) for 39€ /Month.
__________________
i appear, just to disappear again...
|
|
| 03.12.2004, 16:36 |
|
DMNXS
Date Registered:
01.2004
Location:
Oldenburg, Germany
Posts: 304
|
|
|
quote:
Original by SAS
[...]btw:
Here in Germany, you'll get your own server (AMD AthlonXP 3000+,1Gig RAM, 160 Gig HDD) for 39€ /Month.
With what connection? DSL, T1, ...? I've seen some nice looking ones for 80+ € / month.
|
|
| 03.12.2004, 19:17 |
 |
[JAZ]
Psycle Developer
Date Registered:
11.2001
Location:
Balaguer (Spain)
Posts: 1373
|
|
|
Mmmm... as of right now, it has a good speed ( less than 5 seconds to load a thread!, 7 at much. )
Don't know if this has anything to do with the small holidays that some spanish people will have ( saturday, sunday, monday, tuesday and wednesday ) so less saturation is present 
__________________
<[JAZ]> Pa pi pa pa pa pi pa.... ;·D
|
|
| 04.12.2004, 14:22 |
|
SAS
Date Registered:
11.2001
Location:
Berlin, Germany
Posts: 275
|
|
|
quote:
Original by DMNXS
With what connection? DSL, T1, ...? I've seen some nice looking ones for 80+ € / month.
T1
btw.. speed is nice today. 3, max. 4 seconds to load a thread.
__________________
i appear, just to disappear again...
|
|
| 06.12.2004, 09:58 |
|
BJohan
Date Registered:
11.2001
Location:
travelling in france
Posts: 213
|
|
|
Yeah, speed has been is ok for a few weeks :-)
|
|
| 21.12.2004, 12:23 |
|
|
