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).
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
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 Servers. What
about
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
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
-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 MySQL?
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 what your
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?
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
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
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
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
13 matches
Mail list logo