I modified my my.cnf and now my site is toast
I host
I was trying to improve mysql's performance a few hours ago by modifying my.cnf to better utilize the memory on my system .
Now, no matter what I do, I get many variants of the following error:
Warning: Incorrect information in file: './phillyfuture/cache.frm' query: UPDATE cache SET data = 'N;', created = 1269149472, expire = 0, headers = '' WHERE cid = 'variables' in /var/www/
Here is my memory configuration:
The database uses Innodb.
Here is the my.cnf file (the commented out innodb section is what I was trying to change)
As of right now, the site is down with the error indicated above.
Line 174 in database.mysql.inc is
triggererror(checkplain(mysqlerror($activedb) ."\nquery: ". $query), EUSERWARNING);
I can login to the database and it appears okay.
/proc/version reports:
Linux version 2.6.18.8-linode22 (
And MySQL reports its version is
Server version: 5.0.32-Debian_7etch8-log Debian etch distribution
Thank you in advance for any help or direction you can provide.
Karl
4 Replies
The fix, btw, was reverting what I did from this MySQL forum postin on changing innodblogfile_size:
I had to revert my ib_log files.
If anyone here has any suggestions on appropriate my.cnf settings, please share.
Thanks,
Karl
what storage engines do you use?
what is your access pattern like?
what kind of certainty do you need when a crash occurs?
What is the size of your dataset and the size of your active dataset?
What other software is running on your system?
etc. etc.
The problem with MySQL tuning is that there are many factors that play a part in it, and it seems to be a matter of change, test, implement (or revert). That said, there are companies who can help you out with that, like Open Query or Percona (disclaimer: i do work for the first one
What's the output of this query?
show variables like 'innodb%';