I have been running Apache 1.3.31 on Windows for quite some time now, and I am happy with the results. Apache on Windows isnt as fast as under Unix(ish) OSes, but it is very stable.
I want to create a database system for my site now. The machine is old (Pentium 166MHz, 64MB RAM). Should I put MySQL on that machine itself, or set up a second system as a database server?
If I were to go with the second machine, the system would be a Pentium 233MHz, 160MB RAM. Should I load Linux on this second machine or Windows? Is MySQL really useable under Windows?
Well if its gonna be a dedicated MySQL box, use linux. I can’t say from personal experience, but all the statistics and tests show that this is one of the applications where one really should, and people really do, use linux.
I’ve ran MySQL 3.x on a pretty old system (forgot the specs…it’s basically trashed now), but it ran pretty good. I didn’t run into any problems, and it had Win98 installed on it.
Personally, if I were you and I were running MySQL, I’d run it on Linux… it just seems easier that way. I’ve successfully run MySQL on machines of system stats lower than the one you’re looking at for databasing, so you should be fine. If you’re installing Linux, remove what you don’t need (but that’s always good advice, anyway).
That said, MySQL is usable on Windows, and I’ve done so before. I haven’t really gone beyond testing openFIRST with it (which was the reason I set up MySQL, for compatibility testing of openFIRST with Windows and various version combinations of webserver/PHP/database), though I know of other people who have.
[edit]
P.S. Maybe I should start following you around and answering your questions, I seem to be doing a fair bit of that lately, anyway.