Trouble joining 3 tables

2009-11-01 Thread Brian Dunning
Hi all - I have a table of PEOPLE, and a table of CARS owned by various people, and a table of PETS owned by various people. Each person may have 0 or more pets, and each person may have 0 or more cars. I'm trying to return a list of all the people, showing how many pets each person has,

Re: Raid level suggestions for mysql-server

2009-11-01 Thread Per Jessen
Gšötz Reinicke - IT Koordinator wrote: > Hi, > > soon I'll get a SUN X4170 with 8*2,5" SAS 300 GB harddisks. (24 GB > RAM) > > This system could be our new central mysql-server for some > LAMP-systems. (right now about 50 GB mysql data total, roughly 60-70% > reads.) > > What would be a good ra

Raid level suggestions for mysql-server

2009-11-01 Thread Gšötz Reinicke - IT Koordinator
Hi, soon I'll get a SUN X4170 with 8*2,5" SAS 300 GB harddisks. (24 GB RAM) This system could be our new central mysql-server for some LAMP-systems. (right now about 50 GB mysql data total, roughly 60-70% reads.) What would be a good raid-Layout for the server? I was thinking of one large 1+