have you checked with myisamchk? On Thu, Nov 13, 2008 at 4:09 PM, Jed Reynolds <[EMAIL PROTECTED]> wrote:
> 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] > >
