I Need A Techincal Help Please - GoFuckYourself.com

isa · 05-11-2003, 03:48 AM

Hi guys,
my problem is this. I'm mananging more than 20000 pages and I'm using mnay PHP scripts to show banners and some stuuf on my pages. I started using some flat text file then I switched to MySQL but I still have problems with my server. It slows down often and my provider seems no to be able to help me. I have a dedicated server really powerful but I think it could be misconfigured. I decide to modify my scripts including a .inc files with data to reduce load on my machine. Do you think it's correct ? Which is difference in reading a flat file or accessing to MySQL table or including a file ?

Any suggestio to reduce load on my server ?
How many calls can be tolerated by MySQL before slowing down ?

Thanks and Kisses
Isa

keyDet79 · 05-11-2003, 05:19 AM

You may just have a very slow server, log into telnet or ssh and type 'top' to see all processes and their load. It is also possible you don't have enough RAM and it's starting to swap.

By the way you should never use a flat file unless your database is very small. I use it even when it's just a few records. When you use a file the whole thing gets read into the memory.

isa · 05-11-2003, 06:08 AM

Quote:

Originally posted by keyDet79
You may just have a very slow server, log into telnet or ssh and type 'top' to see all processes and their load. It is also possible you don't have enough RAM and it's starting to swap.

By the way you should never use a flat file unless your database is very small. I use it even when it's just a few records. When you use a file the whole thing gets read into the memory.

Thanks keyDet79 but I'm using P4 2Ghz 2GB RAM so I don't think it's a slow server.

You're right and I'm using MySQL but I have the same problems

Isa

genomega · 05-11-2003, 07:17 AM

URL ?

05-11-2003, 03:48 AM	#1
isa Registered User Join Date: Dec 2002 Location: Sidney/Milan Posts: 24	I Need A Techincal Help Please Hi guys, my problem is this. I'm mananging more than 20000 pages and I'm using mnay PHP scripts to show banners and some stuuf on my pages. I started using some flat text file then I switched to MySQL but I still have problems with my server. It slows down often and my provider seems no to be able to help me. I have a dedicated server really powerful but I think it could be misconfigured. I decide to modify my scripts including a .inc files with data to reduce load on my machine. Do you think it's correct ? Which is difference in reading a flat file or accessing to MySQL table or including a file ? Any suggestio to reduce load on my server ? How many calls can be tolerated by MySQL before slowing down ? Thanks and Kisses Isa

05-11-2003, 05:19 AM	#2
keyDet79 Confirmed User Join Date: Feb 2003 Location: Netherlands Posts: 1,109	You may just have a very slow server, log into telnet or ssh and type 'top' to see all processes and their load. It is also possible you don't have enough RAM and it's starting to swap. By the way you should never use a flat file unless your database is very small. I use it even when it's just a few records. When you use a file the whole thing gets read into the memory. __________________ Multihomed quality BW for less ICQ 51034232 - MSN [email protected] - Email keydet(at)vibehosting.com Last edited by keyDet79; 05-11-2003 at 05:22 AM..

05-11-2003, 07:17 AM	#4
genomega Confirmed User Join Date: Feb 2002 Location: NW Florida Posts: 1,190	URL ? __________________ No Jerk TGP Gallery Monitor MoneyBookers