You can see the one used live on our sites: https://gerrit.wikimedia.org/r/gitweb?p=operations/puppet.git;a=blob;f=templates/mysql/prod.my.cnf.erb;h=734009a4c170ffc2f525c4e18fc4c72352cffe45;hb=HEAD
https://gerrit.wikimedia.org/r/gitweb?p=operations/puppet.git;a=blob;f=manifests/mysql.pp;h=c9eef470a2e33559e011f49474642b7752e0f793;hb=HEAD Unfortunately, it's a puppet template, but you can substitute the variables with their values in the related puppet manifest. - Ryan On Thu, Oct 6, 2011 at 6:55 PM, Fred Zimmerman <[email protected]> wrote: > I don't have all the log files with me at the moment. I am gathering myself > for a fresh start. How about a .cnf file that demonstrably works? > >> >> What fails, exactly? Do you get error messages of some kind? Without >> knowing >> what's going wrong, there's little advice that can be given. >> >> > >> > my target machine is an AWS instance 32 bit Ubuntu 1.7GB RAM, 1 Core, 200 >> > GB, which is only for this project. I can make it bigger if necessary. >> > >> > Can someone take a look at this my.cnf file and tell me what I need to >> > change to get this to work? >> > >> > this is what my.cnf file looks like: >> > >> >> The only requirement I can think of is making sure max_packet_size is >> biggish so all the pages import; you appear to have set it to 128M which >> should be more than big enough. >> >> Other settings I would assume should depend on your available memory, >> workload, etc. >> >> -- brion >> _______________________________________________ >> Wikitech-l mailing list >> [email protected] >> https://lists.wikimedia.org/mailman/listinfo/wikitech-l >> > _______________________________________________ > Wikitech-l mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/wikitech-l > _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
