1

I want to know the basic parameters/configuration for mysql to work great.

What are they? How to determine?

Using phpmyadmin, the status params marked red color seems needed to alter to optimize, but what's the basic ones that I should work on first?

3 Answers 3

2

there is a fairly neat perl script called mysqltuner.pl (available at the domain of the same name, or here)

you need shell access (and a mysql admin user login) - but it will look at your instance, config and some stats and make basic recommendations that could provide a base from which to work.

while it's a good starting point, it certainly isn't an absolute diagnostic tool & band-aid - I would still have a go with the numerous web resources dealing with MySQL performance tuning, and preferably start (on a development box) understanding how to measure your current performance, understand indexes and how they are applied and how different mysql datafile/db storage types work and what suits your environment.

as someone once muttered in Oracle training, there is no "faster=true" switch.

2

There are entire documents, web sites and books devoted to that topic. There's no possible way your question can be adequately answered here--especially without more information.

I suggest reading through some of the links above, and using google. And if you get stuck somewhere, then post a new, specific question.

0

You can use Mysqltuner, Tuning-primer, mytop, MySQLReport,...

For more detail about those tools, check the next link....

http://www.serveradminblog.com/2011/03/tuning-mysql-performance-howto-part-1/

Of course everything depends on your situation and application which uses database...

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .