hello,
once a week my phpwiki database gets corrupted. i'am using the newest
mysql backend and about 5 databases on the server. only the phpwiki
database once a week gets an error. most the time the index is
corrupted. sometimes it's the session table other time the page table
next time the version table. i can't figure out why this happens. i
think it mus be a mysql problem but only phpwiki is affected with this
problem.
now i want to minimize my sql traffic, how can i stop logging to
accesslog table in the mysql database. i allready tried
access_log_sql = 0
access_log_sql = 1
;access_log_sql = 0
but it logs and logs to the table. how to stop it?
I also want to stop the endless entries of sessions in the session
table. there are hundredthousend sessions in there and from time to time
i delete them. why they are not automatic deleted when they are 1 day old?
Regards Stefan
|
