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?
Best Answer
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
Jason