netmix / radio-station

Radio Station WordPress Plugin (Open Source)
https://netmix.com
GNU General Public License v3.0
19 stars 14 forks source link

[Freemius Debug] Bloated wp7f_fs_logger.ibd database identified #480

Open astevens93 opened 5 months ago

astevens93 commented 5 months ago

Describe the bug My hosting provider has raised concerns for wp7f_fs_logger.ibd (which is generated by Freemius and Radio Station) is nearly 20gb in size and is creating performance issues.

To Reproduce Steps to reproduce the behavior: Check wordpress database files for wp7f_fs_logger.ibd.

Expected behavior Not as large.

Screenshots If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information): N/A

Smartphone (please complete the following information): N/A

Additional context Is there anyway I can disable Freemius Debugger (I've looked I cannot find anything obvious) that is shown my my wordpress site at the moment, and is there a safe way to remove the freemius database as above to cancel out this issue?

I'm not familiar with the way freemius works, but currently it is bloatware on the site.

Using Radio Station Pro.

astevens93 commented 5 months ago
image image
tonyzeoli commented 5 months ago

whoa! that's hefty...okay, let me check it out and get back to you. Have to ask FReemius for support on this.

On Wed, Jan 31, 2024 at 2:41 AM astevens93 @.***> wrote:

image.png (view on web) https://github.com/netmix/radio-station/assets/67294458/d4efef8b-2e11-4849-b5f0-8abd4a914f86 image.png (view on web) https://github.com/netmix/radio-station/assets/67294458/39a3c2f5-e0c5-428e-89f2-17487d750957

— Reply to this email directly, view it on GitHub https://github.com/netmix/radio-station/issues/480#issuecomment-1918553326, or unsubscribe https://github.com/notifications/unsubscribe-auth/AA65WO6GBYEXU44KEPLDLCLYRHYTTAVCNFSM6AAAAABCSR44AOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSMJYGU2TGMZSGY . You are receiving this because you are subscribed to this thread.Message ID: @.***>

-- [image: photo] Tony Zeoli Founder, Digital Strategy Works LLC O (828) 412-0990 <(828)+412-0990> M (917) 705-4700 <(917)+705-4700> E @. @.> W https://digitalstrategyworks.com Whatsapp 9177054700 Skype tonyzeoli Clubhouse @tonyzeoli

[image: facebook] http://www.facebook.com/digitalstrategyworks

[image: twitter] http://www.twitter.com/dswks

[image: linkedin] http://www.linkedin.com/company/digital-strategy-works

[image: googleplus] http://plus.google.com/digitalstrategyworks

[image: slideshare] https://slideshare.com/tonyzeoli

[image: aboutme] https://about.me/tonyzeoli

[image: angelList] https://angel.co/tonyzeoli

[image: App Social Buttons Image] https://facebook.com/digitalstrategyworks [image: App Social Buttons Image] http://dswks [image: App Social Buttons Image] https://linkedin.com/in/+tonyzeoli [image: App Social Buttons Image] https://www.youtube.com/+digitalstrategyworks

Schedule a Call https://calendly.com/tonyzeoli

Schedule a Call [image: arrow] https://calendly.com/tonyzeoli

Schedule a Call https://calendly.com/tonyzeoli

[image: tpx]

tonyzeoli commented 5 months ago

Okay, here's the tutorial on turning on/off the Freemus debugger: https://freemius.com/help/documentation/wordpress-sdk/debugging/.

I can't imagine that it's automatically turned on, but I'll ask why that is. Will keep this ticket open until I learn more.

astevens93 commented 5 months ago

Thanks @tonyzeoli well that was a nice simple fix, it's disappeared from my WP Menu now, after changing it to false in Wp-config. I need to clear that database table now...

tonyzeoli commented 5 months ago

I'm just curious as to how it was activated in the first place. I don't see it activated on the demo site. Were you debugging something a while ago and learned to turn it on? Or, was it always on after it was installed?

astevens93 commented 5 months ago

I have a feeling @majick777 was doing some debugging on the site and I never turned it off!

majick777 commented 5 months ago

@astevens93 Sorry if that was the case, I didn't realize this level of debugging information was kept logged.

@tonyzeoli Perhaps we could suggest to Freemius to have a default limit to the number of debug days stored eg. 30, to prevent other Freemius customers from experiencing similar.

tonyzeoli commented 5 months ago

@majick777 Sure, I can mention that. I think he ended up turning it on himself and just forgot to turn it off. There should be some sort of reminder.

tonyzeoli commented 5 months ago

This issue is closed.

astevens93 commented 4 months ago

Hello again @tonyzeoli @majick777 - this is still an ongoing issue it seems, even though I have turned it off in wp-config.

The file is clearly the Premium RadioStation but the request URL is a completely different API used by a seperate plugin.

I really don't know enough about Freemius to solve this myself - do you suggest I reach out to Freemius directly? I only ask here because it seems related to RadioStation from the log.

image
majick777 commented 3 months ago

@astevens93 I sent an email to Freemius support regarding this, they might comment here or get back to my email.

What I'd say it likely is that you possible have another plugin (Metaradio?) installed that also uses Freemius. I believe Freemius has code to only load one instance of itself... so it might be loading Radio Station Pro's Freemius and then performing an action to debug Metaradio? That's my guess but we'll see what Freemius says.

astevens93 commented 3 months ago

Thanks @majick777 these are the installs Freemius is installed on - tablepress I am not seeing any issues with or having that logged as the plugin that's logging

image
majick777 commented 3 months ago

@astevens93 Here's the reply from Freemius, I guess they want to double check if debug mode is showing as disabled?

"Could you please ask them to check if debug mode is enabled on this page? /wp-admin/plugins.php?page=freemius or /wp-admin/network/plugins.php?page=freemius If that is the case, please ask them to disable the debug mode from that page.

We actually already have an in-progress task that aims to automatically disable the debug mode after 24 hours. You can check the details here: https://github.com/Freemius/wordpress-sdk/pull/691

Regarding the API calls that you mentioned, those are not coming from our SDK. As @majick777 pointed out, they may be related to another plugin that is also using the SDK. Even when there are multiple Freemius-powered plugins activated on a site, only one instance of the SDK can be active at a time and it's loaded from the plugin/theme that has the latest version of the SDK."

Even then, I'm not sure why Metaradio JSON request endpoints are showing in the Freemius debugger if it isn't a Freemius-related plugin. Perhaps it is just logging all REST endpoint requests as a matter of course for conflict checking...? But I don't think that would be happening unless debug mode is actually still on somehow... have you checked your wp-config.php to make sure there isn't a define statement that is enabling it regardless?