[wp-trac] [WordPress Trac] #47280: SQL_CALC_FOUND_ROWS is deprecated as of MySQL 8.0.17

WordPress Trac noreply at wordpress.org
Wed Jul 20 17:07:26 UTC 2022

#47280: SQL_CALC_FOUND_ROWS is deprecated as of MySQL 8.0.17
 Reporter:  javorszky                       |       Owner:  johnbillion
     Type:  enhancement                     |      Status:  reviewing
 Priority:  normal                          |   Milestone:  Future Release
Component:  Database                        |     Version:
 Severity:  normal                          |  Resolution:
 Keywords:  has-patch has-unit-tests early  |     Focuses:  performance

Comment (by akramipro):

 @rjasdfiii - no i think you are wrong . about `DISTINCT` i tested before
 and it works fine with no errors . also there is no `GROUP BY` in my count
 query . you should read my code with more attention !
 Anyway, I tested my code in site with 3.5 million wp_postmeta records and
 I checked sql logs and all count queries executed with no error and
 paginations work like before.
 Last night my server cpu was 100% but after I fixed the count queries it's
 under 10% !!

Ticket URL: <https://core.trac.wordpress.org/ticket/47280#comment:39>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform

More information about the wp-trac mailing list