phpBB • Free and Open Source Forum Software

RSS Facebook Twitter
Menu

"SQL VACUUM" operation

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations
Post Reply
User avatar
SigmaTel71
Registered User
Posts: 10
Joined: Tue May 15, 2018 6:04 pm
Location: Tula, Russian Federation
Name: Vitaliy Orekhov
Contact:
Contact SigmaTel71

"SQL VACUUM" operation

Post by SigmaTel71 »

Is it safe to perform this operation on the phpBB's database? I wanted to perform some kind of little cleanup or optimisation.
Last edited by Kailey on Mon Aug 20, 2018 3:51 pm, edited 1 time in total.
Reason: Topic icon changed
Hello, Moto! :D
Top
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 52768
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:
Contact stevemaury

Re: "SQL VACUUM" operation

Post by stevemaury »

What is an "SQL vacuum operation"?
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
Top
User avatar
3Di
I've Been Banned!
Posts: 17538
Joined: Mon Apr 04, 2005 11:09 pm
Location: I'm with Ukraine 🇺🇦
Name: Marco
Contact:
Contact 3Di

Re: "SQL VACUUM" operation

Post by 3Di »

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.
🆓 Free support for our extensions also provided here: phpBB Studio
🚀 Looking for a specific feature or alternative option? We will rock you!
Please PM me only to request paid works. Thx. Buy me a coffee -> Image
My development's activity º PhpStorm's proud user º Extensions, Scripts, MOD porting, Update/Upgrades
Top
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 52768
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:
Contact stevemaury

Re: "SQL VACUUM" operation

Post by stevemaury »

Ah, optimization.
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
Top
User avatar
3Di
I've Been Banned!
Posts: 17538
Joined: Mon Apr 04, 2005 11:09 pm
Location: I'm with Ukraine 🇺🇦
Name: Marco
Contact:
Contact 3Di

Re: "SQL VACUUM" operation

Post by 3Di »

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/
🆓 Free support for our extensions also provided here: phpBB Studio
🚀 Looking for a specific feature or alternative option? We will rock you!
Please PM me only to request paid works. Thx. Buy me a coffee -> Image
My development's activity º PhpStorm's proud user º Extensions, Scripts, MOD porting, Update/Upgrades
Top
User avatar
SigmaTel71
Registered User
Posts: 10
Joined: Tue May 15, 2018 6:04 pm
Location: Tula, Russian Federation
Name: Vitaliy Orekhov
Contact:
Contact SigmaTel71

Re: "SQL VACUUM" operation

Post by SigmaTel71 »

3Di wrote: ↑Wed Jun 20, 2018 8:58 pmFor 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.
Hello, Moto! :D
Top
User avatar
SigmaTel71
Registered User
Posts: 10
Joined: Tue May 15, 2018 6:04 pm
Location: Tula, Russian Federation
Name: Vitaliy Orekhov
Contact:
Contact SigmaTel71

Re: "SQL VACUUM" operation

Post by SigmaTel71 »

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!
Hello, Moto! :D
Top
Post Reply

Return to “[3.2.x] Support Forum”