Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

There are a view things that don't match in my MySQL .ini file.

For example, everything that I have read/learned is to use

config_settings = value

however, in my configuration file there are:

config-setting = value

like myisam-block-size instead of myisam_block_size.

Can this cause issues, should I edit them to the _ instead of -?

Another question I have, in my config file I have open_files_limit = 500, but whenever I do a show variables the open_files_limit is 7048. Why would this be?

share|improve this question

1 Answer 1

up vote 3 down vote accepted
  • The configuration file use the dash (-)
  • The variable name use the underscore (_)

http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_open-files-limit

Another question I have, in my config file I have open_files_limit = 500, but whenever I do a show variables the open_files_limit is 7048. Why would this be?

It sounds like someone has changed the open_files_limit value without restarting MySQL.

share|improve this answer
    
I did a net stop mysql, net start mysql to see if that was indeed the problem - but it wasn't. The open files limit was actually lower than the 5000 I set it to. –  Jeff Nov 23 '11 at 15:30
    
What is its value? –  quanta Nov 23 '11 at 15:40

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.