Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to start MySQL on CentOS so I run service mysqld start but I get the following error:

Timeout error occurred trying to start MySQL Daemon

When I look into the logs, this is what I get

101015 11:06:08  mysqld started
101015 11:06:08 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
101015 11:06:08 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
101015 11:06:08 [ERROR] /usr/libexec/mysqld: unknown variable 'table_open_cache=256'
101015 11:06:08  mysqld ended

Can anyone tell me what is going wrong?

share|improve this question

If you are running a version prior to 5.1.3 then I think it should be table_cache and not table_open_cache - you mention in a comment that you are running 5.1.x but that x could be quite important!

Try changing table_open_cache to table_cache and see if that fixes the issue


share|improve this answer

What version MySQL are you running? Did you perhaps run into this bug?

share|improve this answer
I am running MySQL 5.1.x but I will check that link you sent right now. – user57194 Oct 15 '10 at 2:15
Now, I can't even connect to mysql. I get ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) – user57194 Oct 15 '10 at 2:39
Well from your log message above, it looks like mysql is starting, throwing that error, and quitting, so it stands to reason that you wouldn't be able to connect. – EEAA Oct 15 '10 at 2:42

I just had this happen to me out of the blue. I wasn't able to figure out why it happened, but editing /etc/my.cnf and commenting out the table_open_cache line let me start mysqld again. There may be a few other lines you have to comment out, so check your logs to see if any other variables are unknown.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.