Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
add comment

3 Answers

up vote 2 down vote accepted

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.

share|improve this answer
add comment

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.

share|improve this answer
add comment

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...

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.