-psycledelics- (http://psycle.pastnotecut.org/index.php)
|- ABOUT THE SITE (http://psycle.pastnotecut.org/board.php?boardid=10)
|-- Speed of Psycledelics' server (http://psycle.pastnotecut.org/threadid.php?boardid=10&threadid=1210)


From [JAZ] on 18.11.2003, 20:41:

  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


From heatseeker on 18.11.2003, 22:41:

 

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 !


From ksn on 18.11.2003, 22:45:

 

quote:
Original by heatseeker Maybe ksn, master in diplomatic speeches


__________________
soundcloud.com/ksniod
ksniod.wordpress.com
@ksniod on twitter


From heatseeker on 18.11.2003, 23:00:

 

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 !


From heatseeker on 18.11.2003, 23:02:

 

quote:
Original by ksn




come on ! stay in the light !


__________________
heatseeker.
2 whisky valent mieux qu'1 !


From SAS on 19.11.2003, 07:52:

 

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...


From heatseeker on 19.11.2003, 11:39:

 

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 !


From BJohan on 26.02.2004, 12:19:

 

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)


From BJohan on 26.02.2004, 12:42:

 

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.


From DJMirage on 03.12.2004, 10:16:

 

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


From SAS on 03.12.2004, 16:36:

 

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...


From DMNXS on 03.12.2004, 19:17:

 

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.


From [JAZ] on 04.12.2004, 14:22:

 

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


From SAS on 06.12.2004, 09:58:

 

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...


From BJohan on 21.12.2004, 12:23:

 

Yeah, speed has been is ok for a few weeks :-)

Powered by: Burning Board 1.0 Beta 4.5eEnglish Translation by AnnaFan
Copyright © 2001 by WoltLab