[wp-trac] [WordPress Trac] #3792: MySQL version checking

[WordPress Trac]

#3792: MySQL version checking
--------------------------+-------------------------------------------------
 Reporter:  Ozh           |       Owner:  anonymous    
     Type:  enhancement   |      Status:  new          
 Priority:  low           |   Milestone:  2.1.2        
Component:  Optimization  |     Version:               
 Severity:  normal        |    Keywords:  mysql version
--------------------------+-------------------------------------------------
 WP has pretty loose requirements (which I think is cool). Plugin coders
 can easily check what PHP version is running to make stuff compatible with
 both cutting edge PHP5 and old PHP4, but it's "harder" to check MySQL
 version since it requires a SELECT VERSION() i.e. one sql query cost. So
 if 3 plugins need to check MySQL version, that's 3 query cost ?

 I thought : it might be a good idea to test this and store it into
 wp_options, so that the info is available to all without adding an extra
 SQL query.

 Ideally this would be tested once every {lots of queries} and on /wp-
 admin/upgrade.php loading, since it's unlikely to change.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/3792>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software