Mysql edit with Centos server??

Hi, i got these config on Audit

MySQL:

• key_buffer_size = 8388608 - OK
• query_cache_limit = 1048576 - OK
• query_cache_size = 0 - FAIL (must be >= 16777216)
• query_cache_type = ON - OK
• max_heap_table_size = 16777216 - OK
• tmp_table_size = 16777216 - OK
• thread_cache_size = 0 - FAIL (must be > 0)

How to change the FAIL one to make it perfect for dolphin U. Im using Centos 6.5 with directadmin

it is in the php.ini that i need to make some change???

thx

no, you need to change the mysql config file, my.cnf

No. Mysql settings are in /etc/my.cnf

See mysql settings in the help document here. http://www.boonex.com/trac/dolphin/wiki/HostingServerSetupRecommendations#MySQL

ok thx geekgirl... and where normally is that file?

/usr/local/lib ?

I only have my.cnf.old  and my.cnf.rpmsave

in /etc/

Then something erased it. You will need to create one.

I would start with the my.cnf.rpmsave as that should contain the most recent settings, or look at the dates of the two files and use the setting in the newest one as a starting point for a new my.cnf file.

 this one is mostly empty

[mysqld]
local-infile=0
innodb_file_per_table

If you can use putty, run the following command to search for the locations MySQL is reading:

mysqld --verbose --help

It will output most likely a lot of information, but somewhere at the top you find the following information:

Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf

Those are the locations your my.cnf can be stored.

Keep in mind that the "master" cnf file can override the settings in your "local" cnf file.

ok well i create it in etc/ and add the line in the conf file... now it works

thx