Re: Optimal MySQL server -- opinions?

2008-05-03 Thread Rene Fournier
On 28-Apr-08, at 11:26 AM, Francisco Rodrigo Cortinas Maseda wrote: The other counterpart is that if you can put the entire databases on RAM, your disk needs are not so high. So if you can afford that. Silly question, but with MySQL default configuration (say, huge.cnf), does it

Re: Optimal MySQL server -- opinions?

2008-05-03 Thread Rene Fournier
On 29-Apr-08, at 10:41 AM, Andrew Braithwaite wrote: Hi, Three things... 1. You need to let us know what the DB server will be doing. Many CPU cores are only important of you have many CPU intensive MySQL connections in parallel. Will you have a read-intensive or write-intensive database

RE: Optimal MySQL server -- opinions?

2008-04-29 Thread Andrew Braithwaite
Hi, Three things... 1. You need to let us know what the DB server will be doing. Many CPU cores are only important of you have many CPU intensive MySQL connections in parallel. Will you have a read-intensive or write-intensive database load? Those 2950III you're considering can take up to 8

RE: Optimal MySQL server -- opinions?

2008-04-28 Thread Francisco Rodrigo Cortinas Maseda
Hi, My experience shows me that RAM and disk is fundamental for any database, especially MySQL. As much IO load, much more disk preading you have to take with. Personally, i have 2 databases with 11 millions Inserts / day (2GB / day), so my advise is that you spend as much money as you can in