Database tables getting very big..

Database tables getting very big.., a forum discussion on Jojo CMS. Join us for more discussions on Database tables getting very big.. on our Administration (backend and configuration) forum.

Back to Forum Index : Back to Administration (backend and configuration)   RSS
Alex

8 Feb 2008
Posts: 28

Hi, on my testsite i've seen that the tables eventlog (10.8MB) and adodb_logsql (3.2MB) are becoming very large, this is a testsite so there's not much traffic. There are very much forum messages in the eventlog and table exists messages, is this a bug or not?

(Function 'getfileextension' used from jojo_forum.p...)
mikec

Lead Developer

mikec

8 Feb 2008
Posts: 67

Hi Alex,

The adodbn_logsql table is only used while the site is in debug mode. Once you turn debug mode off, this will not conntinnue to grow and can be emptied.

The eventlog table logs errors including the use of some legacy functions which is what you are seeing with the forum plugin. These will reduce as we have time to locate and replace them all.

We welcome patches to the function name transitions. Most are just changing from the global name space to the Jojo namespace. eg tableexists() becomes Jojo::tablexists()

- Mike
Harvey

Core Developer

Harvey

8 Feb 2008
Posts: 327

Hi Alex,

One of the items on my list is to automatically delete all non-critical log entries over a month old. I found a 1Gb event log on one of my sites, which is clearly a bit silly (A busy site packed with legacy code that needed to be updated).

As Mike says, we have been using these log messages to clean up old code from within Jojo, which has now largely been done for all our plugins.

Harvey.
Back to Forum Index : Back to Administration (backend and configuration)   RSS
You must be logged in to post a reply



You need to Register or Log In before posting on these forums.