Luca,
In my testing I have had better throughput with RAID 10 (at least with
XFS). I have not worried about the log files so much, so you might want
to investigate that some. I would love to see benchmarks of your SAS
array though. If you have a blog you should publish them if at all
possi
Hi,
I have to install a mysql server for managing several database, from small to
quite big (tables with about 2M rows). I've got a SAS disk array and I was
wondering what the best configuration could be:
1) raid 10
2) raid 5
3) a combination (e.g., raid10 for the data and raid 5 for the logs).
I have another question regarding specs for a server.
I have talked to a DBA who has no mySQL knowledge but did work with
Oracle, etc
He said I should do some more investigation on disk configuration and
how mysql benefits from
Separating log files, data files, etc.
All feedback welcome!
On Sun, Jul 06, 2003 at 10:10:22PM -0600, Jim McAtee wrote:
> Jim McAtee wrote:
>
> > David Lloyd wrote:
> >
> > > > What would be the ideal RAID configuration for a dedicated MySQL db
> > > > server running on FreeBSD?
> > > >
> > > > We're also running some MySQL databases on Windows 2000 Server
Jim McAtee wrote:
David Lloyd wrote:
What would be the ideal RAID configuration for a dedicated MySQL db
server running on FreeBSD?
We're also running some MySQL databases on Windows 2000 Servers. What
about the best configuration for a dedicated W2k server running MySQL?
That depends
Jim McAtee wrote:
> David Lloyd wrote:
>
> > > What would be the ideal RAID configuration for a dedicated MySQL db
> > > server running on FreeBSD?
> > >
> > > We're also running some MySQL databases on Windows 2000 Servers. What
> > > about the best configuration for a dedicated W2k server runni
David Lloyd wrote:
> > What would be the ideal RAID configuration for a dedicated MySQL db
> > server running on FreeBSD?
> >
> > We're also running some MySQL databases on Windows 2000 Servers. What
> > about the best configuration for a dedicated W2k server running MySQL?
>
> That depends on
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jim,
> What would be the ideal RAID configuration for a dedicated MySQL db
> server running on FreeBSD?
>
> We're also running some MySQL databases on Windows 2000 Servers. What
> about the best configuration for a dedicated W2k server running MySQ
I just assumed your question was for mysql data only..
If you want total I use:
OS - raid 1 (2 X 18.2gb - 10kRPM)
DATA - raid 0+1 (# X 18.2gb - 15kRPM)
usually a dataset is comprised of 6-10 disks.. you could go larger with
the drive size.. but more spindles = more thruput
Swap isn't much of
That's it? The entire system - OS, swap space and data in a single array?
Nothing more involved?
[EMAIL PROTECTED] wrote:
> My favourite for dedicated db servers (good amount of data, but a ton of
> access, queries/sec) is raid 0+1 ... fast access, but requires a good number
of disks..
>
> Be
My favourite for dedicated db servers (good amount of data, but a ton of
access, queries/sec) is raid 0+1 ... fast access, but requires a good number of
disks..
Be sure to use a good raid controller, multiple channels for the disks if
possible..
On Sat, 5 Jul 2003, Jim McAtee wrote:
> What w
It depends on what your goal is and how many disks your system will
contain.
Personally I like a disk configuration with multiple spindels for
performance. I also require redundancy, RAID-5 sounds good and is but I
want the most out of writes, so I go with RAID-1+0.
Hope this helps.
On Sat
What would be the ideal RAID configuration for a dedicated MySQL db server
running on FreeBSD?
We're also running some MySQL databases on Windows 2000 Servers. What about
the best configuration for a dedicated W2k server running MySQL?
Thanks,
Jim
--
MySQL General Mailing List
For list archiv
13 matches
Mail list logo
