SOLVED Logs in database

[marius-ciclistu]

Hi,

I saw that there is a table with logs in the database.
My question is related to the fact that I saw in the forums that an osclass with hundreds of thousands of ads gets slower. I can't imagine the size of that logs table when the site has so many items. Wouldn't this affect the performance of the site/server?

Thank you.

[Aficionado]

Yeap, i never really understood that and should be at least selectable.

See:

https://market.osclass.org/plugins/db-tools/database-log-table_250

This is what i use to clean things up.

[marius-ciclistu]

Incredible.... These plugins....who invented them?
I think I'll analyze the plugin and I'll make a core adaptation for it.
I'll never finish this osclass installation...after 10 months, I still discover new 'bugs' that are dealed with via plugins.....
Why don't the core handle these by default....

[marius-ciclistu]

But until then, if I understood right, I can clean the logs via phpMyAdmin?

[Aficionado]

Incredible.... These plugins....who invented them?
I think I'll analyze the plugin and I'll make a core adaptation for it.
I'll never finish this osclass installation...after 10 months, I still discover new 'bugs' that are dealed with via plugins.....
Why don't the core handle these by default....

Well, Osclass team believe that everything should NOT be into the core but done with Plugins.

I can't comment on that, since i'm not a programmer. The plugin from dev101 i posted above, works very well, and i think it is enough. No need to build that into the core. Into the core should be an OPTION to enable the log or not, just that.

[marius-ciclistu]

I know the policy
I'll built it in the core, because that's me. No plugins to mess things up and make debugging harder.

PS. These logs did not help you with that demo@demo.com admin?

[Aficionado]

PS. These logs did not help you with that demo@demo.com admin?

Nope, they didn't help me at all.

[marius-ciclistu]

So, regarding this plugin.
What's your oppinion about :
1. truncate (deleting all table ...-log and creating a new identical empty one - it's faster than delete http://www.mysqltutorial.org/mysql-truncate-table/) ONCE A WEEK with the weekly cron?
(the plugin truncates the bable at the desired time interval)

2. In order to not lose some maybe important logs for admins and moderators, maybe a shorter period for cleaning it would be better and not using truncate but detele all rows from users (delete will take longer but..) older than 1 week and all rows from admins older than 1 month for example (the admin activity should be smaller than the users').

I'm just thinking this through before starting to code the functionality in my core ( but also this could bring new ideas for this plugin).

[marius-ciclistu]

PS. These logs did not help you with that demo@demo.com admin?

Nope, they didn't help me at all.

I mean if these logs did show that that user was made or not.
I'm guessing that if the user was made via admin pannel the log should have been there and if it was made via phpMyAdmin it shouldn't.
Also I'm not sure about the log's behaviour if the user was made through sql injection.

[Aficionado]

I mean if these logs did show that that user was made or not.
I'm guessing that if the user was made via admin pannel the log should have been there and if it was made via phpMyAdmin it shouldn't.
Also I'm not sure about the log's behaviour if the user was made through sql injection.

I don't remember exactly, but i do know that i checked and found no usefull information.

[marius-ciclistu]

Ok. So about the log table. What's your oppinion about my above thoughts?

[Meder]

please help me to set CNC ! when I click *read more* me says page not found what should I do?

[Aficionado]

please help me to set CNC ! when I click *read more* me says page not found what should I do?

Please do not highjack other's topic with no reason. Open a new Topic with details about your problem.

[Aficionado]

Ok. So about the log table. What's your oppinion about my above thoughts?

I can't comment on those. I'm fully covered with the plugin, i have set it to monthly and i'm good.

Also as i said, i'm not a programmer, but i'm an experienced web master and consultant, and i hate to add things that already exist. I wouldn't re-invent the wheel, if you get what i',m saying ...

[marius-ciclistu]

I know you are experienced, that's why I asked.
Ok. Thank you. I think I'll implement the 2nd option to always have a buffer period of logs.