MySQL on a Windows Machine

[BlueBeep]

I'm curious to know if anyone has any idea how MySQL goes with
ASP (or any other language) on a Windows machine, production
wise. Our website contains static pages and we're planning on
making them dynamic. Cost is an issue. If anyone knows how well
MySQL performs on WinNT or knows of issues I should be concerned
about, I'd appreciate hearing from you.

I've already had experience with MySQL on a Linux environment
and wondering if its Windows brother is on the same level. I
know MySQL doesn't compare with SQL Server or Oracle when it
comes to features, but it's something we're willing to give up
because of cost.

 

[Tarwn]

Well, I have seen MySQL run just fine on a windows platform (2k pro). As far as it not comparing to SQL Server or Oracle...
Well, your right, I've never used Oracle professionally. If I get my way I never will have to (I just don't like it ). As for functionality, MySQL can offer you just about as much if not more functionality (I haven't used it in a while) and generally out performs MS SQL Server in benchmark tests. Free doesn't always mean cheap

benchmarks:

http://www.eweek.com/article2/0,3959,293,00.asp

http://www.sloppycode.net/benchmark/

feature comparisons (not up to date w/ sql server 2000):

http://www.mysql.com/information/crash-me.php

(note the address, very little info is opinionated, but be careful)

http://www.ahref.com/guides/technology/199808/0824piou4.html

Anyways, hope that helps,
-Tarwn
________________________________________________________________________________
Want to get great answers to your Tek-Tips questions? Have a look at faq333-2924

 

[newbiepg]

yes mysql runs just great on Windows.I have used it on Windows 98 and windows 2000. Our site had about 4.5Mb of Data when we tried to get a structure and data export of 3 of its tables and there was no problem.

The phpMyAdmin is the same that is used in Linux so you should not have any such problems.

If you want to use it from the command prompt you need to go to the mysql and then bin folder. I have not seen any differences in commands so far between the Windows and Linux versions.

 

[BlueBeep]

Thanks for the replies. Tarwin, great articles. Read all of them. The reason why I said MySQL was less functional was because at the time that I was using it, it didn't support stored procedures and subselects, which are features I heavily rely on. I hear on 4.x they added those features in, but I'm not sure. Do you know if they added transaction rollback? newbiepg, how much traffic was your site getting? Is it a commercial site?

Thanks for the feedback.