{"id":183780,"date":"2024-03-06T04:23:07","date_gmt":"2024-03-06T04:23:07","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/tidb-compatibility\/"},"modified":"2025-08-11T08:23:48","modified_gmt":"2025-08-11T08:23:48","slug":"tidb-compatibility","status":"publish","type":"plugin","link":"https:\/\/wordpress.org\/plugins\/tidb-compatibility\/","author":21125060,"comment_status":"closed","ping_status":"closed","template":"","meta":{"version":"1.0.2","stable_tag":"1.0.2","tested":"6.8.5","requires":"4.7","requires_php":"6.8.1","requires_plugins":null,"header_name":"TiDB Compatibility","header_author":"it2911","header_description":"Optimize slow queries in WordPress.","assets_banners_color":"efdfe3","last_updated":"2025-08-11 08:23:48","external_support_url":"","external_repository_url":"","donate_link":"","header_plugin_uri":"","header_author_uri":"https:\/\/github.com\/it2911","rating":5,"author_block_rating":0,"active_installs":70,"downloads":1310,"num_ratings":1,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","changelog"],"tags":{"1.0.0":{"tag":"1.0.0","author":"xuliwen","date":"2024-03-07 02:42:10"},"1.0.1":{"tag":"1.0.1","author":"xuliwen","date":"2025-05-28 02:47:50"},"1.0.2":{"tag":"1.0.2","author":"xuliwen","date":"2025-08-11 08:23:48"}},"upgrade_notice":[],"ratings":{"1":0,"2":0,"3":0,"4":0,"5":1},"assets_icons":{"icon-256x256.png":{"filename":"icon-256x256.png","revision":3046061,"resolution":"256x256","location":"assets","locale":""}},"assets_banners":{"banner-1544x500.jpeg":{"filename":"banner-1544x500.jpeg","revision":3046052,"resolution":"1544x500","location":"assets","locale":""}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["1.0.0","1.0.1","1.0.2"],"block_files":[],"assets_screenshots":[],"screenshots":[],"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[153,1625,225129],"plugin_category":[59],"plugin_contributors":[225166],"plugin_business_model":[],"class_list":["post-183780","plugin","type-plugin","status-publish","hentry","plugin_tags-database","plugin_tags-sql","plugin_tags-tidb","plugin_category-utilities-and-tools","plugin_contributors-it2911","plugin_committers-xuliwen"],"banners":[],"icons":{"svg":false,"icon":"https:\/\/ps.w.org\/tidb-compatibility\/assets\/icon-256x256.png?rev=3046061","icon_2x":"https:\/\/ps.w.org\/tidb-compatibility\/assets\/icon-256x256.png?rev=3046061","generated":false},"screenshots":[],"raw_content":"<!--section=description-->\n<p>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.<\/p>\n\n<p>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<\/p>\n\n<p>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.<\/p>\n\n<p>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.<\/p>\n\n<h3>Contribute<\/h3>\n\n<p>Contribute to this plugin on <a href=\"https:\/\/github.com\/pingcap\/wordpress-tidb-plugin\">github.com\/pingcap\/wordpress-tidb-plugin<\/a><\/p>\n\n<!--section=changelog-->\n<h4>1.0.2<\/h4>\n\n<ul>\n<li>Update README, tags<\/li>\n<\/ul>\n\n<h4>1.0.1<\/h4>\n\n<ul>\n<li>Update README, tags and compatibility info<\/li>\n<\/ul>","raw_excerpt":"This plugin is an official tool provided by PingCAP, designed to solve compatibility issues between TiDB and WordPress.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/183780","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=183780"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/xuliwen"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=183780"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=183780"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=183780"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=183780"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=183780"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=183780"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}