PSYCLE's home     
     since may 2000
  news / home  files songs boards links all registered members about psycledelics Statistics    
Welcome to -psycledelics-. If this is your 1st visit please read the FAQ - Frequently Asked Questions You must register before you can post here: Please click above on Registration to register yourself. You do not need to register if you only want to read Threads.
Login with Username & Password:

Remember me on this PC.
-psycledelics- Discussions ABOUT THE SITE Speed of Psycledelics' server
« Previous Thread Next Thread » Show a Printable Version  Send this to a Friend  Add to Favorites
Thread closed
Author
Post
[JAZ]
Psycle Developer



Date Registered:
11.2001
Location:
Balaguer (Spain)
Posts: 1294


[JAZ] ist offline
  Speed of Psycledelics' server        Go on top to this Page

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] Add [JAZ] to your Buddy-List
heatseeker
Administrator



Date Registered:
11.2001
Location:
Canada / Montreal
Posts: 95


heatseeker ist offline
         Go on top to this Page

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 Profile of heatseeker Add heatseeker to your Buddy-List Homepage of heatseeker
ksn
Administrator



Date Registered:
11.2001
Location:
France
Posts: 622


ksn ist offline
         Go on top to this Page

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


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

18.11.2003, 22:45 Profile of ksn Add ksn to your Buddy-List Homepage of ksn Add ksn to your Contact-List
heatseeker
Administrator



Date Registered:
11.2001
Location:
Canada / Montreal
Posts: 95


heatseeker ist offline
         Go on top to this Page

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 Profile of heatseeker Add heatseeker to your Buddy-List Homepage of heatseeker
heatseeker
Administrator



Date Registered:
11.2001
Location:
Canada / Montreal
Posts: 95


heatseeker ist offline
         Go on top to this Page

quote:
Original by ksn




come on ! stay in the light !


__________________
heatseeker.
2 whisky valent mieux qu'1 !

18.11.2003, 23:02 Profile of heatseeker Add heatseeker to your Buddy-List Homepage of heatseeker
SAS
Administrator



Date Registered:
11.2001
Location:
Berlin, Germany
Posts: 275


SAS ist offline
         Go on top to this Page

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 Profile of SAS Add SAS to your Buddy-List Homepage of SAS Add SAS to your Contact-List AIM Screenname: S0l4RiS YIM Screenname: who's using YIM ???
heatseeker
Administrator



Date Registered:
11.2001
Location:
Canada / Montreal
Posts: 95


heatseeker ist offline
         Go on top to this Page

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 Profile of heatseeker Add heatseeker to your Buddy-List Homepage of heatseeker
BJohan
Super Moderator



Date Registered:
11.2001
Location:
travelling in france
Posts: 213


BJohan ist offline
         Go on top to this Page

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 Profile of BJohan Add BJohan to your Buddy-List Homepage of BJohan Add BJohan to your Contact-List AIM Screenname: bohan@jabber.org (no A0L) YIM Screenname: bohan@jabber.org (no Yah00!1)
BJohan
Super Moderator



Date Registered:
11.2001
Location:
travelling in france
Posts: 213


BJohan ist offline
         Go on top to this Page

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 Profile of BJohan Add BJohan to your Buddy-List Homepage of BJohan Add BJohan to your Contact-List AIM Screenname: bohan@jabber.org (no A0L) YIM Screenname: bohan@jabber.org (no Yah00!1)
DJMirage
Psycler



Date Registered:
07.2002
Location:
Netherlands
Posts: 35


DJMirage ist offline
         Go on top to this Page

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 Profile of DJMirage Add DJMirage to your Buddy-List Homepage of DJMirage Add DJMirage to your Contact-List
SAS
Administrator



Date Registered:
11.2001
Location:
Berlin, Germany
Posts: 275


SAS ist offline
         Go on top to this Page

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 Profile of SAS Add SAS to your Buddy-List Homepage of SAS Add SAS to your Contact-List AIM Screenname: S0l4RiS YIM Screenname: who's using YIM ???
DMNXS
Psycler



Date Registered:
01.2004
Location:
Oldenburg, Germany
Posts: 304


DMNXS ist offline
         Go on top to this Page

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 Profile of DMNXS Add DMNXS to your Buddy-List Add DMNXS to your Contact-List
[JAZ]
Psycle Developer



Date Registered:
11.2001
Location:
Balaguer (Spain)
Posts: 1294


[JAZ] ist offline
         Go on top to this Page

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 Profile of [JAZ] Add [JAZ] to your Buddy-List
SAS
Administrator



Date Registered:
11.2001
Location:
Berlin, Germany
Posts: 275


SAS ist offline
         Go on top to this Page

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 Profile of SAS Add SAS to your Buddy-List Homepage of SAS Add SAS to your Contact-List AIM Screenname: S0l4RiS YIM Screenname: who's using YIM ???
BJohan
Super Moderator



Date Registered:
11.2001
Location:
travelling in france
Posts: 213


BJohan ist offline
         Go on top to this Page

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

21.12.2004, 12:23 Profile of BJohan Add BJohan to your Buddy-List Homepage of BJohan Add BJohan to your Contact-List AIM Screenname: bohan@jabber.org (no A0L) YIM Screenname: bohan@jabber.org (no Yah00!1)
  « Previous Thread Next Thread »
Thread closed
Jump to:

© 2002-2007 psycledelics | Powered by Woltlab Burning Board v1 Beta4.5e ©2001 Woltlab GbR|Setup & mod for psycledelics by: SAS