Difference between revisions of "Incorrect key file for table '/tmp/"
From Kolmisoft Wiki
Jump to navigationJump to search
(New page: Disk space can be low. Try to tune your mysql with mysqltuner: http://rackerhacker.com/mysqltuner/ Example mysql.cng configuration: max_allowed_packet = 256M key_buffer_size=256M key...) |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
Try to tune your mysql with mysqltuner: http://rackerhacker.com/mysqltuner/ | Try to tune your mysql with mysqltuner: http://rackerhacker.com/mysqltuner/ | ||
Example mysql. | Example mysql.cnf configuration: | ||
max_allowed_packet = 256M | max_allowed_packet = 256M | ||
| Line 19: | Line 19: | ||
log-slow-queries = /var/lib/mysql/slow_query.log | log-slow-queries = /var/lib/mysql/slow_query.log | ||
log-error=/var/lib/mysql/mysqld.log | log-error=/var/lib/mysql/mysqld.log | ||
---- | |||
/tmp can be full. This can happen with huge sql queries. Try limit them. | |||
---- | |||
This error usually occurs when you got a corrupt table. The best way to solve this is to perform repair. This article might help: | |||
http://dev.mysql.com/doc/refman/5.0/en/repair-table.html | |||
Latest revision as of 16:20, 11 December 2013
Disk space can be low.
Try to tune your mysql with mysqltuner: http://rackerhacker.com/mysqltuner/
Example mysql.cnf configuration:
max_allowed_packet = 256M key_buffer_size=256M key_buffer=258M innodb_buffer_pool_size = 100M query_cache_type=1 query_cache_limit=64M query_cache_size=64M join_buffer_size = 2M tmp_table_size = 512M max_heap_table_size = 512M thread_cache_size = 4 table_cache = 128 log-slow-queries = /var/lib/mysql/slow_query.log log-error=/var/lib/mysql/mysqld.log
/tmp can be full. This can happen with huge sql queries. Try limit them.
This error usually occurs when you got a corrupt table. The best way to solve this is to perform repair. This article might help:
