From: Stefan <son...@ba...> - 2005-07-01 09:25:09
|
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 |