linux和Windows上mysql之间的差异 [英] differences between mysql on linux vs windows
问题描述
最近，我的公司正在考虑使用MySQL购买应用程序.顾问提供两种选择:
Recently, My Company's considering to purchase an application using MySQL. the consultant offers two options :
- 在Windows 2008服务器上运行应用程序和mysql服务器，或者
- 在linux上运行mysql服务器，在xp虚拟机上运行应用程序
我想知道是否有人可以帮助我使图片正确.我的问题是:
I was wondering if anyone could help me get the picture right. My Questions are :
-
在Linux和Windows服务器上运行的MySQL之间在性能方面是否真的存在差异?我浏览了一些视图，但发现了不同的意见.如果存在一些差异，是什么导致它们?
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?
哪些主要方面会影响在Windows XP或Windows 2008 Server上运行的mysql服务器的性能?我的意思是我根本不需要服务器配置，对吧?
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?
(我的团队一直在使用Windows和Linux服务器，因此功能问题没有问题.)
( My team has been working with both windows and linux servers, so no problem with the capabilities issue ).
感谢您的帮助. :)
推荐答案
这是一个您不会获得绝对正确或错误答案的问题，因为它取决于用户体验，因此只能接受主观意见，因此人们投票关闭它.
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.
但是，为了帮助您，我建议您在Linux上使用MySQL.有很多原因可以使Linux比Windows更好的选择，但是其中一些大的原因是:安全性，稳定性和总运营成本.当然，对于Linux，设置配置和守护程序以确保服务器正常运行可能会更加复杂，但是最后值得进行设置.
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.
要决定在哪个OS上开发应用程序，取决于您的开发商店的代码专业知识和经验.如果他们可以使用Windows在较短的时间内完成更好的项目，那么这就是您应该选择的.
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.
这篇关于linux和Windows上mysql之间的差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
