Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I works with mampp and so mysql. I'd like to optimise mysql server with my.conf but I don't really find how. Indeed the server is a production computer with only mammp running. Storage engine is InnoDB. In the database, there's about 120 table, in main tables there's about 100000 records.

Can you help me to configure my server.

Thanks a lot

share|improve this question

migrated from Sep 19 '11 at 19:18

This question came from our site for professional and enthusiast programmers.

closed as not a real question by Shane Madden, sysadmin1138 Sep 20 '11 at 1:08

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

Configure for what? heavy insert? heavy read? Someone's suggested configuration could torpedo performance because you're NOT using that suggested workload. As such, your question is unanswerable. – Marc B Sep 19 '11 at 16:25

Read everything here:

share|improve this answer