Title: TiDB Compatibility
Author: xuliwen
Published: <strong>6. marts, 2024</strong>
Last modified: 11. august, 2025

---

Søg plugins

![](https://ps.w.org/tidb-compatibility/assets/icon-256x256.png?rev=3046061)

# TiDB Compatibility

 Af [xuliwen](https://profiles.wordpress.org/xuliwen/)

[Download](https://downloads.wordpress.org/plugin/tidb-compatibility.1.0.2.zip)

 * [Detaljer](https://da.wordpress.org/plugins/tidb-compatibility/#description)
 * [Vurderinger](https://da.wordpress.org/plugins/tidb-compatibility/#reviews)
 * [Udvikling](https://da.wordpress.org/plugins/tidb-compatibility/#developers)

 [Support](https://wordpress.org/support/plugin/tidb-compatibility/)

## Beskrivelse

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.

### Contribute

Contribute to this plugin on [github.com/pingcap/wordpress-tidb-plugin](https://github.com/pingcap/wordpress-tidb-plugin)

## Anmeldelser

![](https://secure.gravatar.com/avatar/801609f0c0abe81fae66192822c76c94bfe99eddf8460439edd98c3f53175273?
s=60&d=retro&r=g)

### 󠀁[Must have for TiDB users](https://wordpress.org/support/topic/must-have-for-tidb-users/)󠁿

 [Otto Kekäläinen](https://profiles.wordpress.org/ottok/) 7. maj, 2025

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

 [ Læs 1 anmeldelse ](https://wordpress.org/support/plugin/tidb-compatibility/reviews/)

## Bidragsydere & udviklere

“TiDB Compatibility” er open source-software. Følgende personer har bidraget til
dette plugin.

Bidragsydere

 *   [ xuliwen ](https://profiles.wordpress.org/xuliwen/)
 *   [ it2911 ](https://profiles.wordpress.org/it2911/)

[Oversæt “TiDB Compatibility” til dit eget sprog.](https://translate.wordpress.org/projects/wp-plugins/tidb-compatibility)

### Interesseret i udvikling?

[Gennemse koden](https://plugins.trac.wordpress.org/browser/tidb-compatibility/),
tjek [SVN repository](https://plugins.svn.wordpress.org/tidb-compatibility/), eller
abonner på [udviklerloggen](https://plugins.trac.wordpress.org/log/tidb-compatibility/)
via [RSS](https://plugins.trac.wordpress.org/log/tidb-compatibility/?limit=100&mode=stop_on_copy&format=rss).

## Ændringslog

#### 1.0.2

 * Update README, tags

#### 1.0.1

 * Update README, tags and compatibility info

## Meta

 *  Version **1.0.2**
 *  Senest opdateret **11 måneder siden**
 *  Aktive installationer **60+**
 *  WordPress-version ** 4.7 eller højere **
 *  Testet op til **6.8.5**
 *  PHP-version ** 6.8.1 eller højere **
 *  Sprog
 * [English (US)](https://wordpress.org/plugins/tidb-compatibility/)
 * Tags
 * [database](https://da.wordpress.org/plugins/tags/database/)[sql](https://da.wordpress.org/plugins/tags/sql/)
 *  [Avanceret visning](https://da.wordpress.org/plugins/tidb-compatibility/advanced/)

## Bedømmelser

 5 ud af 5 stjerner.

 *  [  1 5-stjernet anmeldelse     ](https://wordpress.org/support/plugin/tidb-compatibility/reviews/?filter=5)
 *  [  0 4-stjernet anmeldelser     ](https://wordpress.org/support/plugin/tidb-compatibility/reviews/?filter=4)
 *  [  0 3-stjernet anmeldelser     ](https://wordpress.org/support/plugin/tidb-compatibility/reviews/?filter=3)
 *  [  0 2-stjernet anmeldelser     ](https://wordpress.org/support/plugin/tidb-compatibility/reviews/?filter=2)
 *  [  0 1-stjernet anmeldelser     ](https://wordpress.org/support/plugin/tidb-compatibility/reviews/?filter=1)

[Your review](https://wordpress.org/support/plugin/tidb-compatibility/reviews/#new-post)

[Se alle anmeldelser.](https://wordpress.org/support/plugin/tidb-compatibility/reviews/)

## Bidragsydere

 *   [ xuliwen ](https://profiles.wordpress.org/xuliwen/)
 *   [ it2911 ](https://profiles.wordpress.org/it2911/)

## Support

Har du noget at sige? Har du brug for hjælp?

 [Vis supportforum](https://wordpress.org/support/plugin/tidb-compatibility/)