[phpOpenTracker-User] phpOpenTracker reports show "zero" activity (mySQL)

Don't panic if a period of time in phpOpenTracker reports shows "zero"
activity suddenly (on mySQL).

You can check the state of the database with the tool "mysqlcheck" (which
resides in the mysql directory, something like /usr/local/mysql/bin) while the
mysqld-server is running:

shell> mysqlcheck the_pot_database_name

If it tells you that some tables are broken you can repair them with the
option -r (repair):
shell> mysqlcheck -r the_pot_database_name

I think you could run these Operations with SQL or even phpMyAdmin too
(OPTIMIZE TABLE, REPAIR TABLE).

The error could be caused by the "DELAY_KEY_WRITE=1" option in the table
definition. 

Quote from the mysql manual:
Declaring a table with DELAY_KEY_WRITE=1 will make the updating of indexes
faster, 
as these are not logged to disk until the file is closed. 
The downside is that you should run myisamchk on these tables before you
start mysqld to ensure that 
they are okay if something killed mysqld in the middle. As the key
information can always be generated 
from the data, you should not lose anything by using DELAY_KEY_WRITE. 

Greetings,

Chris.

-- 
COMPUTERBILD 15/03: Premium-e-mail-Dienste im Test
--------------------------------------------------
1. GMX TopMail - Platz 1 und Testsieger!
2. GMX ProMail - Platz 2 und Preis-Qualitätssieger!
3. Arcor - 4. web.de - 5. T-Online - 6. freenet.de - 7. daybyday - 8. e-Post



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf