As of April 2026, TiDB Compatibility is a WordPress sql plugin with 70 active installations and a 5/5 rating from 1 reviews. It has been downloaded 1.3K+ times in total. Requires WordPress 4.7+ and PHP 6.8.1+. Available on WordPress.org since 2024. Top alternative: Search & Replace.
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 @a…
| WordPress | 4.7+ requiredTested up to 6.8.5 |
| PHP | 6.8.1+ required |
Plugin data sourced from WordPress.org. Analysis and metrics by PluginSift.