Ok guys.. here is the deal...
I got everything setup in the box.. all is fine except 1 thing.. cause to me is major...

When Mysql works in a big querry the box is melting.. and i mean totally melting.. I host a forum.. and also some other forums in other domains that are phpbb forums.... so when we do a simple search in the forum like the search we do here the box is almost down and sometimes crashes 2.

php ver 4.3.2 (isapi)
mysql 4.00.14b

D know what to say.. i tried 1 million tricks.. but i cannot prevent this from huppening... a guy told me to try to lock the processes that this 2 programs consume.. aaa and i forgot to mention the w3wp.exe is going sky high and i think this is the iis itself.

If anyone has any clue pls advice.

Thx
Chris

Why do people want to run php and mysql on windows systems? Both of these products were developed to run under linux/bsd, and do a *much* better job under said conditions. Linux and *BSD just run better in the first place period, but that's not the point

Perhaps, if you insist on using Windows, you should look into a MSSQL and ASP(.NET?)-based message board.

I have had much success with MySQL and PHP on Windows. In fact, on benchmarking PHP/IIS and PHP/Apache, I have found PHP/IIS to run much smoother than the Linux system.

Well if said benchmarks are accurate, I'd have to say it's because of Apache's "get it right, rather then fast" mentality and not the fact that it is windows running ("get it working, part of the time, even if it breaks a lot" mentality )

You'll notice this very post talks about it crawling to a halt under load, so that quasi-proves a point

Actually, that proves nothing. I am not going to get into a slinging-flight with you, simply because you have no proof to offer. Yes, this user is having problems with Windows/PHP/MySQL performance. I can show you 10 users just like him on Linux. The Operating System is not the issue in this problem.

As for your comments of "right not fast" and "work/part of the time", all I can say to you is please leave the forum. This is a Windows forum, and we are here to provide valuable assistance relating to Windows server management.

In the end, the original post does NOT quasi-prove the point. All that has been quasi-proven is that you are not openminded, and have no evidence to back your position. You have blindly made statements, and offer no proof.

I to have had no problems with MySql and PHP on Windows servers. There are many things that can affect performace from poorly indexed tables to unoptimised queries... if it's not setup properly then don't blame the software/hardware. I'm not saying that's your problem but it's a better answer than "use Linux"

I wasnt started this thread to see a fight between linux & 2k3 users... we all know that php & mysql are builded basically for linux.. but i agree with lighthouse point..
Atm the php/mysql in my box is at least 10-20% faster in normal php procedures.. but only 1 damn thing melts it... the reindexing of tables and the search function that phpbb has.. and i dont have a clue what to do about it.
Also i noticed this.. who ever has a phpbb forum when he moves it there is no reason to move the table phpbb_search_wordmatch... this table has all the posts braked in words wich gives the search result...
So when you move a phpbb forum.. you backup everything except of this (even if i want to backup that table it wasnt possible cause that table is 34mb to me).
After you restore the forum in a other server .. you have a convert function that reads all the posts and creates the search wordmatch table.
Now in linux if you do that this procedure show a php page that says something in top and you get back from linux the % of how is going... 33% 66% etc...
In 2k3 you try to do the same and this ends up to totally melt the box and sometimes even lock it.. also you dont get back nothing from the server like in linux.. no % nothing.. you just w8 there and after some minutes you get in the page the message "Tables are reindexed succesfull)
Also the linux box (celly 1300) does this in 10-15 mins and the 2k3 box (p4-2000) does it in 10 mins ...

But in all that time the box IS TOTALLY LOST from the planet
And also to someone that said why you go to phpbb.. well i cannot say to any client to use asp or mssql m8... they are free to do what they want.. but as i see it.. im doomed in this.

Thx
Chris

PHP and MySQL work beautifully on my box. What message board are you (trying) to run?

He said it was phpBB a couple of times...

PhpBB's .... also i did as test a clean install.... in a phpbb 2.0.6 .. and the trouble is same...

Also kelani is it possible to mail me or post here your php.ini and your my.ini? i will be really appreciate that if someone else has altered this settings...

Thx
Chris

P.S. I ordered extra ram... to see if that fixes the prob.. also i test and atm i run the IIS in isolation mode.. at least this solved the box crashings.

It is interesting that you did it with a clean install of phpbb and still got the same result. I had a similar issue on a linux box running vbulletin and it was an optimization issue with vbulletin when it goes over 200,000 posts. We got a script from the vbulletin boys to correct it. I might suggest checking on the phpbb forums, perhaps they have a simliar script or someone has had that similar issue in the past. I tend to agree it doesn't appear to be pointing at MySQL and PHP.

Best of luck.

Didn't read the whole thread as it started to turn into a Windows/Linux debate, but from what I read this thread could help you:

http://forum.rackshack.net/showthread.php?...hlight=php+slow

I'll do even better than that. I'll post my php.ini and my my.ini as well as the steps I took to install them both (tomorrow morning.. working a double shift tonight)


For a reference, to see how fast PHP/Mysql works for me, this is my PHPBB install, running 2.0.5 -

The Cloister

Ok now im in a position to say that all is fine..

I switched to the FastCgi solution with the turkCache and its rock fast .. plus it doenst melts the box at all..
A minor prob atm is that the reindexing now starts but after sometimes replies that there was a error cause the script or something didnt returned a correct set of variables.. or something like this.. i will try again... (i cannot do that often cause the board goes down in this procedure)
Atm the forum is without search tables :S so no search results to it.

Anyway i hope i will fix it soon...
Also Kelani i w8 your inis m8.. and thx in advance.

Chris.

P.S. This is my personnal forum im talking about No-Brakes Forum ... and the prob is that when we will start the online championships that forum will go sky high in posts..

Sorry it took so long, but here you go..
I didn't really change much, aside from the recommendations by assrted rackshack forum gurus, and a few tutorials for CF/PHP/Windows hosting (There aren't many of us weirdos)

Supposedly, these settings will work for my site, which has 1400 active members, and serves up about 65-70 GB of traffic a month, minus my MP3s from my CD. If you've purchased additional RAM or have a heavier load, you may want to adjust your settings and use the my-large.cnf and my-huge.cnf example setting files that come with Windows MySQL as your guide.

My.ini and php.ini (as txt files) are attached.


Best of luck,

Kelani

MySQL.ini attached..

I will try them asap.

For the record, the password included in both config files is a bogus one. Sorry for not mentioning that earlier

Kel

I had lost my hair man ... nice joke :s

Wasn't a joke! Just copied the INI from a folder for a test install I was running on a box here at home. Just didn't think to change it to PASSWORD. Oops! Still, I removed the attachments just so no one tries anything. I'm including them in this post..

-

----------------MY.INI-------------------

#This File was made using the WinMySQLAdmin 1.4 Tool
#8/6/2003 1:52:44 PM

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=C:/mysql
#bind-address=YOUR.IP.ADDRESS
datadir=C:/mysql/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=username
password=password

----------------