Mi7oSz

Thanks to this plugin you will see list of queries that are requested from your database. It?s extremely helpful, if you need to investigate what is causing your website to perform slowly. Thanks to full list of formatted and highlighted SQL queries, finding plugin or template file which is killing your website is easy.

SM – SQL logs

Record and view all SQL queries that your WordPress is requesting. Browse formated and highlighted syntax queries for debug and speedup your site.

it2911

TiDB is a high-performance database that is compatible with the MySQL protocol. Since MySQL has deprecated the SQL_CALC_FOUND_ROWS function, TiDB also has no intention of offering the SQL_CALC_FOUND_ROWS function. This leads to an error in WordPress when using TiDB, indicating that SQL_CALC_FOUND_ROWS is not supported, and submissions cannot be displayed correctly.
WordPress is also currently working on this issue, but it seems that more time is needed. #47280 Remove usage of deprecated MySQL SQL_CALC_FOUND_ROWS from WP_Query
This plugin solves the issue of TiDB not providing the SQL_CALC_FOUND_ROWS function. Once this plugin is activated, parts of WP_Query that use SQL_CALC_FOUND_ROWS will be replaced with the COUNT(*) function.
This plugin is entirely based on the method mentioned by @akramipro in the article, and this solution works perfectly and addresses the issue. I’ve turned this method into a plugin so that those using TiDB can easily resolve this problem. Many thanks to @akramipro for the excellent work, and I hope the official WordPress team can address this issue sooner.
<h3>Contribute</h3>
Contribute to this plugin on <a href="https://github.com/pingcap/wordpress-tidb-plugin" rel="nofollow ugc">github.com/pingcap/wordpress-tidb-plugin</a>

TiDB Compatibility


This plugin is a must-have if you are running TiDB as the database instead of MySQL/MariaDB.


Must have for TiDB users

This plugin is an official tool provided by PingCAP, designed to solve compatibility issues between TiDB and WordPress.

SM – SQL logs vs TiDB Compatibility