Re: [Phpwiki-talk] database corruption, accesslog and session table

[Arnaud F. <ar...@cr...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Le 1 juil. 05 =E0 11:24, Stefan a =E9crit :
>
> once a week my phpwiki database gets corrupted. i'am using the =20
> newest mysql backend and about 5 databases on the server. only the =20
> phpwiki database once a week gets an error. most the time the index =20=

> is corrupted. sometimes it's the session table other time the page =20
> table next time the version table. i can't figure out why this =20
> happens. i think it mus be a mysql problem but only phpwiki is =20
> affected with this problem.
>

I also have the same table corruption problem. It occurs only on the =20
access table.
I'm using mysql 4.1.12 with myisam tables and with the CVS version of =20=

phpwiki.

What version of MySql do you use ?

> now i want to minimize my sql traffic, how can i stop logging to =20
> accesslog table in the mysql database. i allready tried
> access_log_sql =3D 0
> access_log_sql =3D 1
> ;access_log_sql =3D 0
> but it logs and logs to the table. how to stop it?
>

Same here ... no way to deactivate the sql log.

Arnaud
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (Darwin)

iD8DBQFC22SAyAf3wgFyy1ARAmTjAJ4zYU0x3pweGRXeXu1ACZ4T1vMrMACeMFaM
1nevksU3ckq5B0qqth0U3yY=3D
=3DOCBO
-----END PGP SIGNATURE-----