plugin_slug,
array($this, 'render_admin_page'),
'dashicons-database-view',
80
);
}
public function enqueue_admin_assets($hook) {
if (strpos($hook, $this->plugin_slug) === false) {
return;
}
// Enqueue jQuery (already included in WordPress)
wp_enqueue_script('jquery');
// Enqueue inline styles
wp_register_style($this->plugin_slug . '-inline', false);
wp_enqueue_style($this->plugin_slug . '-inline');
wp_add_inline_style($this->plugin_slug . '-inline', $this->get_styles());
}
public function output_admin_scripts() {
global $pagenow;
if (isset($_GET['page']) && $_GET['page'] === $this->plugin_slug) {
?>
get_database_stats();
?>
🚀 Database Optimizer Pro
Професионален инструмент за оптимизация и почистване на WordPress база данни
Размер на БД
Общ размер на базата данни
Таблици
Общо таблици в БД
Overhead
Неизползвано място в таблици
Оптимизации
Брой оптимизации
⚠️ Натиснете "Сканирай база данни" за да започнете анализ
ℹ️ Оптимизацията ще подобри производителността на базата данни чрез реорганизация на таблиците
За плъгина
Database Optimizer Pro е професионален инструмент за поддръжка на WordPress база данни.
Функции:
✅ Почистване на orphaned metadata
✅ Изтриване на изтекли transients
✅ Премахване на ревизии и автосъхранения
✅ Изчистване на спам и изтрити коментари
✅ Оптимизация на всички таблици
✅ Подробна статистика и визуализация
⚠️ Препоръчително: Направете backup на базата данни преди да извършвате операции!
💡 Pro Tip: Редовната поддръжка на базата данни подобрява производителността на сайта.
get_var("
SELECT ROUND(SUM(data_length + index_length) / 1024 / 1024, 2)
FROM information_schema.tables
WHERE table_schema = DATABASE()
") . ' MB';
$total_tables = $wpdb->get_var("
SELECT COUNT(*)
FROM information_schema.tables
WHERE table_schema = DATABASE()
");
$overhead = $wpdb->get_var("
SELECT ROUND(SUM(data_free) / 1024 / 1024, 2)
FROM information_schema.tables
WHERE table_schema = DATABASE()
AND ENGINE = 'InnoDB'
") . ' MB';
return array(
'db_size' => $db_size,
'total_tables' => $total_tables,
'overhead' => $overhead
);
}
public function ajax_scan_database() {
check_ajax_referer('dbop_nonce', 'nonce');
if (!current_user_can('manage_options')) {
wp_send_json_error(array('message' => 'Недостатъчни права'));
}
global $wpdb;
$data = array(
'orphaned_postmeta' => $this->count_orphaned_postmeta(),
'orphaned_commentmeta' => $this->count_orphaned_commentmeta(),
'orphaned_usermeta' => $this->count_orphaned_usermeta(),
'orphaned_termmeta' => $this->count_orphaned_termmeta(),
'expired_transients' => $this->count_expired_transients(),
'post_revisions' => $this->count_post_revisions(),
'auto_drafts' => $this->count_auto_drafts(),
'trashed_posts' => $this->count_trashed_posts(),
'spam_comments' => $this->count_spam_comments(),
'trashed_comments' => $this->count_trashed_comments()
);
wp_send_json_success($data);
}
public function ajax_clean_items() {
check_ajax_referer('dbop_nonce', 'nonce');
if (!current_user_can('manage_options')) {
wp_send_json_error(array('message' => 'Недостатъчни права'));
}
$type = sanitize_text_field($_POST['type']);
$deleted = 0;
switch ($type) {
case 'orphaned_postmeta':
$deleted = $this->clean_orphaned_postmeta();
break;
case 'orphaned_commentmeta':
$deleted = $this->clean_orphaned_commentmeta();
break;
case 'orphaned_usermeta':
$deleted = $this->clean_orphaned_usermeta();
break;
case 'orphaned_termmeta':
$deleted = $this->clean_orphaned_termmeta();
break;
case 'expired_transients':
$deleted = $this->clean_expired_transients();
break;
case 'post_revisions':
$deleted = $this->clean_post_revisions();
break;
case 'auto_drafts':
$deleted = $this->clean_auto_drafts();
break;
case 'trashed_posts':
$deleted = $this->clean_trashed_posts();
break;
case 'spam_comments':
$deleted = $this->clean_spam_comments();
break;
case 'trashed_comments':
$deleted = $this->clean_trashed_comments();
break;
}
wp_send_json_success(array('deleted' => $deleted));
}
public function ajax_optimize_tables() {
check_ajax_referer('dbop_nonce', 'nonce');
if (!current_user_can('manage_options')) {
wp_send_json_error(array('message' => 'Недостатъчни права'));
}
global $wpdb;
$optimized = 0;
$tables = $wpdb->get_results("SHOW TABLES", ARRAY_N);
foreach ($tables as $table) {
$table_name = $table[0];
$result = $wpdb->query("OPTIMIZE TABLE `{$table_name}`");
if ($result !== false) {
$optimized++;
}
}
// Update optimization count
$count = get_option('dbop_optimization_count', 0);
update_option('dbop_optimization_count', $count + 1);
wp_send_json_success(array(
'optimized' => $optimized,
'stats' => $this->get_database_stats()
));
}
public function ajax_get_stats() {
check_ajax_referer('dbop_nonce', 'nonce');
if (!current_user_can('manage_options')) {
wp_send_json_error(array('message' => 'Недостатъчни права'));
}
wp_send_json_success($this->get_database_stats());
}
// Count methods
private function count_orphaned_postmeta() {
global $wpdb;
return (int)$wpdb->get_var("
SELECT COUNT(*)
FROM {$wpdb->postmeta} pm
LEFT JOIN {$wpdb->posts} p ON pm.post_id = p.ID
WHERE p.ID IS NULL
");
}
private function count_orphaned_commentmeta() {
global $wpdb;
return (int)$wpdb->get_var("
SELECT COUNT(*)
FROM {$wpdb->commentmeta} cm
LEFT JOIN {$wpdb->comments} c ON cm.comment_id = c.comment_ID
WHERE c.comment_ID IS NULL
");
}
private function count_orphaned_usermeta() {
global $wpdb;
return (int)$wpdb->get_var("
SELECT COUNT(*)
FROM {$wpdb->usermeta} um
LEFT JOIN {$wpdb->users} u ON um.user_id = u.ID
WHERE u.ID IS NULL
");
}
private function count_orphaned_termmeta() {
global $wpdb;
return (int)$wpdb->get_var("
SELECT COUNT(*)
FROM {$wpdb->termmeta} tm
LEFT JOIN {$wpdb->terms} t ON tm.term_id = t.term_id
WHERE t.term_id IS NULL
");
}
private function count_expired_transients() {
global $wpdb;
return (int)$wpdb->get_var("
SELECT COUNT(*)
FROM {$wpdb->options}
WHERE option_name LIKE '_transient_timeout_%'
AND option_value < UNIX_TIMESTAMP()
");
}
private function count_post_revisions() {
global $wpdb;
return (int)$wpdb->get_var("
SELECT COUNT(*)
FROM {$wpdb->posts}
WHERE post_type = 'revision'
");
}
private function count_auto_drafts() {
global $wpdb;
return (int)$wpdb->get_var("
SELECT COUNT(*)
FROM {$wpdb->posts}
WHERE post_status = 'auto-draft'
");
}
private function count_trashed_posts() {
global $wpdb;
return (int)$wpdb->get_var("
SELECT COUNT(*)
FROM {$wpdb->posts}
WHERE post_status = 'trash'
");
}
private function count_spam_comments() {
global $wpdb;
return (int)$wpdb->get_var("
SELECT COUNT(*)
FROM {$wpdb->comments}
WHERE comment_approved = 'spam'
");
}
private function count_trashed_comments() {
global $wpdb;
return (int)$wpdb->get_var("
SELECT COUNT(*)
FROM {$wpdb->comments}
WHERE comment_approved = 'trash'
");
}
// Clean methods
private function clean_orphaned_postmeta() {
global $wpdb;
return (int)$wpdb->query("
DELETE pm FROM {$wpdb->postmeta} pm
LEFT JOIN {$wpdb->posts} p ON pm.post_id = p.ID
WHERE p.ID IS NULL
");
}
private function clean_orphaned_commentmeta() {
global $wpdb;
return (int)$wpdb->query("
DELETE cm FROM {$wpdb->commentmeta} cm
LEFT JOIN {$wpdb->comments} c ON cm.comment_id = c.comment_ID
WHERE c.comment_ID IS NULL
");
}
private function clean_orphaned_usermeta() {
global $wpdb;
return (int)$wpdb->query("
DELETE um FROM {$wpdb->usermeta} um
LEFT JOIN {$wpdb->users} u ON um.user_id = u.ID
WHERE u.ID IS NULL
");
}
private function clean_orphaned_termmeta() {
global $wpdb;
return (int)$wpdb->query("
DELETE tm FROM {$wpdb->termmeta} tm
LEFT JOIN {$wpdb->terms} t ON tm.term_id = t.term_id
WHERE t.term_id IS NULL
");
}
private function clean_expired_transients() {
global $wpdb;
$time = time();
$transients = $wpdb->get_col("
SELECT option_name
FROM {$wpdb->options}
WHERE option_name LIKE '_transient_timeout_%'
AND option_value < {$time}
");
$deleted = 0;
foreach ($transients as $transient) {
$key = str_replace('_transient_timeout_', '', $transient);
delete_transient($key);
$deleted++;
}
return $deleted;
}
private function clean_post_revisions() {
global $wpdb;
return (int)$wpdb->query("
DELETE FROM {$wpdb->posts}
WHERE post_type = 'revision'
");
}
private function clean_auto_drafts() {
global $wpdb;
return (int)$wpdb->query("
DELETE FROM {$wpdb->posts}
WHERE post_status = 'auto-draft'
");
}
private function clean_trashed_posts() {
global $wpdb;
return (int)$wpdb->query("
DELETE FROM {$wpdb->posts}
WHERE post_status = 'trash'
");
}
private function clean_spam_comments() {
global $wpdb;
return (int)$wpdb->query("
DELETE FROM {$wpdb->comments}
WHERE comment_approved = 'spam'
");
}
private function clean_trashed_comments() {
global $wpdb;
return (int)$wpdb->query("
DELETE FROM {$wpdb->comments}
WHERE comment_approved = 'trash'
");
}
}
// Initialize the plugin
function db_optimizer_pro_init() {
new DB_Optimizer_Pro();
}
add_action('plugins_loaded', 'db_optimizer_pro_init');