linux 和 windows 上的 mysql 之间的区别
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/9661345/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
differences between mysql on linux vs windows
提问by wong chung yie
Recently, My Company's considering to purchase an application using MySQL. the consultant offers two options :
最近，My Company 正在考虑购买一个使用 MySQL 的应用程序。顾问提供两种选择：
- running the apps and mysql server on windows 2008 server, or
- run the mysql server on linux an the apps on xp virtual machine
- 在 Windows 2008 服务器上运行应用程序和 mysql 服务器，或
- 在 linux 上运行 mysql 服务器，在 xp 虚拟机上运行应用程序
I was wondering if anyone could help me get the picture right. My Questions are :
我想知道是否有人可以帮我把图片弄对。我的问题是：
are there really differences on performance between MySQL running on linux and Windows server? I've browsed for some views, but have found different opinions. If there are some differences, what causing them?
what key aspect that affect the performance for a mysql server running on windows xp or windows 2008 server? I mean I don't need the server configuration stuff anyway, right?
在 linux 和 Windows 服务器上运行的 MySQL 之间的性能真的存在差异吗？我浏览了一些观点，但发现了不同的观点。如果有一些差异，是什么导致了它们？
影响在 windows xp 或 windows 2008 服务器上运行的 mysql 服务器的性能的关键方面是什么？我的意思是我不需要服务器配置的东西，对吧？
( My team has been working with both windows and linux servers, so no problem with the capabilities issue ).
（我的团队一直在使用 windows 和 linux 服务器，因此功能问题没有问题）。
Thank you for helping. :)
感谢您的帮助。:)
采纳答案by Mike Purcell
This is a question for which you will not receive an absolute right or wrong answer, as it is left to subjective opinions based on user experience, that's why people are voting to close it.
这是一个您不会得到绝对正确或错误答案的问题，因为它取决于基于用户体验的主观意见，这就是人们投票关闭它的原因。
However, to assist you, I would recommend that you use MySQL on Linux. There are a number of reasons why Linux is a better choice over windows, but some of the big ones are; security, stability, and total operating costs. Granted, with Linux it may be more complicated to set-up configs and daemons to ensure your server is running properly, but in the end, it is worth the setup.
但是，为了帮助您，我建议您在 Linux 上使用 MySQL。Linux 是比 Windows 更好的选择的原因有很多，但其中一些重要的原因是：安全性、稳定性和总运营成本。诚然，使用 Linux 设置配置和守护程序以确保您的服务器正常运行可能会更复杂，但最终，设置是值得的。
To decide which OS on which to develop the app depends on your dev shop's code expertise and experience. If they can finish the better project in a shorter duration using windows, then that's what you should opt for.
决定在哪个操作系统上开发应用取决于您的开发商店的代码专业知识和经验。如果他们可以使用 Windows 在更短的时间内完成更好的项目，那么这就是您应该选择的。
回答by Joop Eggen
Windows is a pain, but the apps might have a better quality on Windows 2008 server, than on XP. Or later on a newer Windows version. MySQL should pose less differences on both platforms. So how much better will the apps do under Windows 2008 server?
Windows 很痛苦，但 Windows 2008 服务器上的应用程序可能比 XP 上的质量更好。或稍后在较新的 Windows 版本上。MySQL 在两个平台上的差异应该较小。那么这些应用程序在 Windows 2008 服务器下的表现会有多好呢？
Maybe maintenance (XP!), maybe support for specific MS technologies.
也许维护（XP！），也许支持特定的 MS 技术。
回答by Bohemian
The main diference is that the filenames created on linux are case sensitive, whereas the files on Windows are not.
主要区别是在 linux 上创建的文件名区分大小写，而在 Windows 上创建的文件不区分大小写。
Here's an excerpt from the relevant documentationregarding cas sensitivity.
以下是有关 cas 敏感性的相关文档的摘录。
By default, table aliases are case sensitive on Unix, but not so on Windows or Mac OS X. The following statement would not work on Unix, because it refers to the alias both as a and as A:
SELECT col_name FROM tbl_name AS a WHERE a.col_name = 1 OR A.col_name = 2;
However, this same statement is permitted on Windows.
默认情况下，表别名在 Unix 上区分大小写，但在 Windows 或 Mac OS X 上不区分大小写。以下语句在 Unix 上不起作用，因为它将别名同时引用为 a 和 A：
SELECT col_name FROM tbl_name AS a WHERE a.col_name = 1 OR A.col_name = 2;
但是，允许使用相同的语句在 Windows 上。
