[wp-trac] [WordPress Trac] #17998: dbDelta uses unrestricted "show all" which doesn't scale or work with DB sharding plugins (was: New Site & Upgrade process uses unrestricted "show all" causing timeouts)

[WordPress Trac]

#17998: dbDelta uses unrestricted "show all" which doesn't scale or work with DB
sharding plugins
--------------------------+------------------
 Reporter:  brianlayman   |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  3.3
Component:  Database      |     Version:  3.2
 Severity:  major         |  Resolution:
 Keywords:  needs-patch   |
--------------------------+------------------
Changes (by uglyrobot):

 * keywords:  has-patch => needs-patch


Comment:

 Fully agree, it's wasteful an doesn't scale to run a SHOW TABLES. This
 issue breaks dbDelta with our multidb plugin too
 (http://premium.wpmudev.org/project/multi-db) for the same reason. Plugins
 that use it trigger db errors as dbDelta tries to create an already
 existing table.

 If it could be switched to a "DESCRIBE $table" then sharding plugins can
 intercept that and direct it to the proper DB.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/17998#comment:10>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software