Re: MySQL Crash
MySQL is installed on a Virtual Machine and has a setting of "unlimited CPUs". So I am guessing that it is using all 4 CPUs of the host server (plus "cat /proc/cpuinfo" shows 4 CPUs).
When setting the "innodb_thread_concurrency" to a value different that 2 I get errors on Plesk saying it cannot read from the database. So far I have found no other solution than to leave this value as it is.
I will try lowering the "query_cache_size". Is 64M a good value?
I have found some posts on the Internet mentioning that if a query is performed on a corrupted table, then MySQL crashes. How can I log all the performed queries so I can see if that is the case? I should mention that I have run a "myisamchk (-r)" on all my databases.
Subject
Views
Written By
Posted
18152
June 15, 2011 02:31AM
6751
June 16, 2011 11:19PM
6532
June 17, 2011 12:33AM
5099
June 17, 2011 10:57PM
Re: MySQL Crash
4906
June 17, 2011 11:31PM
4567
June 18, 2011 12:17AM
3844
June 18, 2011 01:09AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.