The disk-structures tag has no wiki summary.
1
vote
1answer
626 views
MySQL InnoDB data file directly on a disk slice (fixed-size)?
It seems that ibdata1 is like a disk slice. In Solaris (UNIX) UFS filesystems (the common one before ZFS), one would separate their disk c0t0d0 into slices, say a 10GB drive would be cut into three ...
2
votes
3answers
2k views
Can I specify a different disk for a specific MySQL table?
I use my home machine as my personal database for my hobby analytics project. This machine has an SSD for the main drive where MySQL stores its data. It also has a secondary hard drive that is ...
7
votes
4answers
1k views
Help me choose a RAID level combination for a SQL Server 2008 instance
I am going to rebuild one IBM 3400 server from scratch. This server is dedicated to a SQL Server 2008 instance running on Windows 2008 R2.
I am going to make new RAID configuration. I have 6 SCSI ...
5
votes
2answers
494 views
Single Drive vs Multiple Drives
Generally bottleneck of RDBMS (I am a MySQL user) performance is disk access. SSD provides great performance compared with conventional spindle drives.
Question : Is it possible to improve ...
6
votes
2answers
2k views
SQL Disk Setup Advice - TempDB, Log DB, Data file placement question
We have a very active database server with a ecclectic collection of applications running on it. Two of the busiest are a Laserfiche database that does document scanning and workflow processing all ...
6
votes
2answers
129 views
How should I configure these disks on a SQL Server for a BI configuration?
Assuming constant memory (32gb) and CPU (4), 2 x disk arrays, I have the following disks
2 x 150 (10k)
6 x 150 (15k)
They are all local disks.
My requirements
My DB is 350gb and set to default ...
3
votes
1answer
131 views
Extreme storage beasts
Intro
I have derived this question from my previous question Single Drive vs Multiple Drives
After getting a very detailed answer from a very helpful member RolandoMySQLDBA and learning the fact that ...
