MySQL configuration type?

Question

I am installing MySQL and when it reaches the configuration step it is asking me to select from on of the following server configuration types:

Development Machine
Server Machine
Dedicated Machine

I am new to mysql, the reason I am installing this is because I am making an application which will store data on a database using MySQL. Now, can someone explain what does these server configurable type mean and which one should I be selecting?

score 1 · Accepted Answer · edited Jun 14 '17 at 09:53

1

This is only about setting up the initial my.cnf file. You can always change this later.

Generally server configurations allocate a lot more memory to MySQL than you would on your development machine.

edited Jun 14 '17 at 09:53

Shadow

33,525
10
51
64

answered Nov 04 '12 at 18:53

tadman

208,517
23
234
262

score 1 · Answer 2 · answered Nov 04 '12 at 18:53

This is basically trying to pick the default memory use setting and configuration (over simplification, but good enough for now). If its on a shared system or you have no idea of the physical machine, start with development.

You can always edit the my.cnf to better optimize your setup

MySQL configuration type?

2 Answers2