Title: atec Database Author: docjojo Published: 2024 年 10 月 19 日 Last modified: 2026 年 3 月 24 日 --- 搜索插件 ![](https://ps.w.org/atec-database/assets/banner-772x250.png?rev=3172292) ![](https://ps.w.org/atec-database/assets/icon.svg?rev=3172104) # atec Database 作者：[docjojo](https://profiles.wordpress.org/docjojo/) [下载](https://downloads.wordpress.org/plugin/atec-database.1.1.34.zip) * [详情](https://cn.wordpress.org/plugins/atec-database/#description) * [评价](https://cn.wordpress.org/plugins/atec-database/#reviews) * [安装](https://cn.wordpress.org/plugins/atec-database/#installation) * [开发进展](https://cn.wordpress.org/plugins/atec-database/#developers) [支持](https://wordpress.org/support/plugin/atec-database/) ## 描述 atec Database is a powerful plugin that gives you full control over your WordPress database. Features include: * List all database tables with info (size, type, engine, rows)* Optimize, truncate, or drop any table * Clean up spam comments, trashed posts/pages, post revisions, and expired transients * Browse and manage `wp_options` entries * Set or unset autoload flag per option This plugin is lightweight and safe — all destructive actions require confirmation. ### Specifications * Database access: Uses core WPDB methods ### Third-Party Services ### Integrity check Once, when activating the plugin, an integrity check is requested from our server– if you give your permission. Source: https://atecplugins.com/ Privacy policy: https:// atecplugins.com/privacy-policy/ ## 屏幕截图 * [[ * All tables * [[ * Comments * [[ * Posts * [[ * Revisions * [[ * Transients * [[ * Options * [[ * Individual table ## 安装 1. Upload the plugin to `/wp-content/plugins/` or install via the WP admin panel. 2. Activate the plugin from the Plugins menu. 3. Select “atec Database” link in admin menu bar. ## 常见问题 ### Can I break my database with this? Only if you drop essential tables. Be cautious with destructive operations like DROP or TRUNCATE. ### Does this plugin optimize InnoDB tables? Yes. It uses `OPTIMIZE TABLE` where supported. ### Can I remove autoloaded options? Yes, you can toggle the autoload flag for individual `wp_options` entries. ## 评价 ![](https://secure.gravatar.com/avatar/d49c6f2c9c97d616e262c19b80ac95ce47ae471ef39684a0bdccdeacd35011c2? s=60&d=retro&r=g) ### 󠀁[A hidden gem to maintain your WordPress database](https://wordpress.org/support/topic/a-hidden-gem-to-maintain-your-wordpress-database/)󠁿 [Boston Tom](https://profiles.wordpress.org/tneveu/) 2025 年 7 月 16 日 1 回复 The atec Database plugin is a fantastic little tool that saved me hours of frustration. After trying several other database management plugins—some of which caused more harm than good—atec came to the rescue. With just one click, it cleared over 7,000 post revisions that were bloating my database. The tabbed interface makes it easy to navigate between cleanup tasks, from optimizing tables to fixing indexes and cleaning up comments. You can search, multi-select, and trash orphaned items, and more—no more going into your hosting company’s control panel and using the cumbersome PHPMyAdmin. It even helped me remove leftover clutter from plugins I’d tried once and forgotten about. And for advanced users, there’s an option to run SQL commands directly or upload SQL files. Deleting transients and fixing auto-loaded options is a snap. If you’re relatively new to WordPress databases, atec Database is a safe, user-friendly way to optimize your site. Always make a backup of your DB (it’s good practice) before doing major cleaning. While the plugin is free, the “Pro” version unlocks a ton of extra features. Even better, it gives you access to the Pro versions of over 45 atec plugins via the Deploy plugin. You’ll need to explore their site to see how much is included. The coding genius behind the plugins is incredibly responsive and helpful and is an email away, whether through the plugin support page or their site. And be sure to check out the caching plugins. My site speed improved by over 500%! Can’t beat that for the price. ![](https://secure.gravatar.com/avatar/c131d1fc640702864679d342c9b3ce585db4e8c0afd4c14cc676cdf864de6006? s=60&d=retro&r=g) ### 󠀁[Everything you need](https://wordpress.org/support/topic/everything-you-need-55/)󠁿 [docjojo](https://profiles.wordpress.org/docjojo/) 2024 年 10 月 19 日 Plugin has everything you need to manage, clean up and optimize the WP tables.- List all tables with table info (size, type, engine and number of items).- Optimize, truncate or drop tables.- Delete SPAM in comments, trashed pages/posts, revisions and timed out transients.- List all options and selectively remove some and set autoload option.Well-arranged features, fast and reliable – no gimmicks. [ 阅读所有2条评价 ](https://wordpress.org/support/plugin/atec-database/reviews/) ## 贡献者及开发者 「atec Database」是开源软件。 以下人员对此插件做出了贡献。 贡献者 * [ docjojo ](https://profiles.wordpress.org/docjojo/) [帮助将「atec Database」翻译成简体中文。](https://translate.wordpress.org/projects/wp-plugins/atec-database) ### 对开发感兴趣吗? 您可以[浏览代码](https://plugins.trac.wordpress.org/browser/atec-database/)，查看 [SVN仓库](https://plugins.svn.wordpress.org/atec-database/)，或通过[RSS](https://plugins.trac.wordpress.org/log/atec-database/?limit=100&mode=stop_on_copy&format=rss) 订阅[开发日志](https://plugins.trac.wordpress.org/log/atec-database/)。 ## 更新日志 #### 1.1.34 [2026.03.23] * Dashboard undefined issue #### 1.1.33 [2025.12.09] * WP 6.9 tested #### 1.1.32 [2025.12.06] * Minor fixes #### 1.1.31 [2025.12.02] * WP 6.9 tested #### 1.1.30 [2025.12.02] * WP 6.9 tested #### 1.1.29 [2025.11.04] * SVN cleanup #### 1.1.28 [2025.09.27] * Plugin prefix fixed for all #### 1.1.27 [2025.09.09] * Fixed get_plugin_base_root on WIN #### 1.1.26 [2025.08.10] * SVN update and WP clean upload #### 1.1.25 [2025.08.06] * get_plugin_base_root 👈 one level up #### 1.1.24 [2025.08.06] * Fixed get_plugin_base_root on WIN #### 1.1.23 [2025.08.03] * Changes after review #### 1.1.22 [2025.07.30] * WP_PLUGIN_DIR #### 1.1.21 [2025.07.23] * Line 424 in INIT fixed #### 1.1.20 [2025.07.22] * SVN update #### 1.1.19 [2025.07.19] * Framework changes, new ALIAS class #### 1.1.18 [2025.07.09] * $is_table #### 1.1.17 [2025.07.08] * Revisions: $max_age #### 1.1.16 [2025.07.08] * CAST revision age #### 1.1.13 [2025.07.03] * Framework change: Dashboard, SVG #### 1.1.12 [2025.06.28] * Framework change: progress(); ALIAS class #### 1.1.11 [2025.06.26] * Framework change: Removed mixed …$args #### 1.1.10 [2025.06.26] * Framework change, admin_debug_all() #### 1.1.9 [2025.06.25] * New SQL Tab #### 1.1.8 [2025.06.24] * Framework change | License check improved #### 1.1.7 [2025.06.20] * Minor fixes #### 1.1.6 [2025.06.19] * Fixed LOADER for windows #### 1.1.5 [2025.06.19] * fixed flush() #### 1.1.4 [2025.06.19] * normalize_path #### 1.1.3 [2025.06.18] * Nonce issus fixed #### 1.1.2 [2025.06.17] * SVN Update #### 1.1.1 [2025.06.17] * Integrity Fix #### 1.1.0 [2025.06.15] * AWF NextStep #### 1.0.55 [2025.06.15] * Framework change #### 1.0.54 [2025.05.30] * AWF update #### 1.0.40 [2025.05.29] * Framework: New DASHBOARD, removed WIDGET #### 1.0.39 [2025.05.23] * Framework testing #### 1.0.38 [2025.05.15] * new autoloader #### 1.0.37 [2025.05.03] * INIT::maybe_load_assets(**DIR**, \’atec_wpdp\’); #### 1.0.36 [2025.04.30] * AWF now fully namespaced #### 1.0.34 [2025.04.23] * NAMESPACE implemented #### 1.0.33 [2025.04.06] * Framework change #### 1.0.32 [2025.03.28] * class:: fix #### 1.0.31 [2025.03.18] * Added Indexes #### 1.0.30 [2025.03.16] * New style.css and check.css #### 1.0.29 [2025.03.04] * Framework changes #### 1.0.28 [2025.02.15] * (function() { #### 1.0.27 [2025.02.10] * New atec-fs filesystem #### 1.0.26 [2025.02.03] * Updated atec-check.js #### 1.0.25 [2025.02.02] * Framework changes (atec-check) #### 1.0.24 [2025.01.29] * define(\’ATEC_TOOLS_INC\’,true); // just for backwards compatibility #### 1.0.23 [2025.01.26] * switched require_once -> require #### 1.0.22 [2025.01.17] * Check button replaced #### 1.0.21 [2025.01.16] * SVN cleanup #### 1.0.20 [2025.01.08] * Added \”delete\” for table row #### 1.0.19 [2024.12.24] * Fixed style sheet #### 1.0.18 [2024.12.21] * Fixed: atec-wpdb-del-timedout.php not found #### 1.0.17 [2024.12.21] * Clean up #### 1.0.15 [2024.12.21] * New styles, cleaned up .svg #### 1.0.14 [2024.12.17] * Fixed sanitize_text_field($id) #### 1.0.13 [2024.12.07] * Framework update #### 1.0.12 [2024.12.01] * New Column CHECK TABLE #### 1.0.11 [2024.11.27] * Improved plugin activation routine #### 1.0.10 [2024.11.22] * Optimized atec-*-install.php routine #### 1.0.9 [2024.11.24] * remove options with plugin selection #### 1.0.6, 1.0.7, 1.0.8 [2024.10.19] * review – license #### 1.0.3 [2024.09.08] * Options * Tables_in_wordpress fix #### 1.0.2 [2024.08.09] * review #### 1.0.1 [2024.08.03] * Pagination #### 1.0 [2024.08.02] * Initial Release ## 额外信息 * 版本 **1.1.34** * 最后更新：**2 月前** * 活跃安装数量 **80+** * WordPress 版本 ** 4.9 或更高版本 ** * 已测试的最高版本为 **6.9.4** * PHP 版本 ** 7.4 或更高版本 ** * 语言 * [English (US)](https://wordpress.org/plugins/atec-database/) * 标签 * [cleanup](https://cn.wordpress.org/plugins/tags/cleanup/)[database](https://cn.wordpress.org/plugins/tags/database/) [Optimize](https://cn.wordpress.org/plugins/tags/optimize/)[wp db](https://cn.wordpress.org/plugins/tags/wp-db/) [wp options](https://cn.wordpress.org/plugins/tags/wp-options/) * [高级视图](https://cn.wordpress.org/plugins/atec-database/advanced/) ## 评级 5 星（最高 5 星）。 * [ 2 条 5 星评价 ](https://wordpress.org/support/plugin/atec-database/reviews/?filter=5) * [ 0 条 4 星评价 ](https://wordpress.org/support/plugin/atec-database/reviews/?filter=4) * [ 0 条 3 星评价 ](https://wordpress.org/support/plugin/atec-database/reviews/?filter=3) * [ 0 条 2 星评价 ](https://wordpress.org/support/plugin/atec-database/reviews/?filter=2) * [ 0 条 1 星评价 ](https://wordpress.org/support/plugin/atec-database/reviews/?filter=1) [Your review](https://wordpress.org/support/plugin/atec-database/reviews/#new-post) [查看全部评论](https://wordpress.org/support/plugin/atec-database/reviews/) ## 贡献者 * [ docjojo ](https://profiles.wordpress.org/docjojo/) ## 支持 有话要说吗？是否需要帮助？ [查看支持论坛](https://wordpress.org/support/plugin/atec-database/)