[wp-trac] [WordPress Trac] #33885: meta_form performs a potentially expensive query

[WordPress Trac]

#33885: meta_form performs a potentially expensive query
-------------------------------------+-------------------------------------
 Reporter:  jorbin                   |       Owner:  (none)
     Type:  defect (bug)             |      Status:  closed
 Priority:  normal                   |   Milestone:
Component:  Administration           |     Version:  4.3.1
 Severity:  normal                   |  Resolution:  invalid
 Keywords:  has-patch needs-testing  |     Focuses:  administration,
  needs-unit-tests needs-refresh     |  performance
  close                              |
-------------------------------------+-------------------------------------

Comment (by OllieJones):

 It seems unlikely that a conversion of LONGTEXT to MEDIUMTEXT would result
 in a 60% table data size reduction; both are BLOB data types, and plus,
 really long meta_value values are ordinarily quite rare.

 The same is true of conversion of meta_key from VARCHAR(255) to
 VARCHAR(191), for similar reasons.

 I wonder whether the contents of that table, or its on-disk structure, are
 somehow anomalous?

 (I am happy I am not in the budget hosting business, by the way. It must
 be painful to have your most successful customers start having trouble
 because of their success. That's a long way of saying you, @perlfan, may
 need to upgrade hosting.)

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/33885#comment:109>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform