I am facing problems with my Internet provider: the current quota for our MySQL database was 60 Mb but we quickly reached 63,300 Mb... However, out of this 55,467 Mb is the storage of a single table named "accesslog" that seems to store session information. Is there any way of purging this table or setting it up to purge by itself before it grows fat?
Bernard Bel
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I will reply to myself as I solved 99 % of this problem.
In "config.ini" we have:
; If defined (e.g. 1) read-access is done via SQL.
; If flag 2 is set, phpwiki also writes. Default on SQL database.
; This must use DATABASE_TYPE = SQL or ADODB or PDO.
; ACCESS_LOG_SQL = 0 ; disable SQL access logging
; ACCESS_LOG_SQL = 1 ; phpwiki reads, apache mod_log_sql writes
; ACCESS_LOG_SQL = 2 ; read + write
After setting ACCESS_LOG_SQL = 0 the "accesslog" table stopped growing. :-)
Now I am not sure whether we may just delete it in the MySQL database, or we need to do something smarter at the level of PhpWiki.
(I am too afraid of crashing the site.)
Bernard Bel
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am facing problems with my Internet provider: the current quota for our MySQL database was 60 Mb but we quickly reached 63,300 Mb... However, out of this 55,467 Mb is the storage of a single table named "accesslog" that seems to store session information. Is there any way of purging this table or setting it up to purge by itself before it grows fat?
Bernard Bel
I will reply to myself as I solved 99 % of this problem.
In "config.ini" we have:
; If defined (e.g. 1) read-access is done via SQL.
; If flag 2 is set, phpwiki also writes. Default on SQL database.
; This must use DATABASE_TYPE = SQL or ADODB or PDO.
; ACCESS_LOG_SQL = 0 ; disable SQL access logging
; ACCESS_LOG_SQL = 1 ; phpwiki reads, apache mod_log_sql writes
; ACCESS_LOG_SQL = 2 ; read + write
After setting ACCESS_LOG_SQL = 0 the "accesslog" table stopped growing. :-)
Now I am not sure whether we may just delete it in the MySQL database, or we need to do something smarter at the level of PhpWiki.
(I am too afraid of crashing the site.)
Bernard Bel