My.cnf
How do I identify the MySQL my.cnf file?
If you are unfamiliar in administrating MySQL, the current MySQL configuration file generally found is named my.cnf (my.ini on windows). Where is that file. If only that question was easy to answer!
Read moreFree advice on your my.cnf
Today, while on IRC in #pentaho I came across a discussion and a published my.cnf. In this configuration I found some grossly incorrect values for per session buffers (see below).
Read moreBe sure to know your my.cnf [sections]
The MySQL configuration file, e.g. /etc/my.cnf has a number of different section headings including [mysql], [mysqld], [mysqld_safe]. It is important that you ensure you put the right variables into the right section.
Read moreHave you checked your MySQL error log today?
As a consultant I would be rich if I made money every time when asking “Have you checked the MySQL error log?” Today’s special found in a 13GB MySQL server error log.
Read more