MySQL Configuration

[a_bertrand]

In case you have access to my.cfg (the main MySQL configuration file), for example on your own PC / Server or on a VPS or dedicated server, you should try this little tool:

http://mysqltuner.com/

It's a "simple" perl script which will check your MySQL status and tell you how to optimize your my.cfg file. Very handy.

[Hash-Op]

Re: MySQL Configuration

Thank you very much :)

[Dave]

Re: MySQL Configuration

Interesting, I ran it on my server and it returned that there were a few optimizations which needed doing, I'll do these later and then report back wether it did improve the mysql servers speed or anything.

[a_bertrand]

Re: MySQL Configuration

Well, I can tell you that I discovered a few errors in my own configuration, and even discovered a feature which I wasn't aware (query caching). So, for a little free perl script it did its job for me ;)

[Lithium]

Re: MySQL Configuration

 

Well, I can tell you that I discovered a few errors in my own configuration, and even discovered a feature which I wasn't aware (query caching). So, for a little free perl script it did its job for me ;)

hehe and a lot of them cached i suppose? ;)

[a_bertrand]

Re: MySQL Configuration

Well I get this result:

Query cache efficiency: 50.0% (39M cached / 79M selects)

So it seems to be somehow useful, at least in my opinion. However honestly, I don't know if it produce any visible difference currently.