No I do mean memory, This server supports mirroring/redudancy at the memory level as well
Ooh, never come across this before. Is it intended to be some kind of replacement/improvement for ECC RAM?
Ok so server is setup with a 6 disk raid 5 for the DB and a 2 disk raid 1 for OS/tmp
Question is this, by default the bin logs are stored in /var/lib/mysql with the database, would it be better to put those on the raid 1 to “move” the disk IO?
Well like I said before we’ve split our main Innodb box as datafiles vs logfiles+os, and off the top of my head I can’t remember where we’ve pointed the tmp stuff to - probably the datafiles disk as I suspect it’s more random io… (we tend to use on-disk tmp tables very infrequently so it’s less important for us)
Originally I intended to do some detailed benchmarks to compare various setups but unfortunately I didn’t get the time I wanted to do this, so all I can really say is that the split of logs and data seems to be working really well so far.
Actually it’s just occurred to me that you might be using MyISAM not InnoDB, but either way you will probably want to focus on splitting datafiles and logs onto separate devices as your priority.
So to answer your question, I’d say “yes” in short )
Toasty