"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.
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:

"SQL VACUUM" operation

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.
Last edited by kinerity on Mon Aug 20, 2018 3:51 pm, edited 1 time in total.
Reason: Topic icon changed
Hello, Moto! :D

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 50916
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: "SQL VACUUM" operation

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

What is an "SQL vacuum operation"?
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)

User avatar
3Di
Former Team Member
Posts: 14465
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: "SQL VACUUM" operation

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.
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
✒️ Black Friday 2019 @ The Studio ▪️◾️

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 50916
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: "SQL VACUUM" operation

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

Ah, optimization.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)

User avatar
3Di
Former Team Member
Posts: 14465
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: "SQL VACUUM" operation

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/
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
✒️ Black Friday 2019 @ The Studio ▪️◾️

User avatar
SigmaTel71
Registered User
Posts: 10
Joined: Tue May 15, 2018 6:04 pm
Location: Tula, Russian Federation
Name: Vitaliy Orekhov
Contact:

Re: "SQL VACUUM" operation

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.
Hello, Moto! :D

User avatar
SigmaTel71
Registered User
Posts: 10
Joined: Tue May 15, 2018 6:04 pm
Location: Tula, Russian Federation
Name: Vitaliy Orekhov
Contact:

Re: "SQL VACUUM" operation

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

Post Reply

Return to “[3.2.x] Support Forum”