Need help urgent

enterume

Hi,

I have a site currenlty have 150-200 login silmultaneously in certain period, to retrieve update result every 5 second automatically.

My server spec is PIII1.1GHZ dual processor, 512K Cache, 1.5G RAM, 12MB bandwidth. Apache+MySQL+PHP.

I find that MySQL always get overloaded, when there is around 130-150 user connect to there server. Currenlty I am using my-huge.cnf for my MySQL. Any solution on this?

Now, I force to restart my apache every 2minute to reresh the apache. I know this is a bad idea, but I don't knwo how to solve it.

I would be very appreciated if someone could give me some idea. Could it be the bandwidth? MySQL overloaded? Apache? Please.. help..

Please help.. moderators..

Thanks
Louis

enterume

any idea?

Thanks
Louis

TodManPlaa

Well, it could be any of hundreds of issues...

why don't you generate a file (XML, plain text, whatever) every 5 seconds (or whatever) with the results (I'm assuming this is a gambling site of some kind) and have the members pull the data off the generated file - that way there's only 1 database hit every 5 sec.s rather than 200 logons...

Difficult to give more suggestions without more information about what is going on?

Obviously check the coding, optimise the queries etc, but I think a generated file may be a better option...

enterume

TodManPlaa,

Hey, you give me a extraordinary idea how should I query my updated information. Basically this is an business which will show some updated share information. :-)

Appreaciated of your help.

One question here, if there is around 500-1000 concurrent login and request the same file, will it cause the file locking problem? what is the better handling for this issue? or it doesn't matter?

THanks
Louis

sarahk

If you have the name of the file held by a variable eg $filename then once the file is created (with a new name) $filename can be updated.

I'd also get someone good at databases to look at your table structures, indexes etc. It could just be that your queries are not up to scratch.

TodManPlaa

Basically this is an business which will show some updated share information.

ha ha - I knew it was a gambling site ! ;-)

You're question is a good one - If you adopt Sarahk's solution then it won't be an issue, but then how will you're clients decide which file to pull down - that could get complicated very quickly...

But then - is this stuff really going to be updating every 5 seconds? The reason I ask is I've never seen a webpage update every 5 seconds - you wouldn't ever see too much!

So, if it really is updating every five seconds, then maybe generate 12 files a minute (one every 5 seconds) and call them say 5.php, 10.php, 15.php etc etc then when a client requests it, order the files in the directory and they take the second most recent (by creation time) so they have effectivly a maximum of a ten second delay on the market - but I'm really wondering if new dtaa every 5 seconds isn't a bit of overkill - I mean a lot of market resources have a 5 to 20 minute delay - that would get much easier to handle.

Anyway, if you use a system something like the above, then filelocking won't be a problem as no client would be accessing the file you are writing to right now.

anyway, I'm babbling a bit here - sounds like an interesting project

hope some of the above bable was of use

enterume

Hi TopManPlaa,

;-) Whatever so.. it is a information site.

Now i am reading some artilce from mysql to tuning MySQL to perform multhreading.. here for linux platform.

I think i will adopt the method suggest by you and sarahk to create multiple file and user query from the file alike XML structure to get the latest result, rather than straight away query to DB. And also will optimisite my query for front end and backend part.

One thing I not sure is, can multiple user concurrently read the same file? any file locking issue while reading? I am new in file handling.

Thanks
Louis

TodManPlaa

multiple and simultaneous reads of the same file should not be a problem at all as long as they are only reading it and it is not being updated as they are reading it.