mysql activity report and munin - worth trying

If you run a few high traffic sites and you rely on tools like mysqltuner or tuning-primer to optimize SQL you can run into problems.

(more…)

Just posting because I couldn’t find any good post on this.

(more…)

Verify that the values in your my.cnf file are correct. If you are not sure restore your backup – if you don’t have one check this table to see if there are no typos. Typos can cause the error “MySQL manager or server PID file could not be found!”, so I suggest you are extra careful when you’re editing the my.cnf file.

Quick guide how to tune your SQL setting.

(more…)

Well I’m not so familar with SQL, that’s why I was struggling with that problems for about 10 minutes. Actually it’s fairly simply, the error message says that there is already an entry with the ID 127 in the database.
The problem is the size of the SQL field. A signed TinyINT can only save entries from -127 to 127, an unsigned TinyINT can hold entries that range from 0 to +255.

You can find some more information about it here.