"SQL VACUUM" operation

SigmaTel71 · Post by **SigmaTel71** » Wed Jun 20, 2018 3:25 pm

Is it safe to perform this operation on the phpBB's database? I wanted to perform some kind of little cleanup or optimisation.

Post by **stevemaury** » Wed Jun 20, 2018 5:27 pm

What is an "SQL vacuum operation"?

3Di · Post by **3Di** » Wed Jun 20, 2018 8:27 pm

stevemaury wrote: ↑
Wed Jun 20, 2018 5:27 pm
What is an "SQL vacuum operation"?

Like defragging a filesystem. Is in MySQL, sqlite and PostgreSQL.

Post by **stevemaury** » Wed Jun 20, 2018 8:52 pm

Ah, optimization.

3Di · Post by **3Di** » Wed Jun 20, 2018 8:58 pm

Not really, sort of.

For to optimize a MySql DB of a phpBB install there is this: https://www.phpbb.com/customise/db/exte ... pair_tool/

SigmaTel71 · Post by **SigmaTel71** » Thu Jun 21, 2018 12:14 pm

3Di wrote: ↑
Wed Jun 20, 2018 8:58 pm
For to optimize a MySql DB of a phpBB install there is this: https://www.phpbb.com/customise/db/exte ... pair_tool/

Is it compatible with phpBB 3.2.2? It's validated for 3.2.0.

UPD: Yes, it is.

SigmaTel71 · Post by **SigmaTel71** » Thu Jun 21, 2018 12:24 pm

Code: Select all

phpbb_acl_groups ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_acl_options ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_acl_roles ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_acl_roles_data ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_acl_users ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_attachments ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_banlist ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_bbcodes ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_bookmarks ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_bots ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_config ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_config_text ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_confirm ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_disallow ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_drafts ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_ext ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_extension_groups ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_extensions ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_forums ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_forums_access ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_forums_track ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_forums_watch ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_groups ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_icons ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_lang ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_log ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_login_attempts ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_migrations ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_moderator_cache ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_modules ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_notification_types ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_notifications ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_oauth_accounts ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_oauth_states ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_oauth_tokens ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_poll_options ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_poll_votes ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_posts ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_privmsgs ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_privmsgs_folder ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_privmsgs_rules ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_privmsgs_to ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_profile_fields ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_profile_fields_data ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_profile_fields_lang ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_profile_lang ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_ranks ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_reports ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_reports_reasons ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_search_results ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_search_wordlist ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_search_wordmatch ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_sessions ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_sessions_keys ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_sitelist ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_smilies ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_styles ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_teampage ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_topics ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_topics_posted ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_topics_track ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_topics_watch ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_user_group ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_user_notifications ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_users ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_warnings ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_words ... note: Table does not support optimize, doing recreate + analyze instead
phpbb_zebra ... note: Table does not support optimize, doing recreate + analyze instead

Woah... it dropped me this!
I'm using InnoDB-styled DB with MySQLi 5.6.37. The size decreased from 6.98 Mbytes to 6.28 Mbytes. Thanks!

advertisements