Question : I am working on the design of a WordPress blog which when finished will almost-always serve pages from […]
Tag: ssd
WordPress blog where pages are almost-always served from cache: SSD or more RAM?
Question : I am working on the design of a WordPress blog which when finished will almost-always serve pages from […]
SQL server Installation
Question : I have received a new server. The server has the following specification. It has 500 gig 7.2K RPM […]
SSDs and 64K sectors
Question : SSDs tend to have a natural 4K sector size as far as I know, but would it be […]
Can database confirm the sequential read is really sequential in SSD
Question : In SSD, overwriting a data file means SSD has to first erase it and then write data. This […]
Is it normal for disk activity to disturb MySQL performance?
Question : I’m running MySQL 5.5 on a server with two SSDs in software RAID-1 configuration. The filesystem is ext4. […]
Raid 1 or Raid 1+0 for SQL Server Architecture
Question : We are looking at new servers. Today our SQL Servers are built as follows: C/D on RAID 1 […]
Flash storage and auto-grow
Question : Our databases files (data and log) of (a lot of) SQL Servers are hosted on flash storage (SAN), […]
Upgrading hardware for MySQL. If we get SSDs, are CPUs likely to become a bottleneck
Question : We are upgrading hardware for a MySQL database server (DB is around 200GB). We’re getting 4x Samsung 850 […]
Does innodb_flush_log_at_trx_commit = 1 wear out SSDs more than innodb_flush_log_at_trx_commit = 2?
Question : I am running a Nextcloud instance and I suffer from a slow sync when a lot of small […]