Re: Inserts optimization?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Gábriel Ákos writes:

you are right. raid5 is definitely not suitable for database activities.

That is not entirely true. :-)
Right now the new server is not ready and the ONLY place I could put the DB for Bacula was a machine with RAID 5. So far it is holding fine. HOWEVER... only one bacula job at a time so far and the machine doesn't do anything else. :-)


it is good for file servers, though.

Even for a DB server, from what I have read and what I have experienced so far for mostly read DBs RAID5 should be ok. Specially if you have enough memory.

As I add more clients to Bacula and the jobs bump into each other I will better know how the DB holds up. I am doing each FULL backup at a time so hopefully by the time I do multiple backups from multiple machines less records will need to be inserted to the DB and there will be a more balanced operation between reads and writes. Right now there are lots of inserts going on.


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux