1

On Our server I have done following configuration for Database: [server has 2 core, 2 GB ram and windows 2008 operating system]

query_cache_size= 32M
[Old] query_cache_size= 50M
[New]

thread_cache_size= 8
[Old] thread_cache_size= 100
[New]

key_buffer_size= 384M
[Old] key_buffer_size= 600M
[New]

innodb_flush_log_at_trx_commit=1
[Old] innodb_flush_log_at_trx_commit=0
[New]

innodb_buffer_pool_size=16M
[Old] innodb_buffer_pool_size=250M
[New]

innodb_thread_concurrency= 0
[New] innodb_read_io_threads= 64
[New] innodb_write_io_threads= 64
[New]

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

  • Has something changed recently? There are already questions which covers the scenario and solutions... (go through it and other similar questions) BTW, default storage engine in 5.5 is Innodb, do you still have MyISAM tables? Do you consider moving to InnoDB? – mysql_user Sep 21 '15 at 7:11
  • is the engine MyISAM? how often does it crash? – Masoud Sep 21 '15 at 7:23
  • Those tables crashed are all MyIsam – Kamran Shahid Sep 21 '15 at 7:26
  • I hope you are not actually putting "[New]" in the config file -- that would confuse mysql. – Rick James Oct 25 '15 at 20:20
  • 1
    After a power failure, some MyISAM tables need to be CHECKed and possibly REPAIRed. This has nothing to do with the config changes. – Rick James Oct 25 '15 at 20:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.