MySQL Forums
Forum List  »  Performance

Re: Performance on Linux vs Windows
Posted by: Vladislav Vaintroub
Date: September 26, 2008 06:13PM

Sorry if reply is coming too late. Unfortunately there are not many benchmarks that run on Windows and Linux at the moment, so you'll have to do benchmarks yourself. I do not expect MySQL to be slow on Windows generally - but this depends on how you use MySQL. Innodb for example is well aware of some performance tricks on Windows and is using fast async IO. More advanced features like scatter/gather IO and large pages are not used. MyISAM on the other hand is completely unaware of any tricks and up to 6.0 will its implementation of preads/pwrites is serialized (in 6.0 at least that is improved), which will make it lot slower on parallel operations. Older versions of MySQL have a bug that prevents using buffers larger than 4GB on 64 bit Windows.

Options: ReplyQuote


Subject
Views
Written By
Posted
14200
June 23, 2008 11:10PM
6898
June 28, 2008 12:28AM
Re: Performance on Linux vs Windows
8188
September 26, 2008 06:13PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.