I've read that its possible to encounter a decrease in performance relative to 5.1 if 5.5 is not configured correctly.
Can anyone provide some guidelines for my.ini configuration setting changes when upgrading from 5.1 to 5.5? Our current site is performing well so I do not want to take a step backwards with performance. After configuring the my.ini settings, what tools are popular to fine tune mysql in a live environment?
Here's my current database server setup highlights:
mysql 5.1.63 , 12gb ram, 4 processors, windows 2008 r2 64 bit. About 700 courses and 3000 students
query_cache_limit = 2M
table_open_cache = 512