Here’s some stats on MySQL usage, which is feeling left out with all the PHP talk.
- 94.3% of sites are at least MySQL 5.0.
- The first 5.0.x version with real usage is 5.0.22, with 93.6% of installs at this or above.
- 90.8% of sites are at least MySQL 5.0.44.
If we choose to bump to 5.0.x, we I imagine it would be best to identify a version between 5.0.22 and 5.0.44 based on stability, features, and usage.
- Joomla is jumping from 3.23 to 5.0.4 — 94.3% of WP installs are this or above.
- Drupal is jumping from 4.1 to 5.0.15 — 94.2% of WP installs are this or above.
Oddly, neither of those show any real usage — 5.0.4 is in the double digits, and 5.0.15 is in triple digits.
Millan 8:07 am on July 14, 2010 Permalink
What about real numbers on PHP stats? Can you post them?
Alex M. 8:10 am on July 14, 2010 Permalink
PHP numbers can be found here: http://wpdevel.wordpress.com/2010/07/09/suggest-topics-for-the-july-15-2010-dev/comment-page-1/#comment-8542
Millan 8:23 am on July 14, 2010 Permalink
Thanks, I missed that.
Ramoonus 1:54 pm on July 16, 2010 Permalink
It might be me but what about MySQL 5.1 (GA) numbers?
And when your working on that, how many techies use MySQL 5.4 / 5.5? (except me)
Brian Layman 8:52 pm on July 21, 2010 Permalink
“5.0.15 is in triple digits”
Well if 100% or more of our users are running 5.0.15, I say we go with that!!!
Brian Layman 9:19 pm on July 21, 2010 Permalink
Seriously though, here are the release notes
http://dev.mysql.com/doc/refman/5.0/en/news-5-0-x.html
There’s too much for me to go over right now between 15 and 22.
I’d recommend we base the decision on:
Is 22 significantly more stable than 15?
Is there something added between 16 and 22 that we may want to rely upon?
Is there a performance improvement that we want to have associate with WP?
In short, If 22 isn’t significantly better than 15, why would we want to make it the minimum? I’d rather force people to bear the MySQL upgrade pain only when they really need to…