Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

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.