Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

which platform (operation system) better to choose for best MySql performance? windows or linux?

coonections pool for websites use or not?

share|improve this question

migrated from stackoverflow.com Jan 22 '10 at 4:22

This question came from our site for professional and enthusiast programmers.

5 Answers 5

If you have a choice I recommend putting it on a Linux box. The reason being that the Linux version is developed first and then ported. Whenever possible I like to install software on its "native" platform. I just seem to have less trouble that way.

share|improve this answer

It's essentially whatever your Ops team and hardware vendor can support, but one word of warning:

DO NOT run MySQL on a 32-bit system. Never. You will run out of address space then have a world of pain migrating.

Connection pooling isn't that bad, but you may get just as good performance without it, and it adds significant risk of bugs - connections can get left in a bad (or funny) state which breaks subsequent requests, often quite subtly. I would recommend not using pooling or persistent connections (e.g. on Apache).

On the other hand if you have a long-running daemon process, IT may want to hold connections open for its own use, as nobody "else" will use them.

share|improve this answer

If you'll be using a dedicated server, go for Linux - much easier to disable all the other stuff you won't need for a MySQL server; also, easier to tweak all kinds of parameters (TCP/IP stack comes to mind).

share|improve this answer

In general I suggest Linux. However if all your sysadmins only know windows, then forcing linux on them is a bad idea. However if you are the sysadmin team, and you don't mid either, go with Linux.

share|improve this answer

+1 for Linux, however. This all boils down to the system administrator you have available, if he does not know Linux, then what?

If your SA has never touched Linux, I would not recommend going to that platform. Hosting Linux on a production environment if you're a windows guy, is not like playing around with Ubuntu at home.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.