MySQL: Windows or Linux? [closed]

1

Which one performs best for dedicated server with MySQL considering several complex calculations in Stored Procedure and Functions?

    
asked by anonymous 02.07.2015 / 22:04

2 answers

3

There are advantages to using Linux for this purpose, as others might say, but from a point of view about performance , for many applications you will not see much difference. >

While Linux would be my recommendation , if you are more familiar with WIndows and do not have much experience as sysadmin Linux , choose Windows. Being aware of fixing certain things makes you gain in time and consequently in money since, repeating between them, there will not be much difference.

But note, Windows is slower when creating files. 40 InnoDB tables involve 40 or 80 file creations.

A good practice in MySQL would be to create tables at once and not create / delete tables often. If your application was designed to create / delete multiple tables, Linux is certainly the right one.

If your application uses temporary tables a good deal of time, MySQL 5.7 has significantly changed performance (in ambos os OS ) in this area.

Something else , if the dedicated server in question is to serve another type of content (eg web / PHP), my recommendation will be succinct in choosing Linux instead Windows .

    
02.07.2015 / 22:42
2

Very difficult to answer this question in the performance question, since everything is relative, we would have to try to simulate an equal environment for both and test several aspects, for example:

  • The same hardware , cutting-edge hardware may end up benefiting a platform and hardware from other minimum requirements in the issue cost benefit to small banks few tables etc, or giant banks,
  • Queries running local or network , then we could already have 1 point for each, and this type of test can be strange because they say location is the which counts and gives a point to one, but the database is usually consulted by network clients and the performance ends up being measured by the other processes involved and not directly MySql software.

  • Would it be valid to do a customization ? In this requirement I do not know to what extent it would be fair for both, to keep the best configurations for the windows platform and to use these parameters in linux? or vise versa? Any configuration would be unfair because it will end up benefiting one or the other.

  • We would use maximum or minimum values for memories and buffers, so believe me, it can give a better performance for one in small banks and another when it's too big.

So if we use all the possibilities we would have 1 winner for each situation / metrics used.

Following is an example link

    
02.07.2015 / 23:00