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

[WordPress Trac]

#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:
  changes-requested                              |  performance
-------------------------------------------------+-------------------------

Comment (by leendertvb):

 Since some of our clients were facing this issue, we decided to create a
 plugin to fix the issue for now. I know it is not ideal to use a plugin
 for this.
 Currently it provides a fix for the `posts_query` and `comments_query`
 through the filters `found_posts_query` and `found_comments_query`.
 Please let me know your thoughts on this.

 [https://wordpress.org/plugins/count-pagination-fix/]

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