query_cache_size = 0 - FAIL (must be >= 16777216)

There are two fails in admin. I just switched hosts away from host for web to an unmanaged cloud. I can't find these two things anywhere. Where would they be? 

MySQL:         

query_cache_size = 0 - FAIL (must be >= 16777216)

thread_cache_size = 0 - FAIL (must be > 0)

The MySQL configuration file is usually at /etc/my.cnf.

You'll need to restart MySQL after making the changes.

That's what people keep saying on the web too but my etc folder just has ftpquota file. and a folder of the domain name. Do I really need it?

That sounds like your home directory. I'm referring to the root /etc directory on your server.

do you know the command to change it?

You need to edit the file as root, so either via SSH or edit the file via SFTP. It's basically the MySQL equivalent of a php.ini file. You should be able to restart MySQL from your control panel, but if not, enter this via SSH:

# service mysqld restart

If not mysqld, try mysql. If you're not comfortable making these changes, I can take a look. Just shoot me a PM.

Hi Op

Like Nathan have said you will need to log in to root and add the following to my.cnf

query_cache_size=amount
thread_cache_size=amount

If you use filezilla and login using sftp using your root credentials and edit the above file using notepad++.  Save the file and restart MySql.

This should sort our your problems.

No118

just a note,

the files could be in your /etc/mysql/my.cnf too.

ok I found it.

as root open the file with 
nano -w /path to file
use the arrows to scroll up/down to the line you want to edit. then the left/right arrows to move the cursor to the word(s) you want to change. At the bottom of the screen is a list of commands

^G Get Help ^O WriteOut ^R Read File ^Y Prev Page ^K Cut Text ^C Cur Pos
^X Exit ^J Justify ^W Where Is ^V Next Page ^U UnCut Text^T To Spell

the caret pointing up means to hit the control key at the same time you hit the letter key. (Anyway, I THINK it's called a caret).
Really easy to use and learn. Much easier to learn than vi or vim. Works in text only mode, too. 
hth
Bill

Here's the link: (Reply #5)

http://forums.fedoraforum.org/showthread.php?t=137180

In my case it was nano -w/etc/my.cnf