On Our server I have done following configuration for Database: [server has 2 core, 2 GB ram and windows 2008 operating system]
[Old] query_cache_size= 50M
[Old] thread_cache_size= 100
[Old] key_buffer_size= 600M
[New] innodb_read_io_threads= 64
[New] innodb_write_io_threads= 64
though application was working fine but now i am having a problem regarding mysql table getting crashed.
CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1194 Table 'mytable' is marked as crashed and should be repaired. The SQL statement executed wa....
My sql version is 5.5.17