I need a little help with configuring MySQL. It's already installed and working fine, but I would like to optimize the thing a bit. Now, I find documentation a bit thin on this issue. I understand that there should be a my.cnf file placed somewhere, with directives in the file. I tried with /var/lib/mysql (on of the locations mentioned, place where my data is stored), but for some reason it looks like that prevented mysqld from actually starting properly.
So, I'm wondering if somebody could tell me what exactly do I have to do to change some operating parameters. For example, what would the configuration file look like if I want to set key buffers to 64M (I believe it's 8 by default) and where do I put it.
Thanx.
So, I'm wondering if somebody could tell me what exactly do I have to do to change some operating parameters. For example, what would the configuration file look like if I want to set key buffers to 64M (I believe it's 8 by default) and where do I put it.
Thanx.