Application in php 5.1.6.I'm running MySQL version 5.0.45 on CentOS5 using a HP DL380 with 8G ram and 15krpm raid10 disks. Tables are myisam.

I'm seeing errors in my application where I'm getting from simple selects every few hours:

SELECT id, host_id, uri_id, profile FROM activity_profiles WHERE 1=1 AND id IN (48823962 )

Table 'activity_profiles' is marked as crashed and should be repaired.

My application isn't reporting errors when writing, though.

I do a "flush table activity_profiles; check table activity_profiles;" and the table seems to have fixed itself.

Any thots?

TIA,

Jed

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to