Regarding choosing mysql server for production server. I have Centos5 a 64bit server, for this can I go for Community Server -> "MySQL Server 5.5.23 Linux AMD64 Binary" that is in GA certified under GNU General Public License v2.0.
Also can I clarify does libaio.so packages are needed by mysql-server as a matter of dependency only for mysql versions 5.5 on any linux flavors?
So to help my business that has lots of OLTP applications can I standardize the mysql servers to have binary distributions for community server on a safer stable release "MySQL Server 5.1.63 Linux AMD64 Binary" without libaio or "MySQL Server 5.5.23 Linux AMD64 Binary" with libaio?
Is my approach is correct? Please correct me if I'm wrong. Thanks!!
Thanks guys I moved to 5.5.25 last week. But initially when application starts it does rebuilding of indeces and huge updates from few selects of abt 150 concurrent threads hitting for updates. So the server load hit upto 65% (load avg). And was never reducing. Its in innodb_flush_log_at_trx_commit | 2 | .But still the reads and writes especially was too high.. the server was thinking to give vmstat results and very slow processing the resources in server. But from DB perspective application team didn't have any problem they had their work smoothly as usual. But I felt the heat. Left untouched in any parameters then slowly it went down after 24 hrs to 0.2 %load avg. Now all is good. But I'm worried abt a concept in mysql not sure how many have noticed it. http://bugs.mysql.com/bug.php?id=65837 . I escalated but it turned into a FR. They say its a feature request , but according to me they consider it as "Forget Request". Have a look and put ur comments.. Thanks again!!