Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [ssd]

62 questions
49
votes
6 answers

SSD vs HDD for databases

I am trying to purchase a new Server to run MySQL Server on. This new server will be a slave of my main machine. However, this server will be dedicated for reporting only "Lots of reads and complex queries." Now I am looking into investing into…
Mike
  • 609
  • 2
  • 6
  • 7
30
votes
4 answers

Do SSDs reduce the usefulness of Databases

I only heard about Robert Martin today, and it seems like he's a notable figure in the software world, so I don't mean for my title to appear as if it's a click bait or me putting words in his mouth, but this is simply how I interpreted what I heard…
Honinbo Shusaku
  • 499
  • 1
  • 6
  • 8
13
votes
1 answer

Autodetect ‘random_page_cost’ vs ‘seq_page_cost’

I read this article about PostgreSQL performance on SSD: https://amplitude.engineering/how-a-single-postgresql-config-change-improved-slow-query-performance-by-50x-85593b8991b0 These two configurations seem to be important random_page_cost vs…
guettli
  • 1,591
  • 5
  • 25
  • 51
13
votes
2 answers

Moving SQL Server database to a new disk while online

I have a 1.4TB SQL Server Database that's struggling massively with disk I/O. We've installed a new SSD array into the server that will solve all of our problems, we're just debating the best way to move the database across. Ideally if we can do it…
seamus
  • 133
  • 1
  • 4
6
votes
2 answers

Major Discrepancy Between SQLIO IOPS/Throughput Stats and DBCC CHECKDB Operations

I'm conducting time trials on a new SSD array running both SQLIO tests and a real-world workload of DB restores and DBCC CHECKDB calls. I'm seeing a major discrepancy between the IOPS and throughput generated with my SQLIO batches and what I'm…
MattyZDBA
  • 1,955
  • 3
  • 20
  • 32
6
votes
4 answers

Mysql (percona-server 5.5) completely stalls during import (myloader)

While configuring our new servers (IBM X3650M4, 2x Intel Xeon E5-2620, 64G RAM, RAID 10 (4x 240G SSD)) we bumped into a strange problem. We're trying to import dumps (mydumper) from our (old) production environment into our new one, but we're hardly…
tersmitten
  • 193
  • 1
  • 12
5
votes
2 answers

Shrink or no Shrink dilemma

I have databases that I am tasked to move two databases DBName1 and DBName2 to SSD and I only have limited space on the SSD to fit these databases.I do not want to shrink log or data files for the obvious reason and Brent or Paul might go crazy. I…
user42148
  • 177
  • 2
  • 4
  • 9
5
votes
1 answer

SQL Server 2012 Local SSD TempDB Slow

I have a production deployment using local SSDs for tempDB. I have 2 SSDs in a RAID1 configuration. I am seeing average reads of 1-2ms but the average writes are showing as 1377ms on all four of my tempdb data files. Each tempdb data file is 2GB…
James Anderson
  • 5,794
  • 2
  • 27
  • 43
5
votes
2 answers

MySQL on SSD - what are the disadvantages?

Recently, I heard that I should not host my MySQL database on an SSD drive because there is a big chance of disk failure and data lost. Given that 20% of all queries in my database are INSERTs and UPDATEs, here are my questions: QUESTIONS What are…
Bald
  • 211
  • 4
  • 7
5
votes
2 answers

SSDs and 64K sectors

SSDs tend to have a natural 4K sector size as far as I know, but would it be beneficial to format Windows cluster size at 64K? This is good practice for spinning rust, but is it relevant on SSDs?
John Alan
  • 1,081
  • 7
  • 13
3
votes
1 answer

PostgreSQL SSD vs HDD - why is there no difference in insert performance?

I have a PostgreSQL12 on Ubuntu 20.04 with following tablespaces: The default uses a HDD and there is also another tablespace on an SSD. Then I run a test to see the differences in insert/update speed for tables placed in different…
Leon Powałka
  • 161
  • 1
  • 4
3
votes
1 answer

why SSD is slower than HDD SAS 15K on DBMS PostgreSQL?

Someone help me analyze the two execution plans below (Explain ANALYZE used), is the query 9 of TPC-H benchmark. I'm using two servers HP Intel Xeon 2.8GHz/4-core - Memory 8GB. O.S. Debian8, using EXT4 filesystem. Server 1 HDD SAS 15 Krpm - 320 GB…
Neto
  • 201
  • 2
  • 10
3
votes
3 answers

Configuring physical storage for a Microsoft SQL Server installation

I'm configuring a Microsoft SQL Server installation which will use a SAN for storage. For SAN storage I have: A small number of SSD disks A larger number of 10K disks My SAN supports storage tiering. I'm on the fence about how to use the SSD…
Brad
  • 191
  • 1
  • 7
3
votes
3 answers

Is it normal for disk activity to disturb MySQL performance?

I'm running MySQL 5.5 on a server with two SSDs in software RAID-1 configuration. The filesystem is ext4. When any process (external to MySQL) produces a large amount of disk IO on the server, I find that MySQL becomes virtually paralyzed, with…
potc
  • 101
  • 5
2
votes
1 answer

Upgrading to new cPanel Server with mySQL on SSD -- What should I change in my.cnf?

I'm upgrading to a faster server with whm/cpanel and the mysql databases will be on a SSD. I've read a bit about not wanting any query cache and stuff like that, but as a novice, I've learned that tinkering with my.cnf can be disastrous. Here's the…
Ben The Novice
1
2 3 4 5