I could not find any formula. I think that there will always be a need for trial and error. I would start with the recommended my.cnf for various DB sizes. In one of the distributions of MySql I found a recommended my.cnf for small, medium and large databases when the size is based on the machine's memory.
If you can't find it I can take a look and try to find it for you.... On Mon, Jan 12, 2009 at 7:32 PM, Niv <[email protected]> wrote: > > I'm looking for maximizing MySQL performance, which ever instance type > I'm using. I want to know the best my.cnf settings for each instance > type (and if it depends on the number of concurrent connections, the > table or index sizes and other other params, it would be great if > there were formulas). > > On Jan 12, 7:11 pm, "Arie Fishler" <[email protected]> wrote: > > Naturally the question is what is the expected db size you are going to > > handle? > > > > and of course your budget.... > > > > On Mon, Jan 12, 2009 at 7:10 PM, Niv <[email protected]> wrote: > > > > > Hello. > > > Does anybody know what the recommended settings for MySQL are? > > > I'm referring specifically to the memory settings, and the > > > recommendations for each instance type (1.7GB, 7GB, 15GB RAM). > > > > > I found these links > > >http://blog.rightscale.com/2007/11/13/mysql-performance-on-amazon-ec2/ > > >http://dev.mysql.com/doc/refman/5.1/en/ha-vm-aws-setup.html > > > > > But still don't have a clear answer. > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "scalr-discuss" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/scalr-discuss?hl=en -~----------~----~----~----~------~----~------~--~---
