| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Perrin Harkins | Date: | April 21 2010 3:26pm |
| Subject: | Re: More CPU or More RAM? | ||
| View as plain text | |||
On Wed, Apr 21, 2010 at 11:14 AM, shamubro@stripped <shamubro@stripped> wrote: > This is my current my.cnf setttings. Could anyone take a quick peek and tell > me if I set anything awfully wrong? If your tables are MyISAM (not InnoDB), then 128MB is much too small for your key_buffer. You should look at the sample my.cnf files that come in the mysql documentation. Those will give you a better starting point. And to answer your original question, in general, RAM is more useful than anything else for a database. Whatever is using your CPU might be work that could be pushed off to your web layer, but the data access can't be. - Perrin
| Thread | ||
|---|---|---|
| • More CPU or More RAM? | shamubro@gmail.com | 21 Apr |
| • Re: More CPU or More RAM? | Johan De Meersman | 21 Apr |
| • Re: More CPU or More RAM? | shamubro@gmail.com | 21 Apr |
| • Re: More CPU or More RAM? | Johan De Meersman | 22 Apr |
| • Re: More CPU or More RAM? | Johan De Meersman | 22 Apr |
| • RE: More CPU or More RAM? | Johan Gant | 21 Apr |
| • Re: More CPU or More RAM? | shamubro@gmail.com | 21 Apr |
| • Re: More CPU or More RAM? | Perrin Harkins | 21 Apr |
| • Re: More CPU or More RAM? | shamubro@gmail.com | 21 Apr |
| • Re: More CPU or More RAM? | shamubro@gmail.com | 21 Apr |
| • Re: More CPU or More RAM? | Tom Worster | 21 Apr |
| • Re: More CPU or More RAM? | Rudy Lippan | 22 Apr |
| • RE: More CPU or More RAM? | Johan Gant | 21 Apr |
| • Re: More CPU or More RAM? | shamubro@gmail.com | 21 Apr |
| • Re: More CPU or More RAM? | shamubro@gmail.com | 21 Apr |
