Question : I have a fairly large transactional database (100GB) with a lot of users. The database access is solely […]
Tag: hardware
Performance of mysql equi-join observed in HDD and SSD
Question : I experimented performance of queries having equi-joins. I have simplified version of EXPLAINs of the queries. Mysql version […]
Estimated hardware requirement for a planned “mostly-write” database
Question : I was asked to create a server application that needs to receive and store relatively simply messages (about […]
More CPU cores vs faster disks
Question : I’m part of a small company so as usual covering a number of different roles. The latest of […]
What hardware to purchase for MySQL server? Details below [closed]
Question : Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the […]
SSDs and 64K sectors
Question : SSDs tend to have a natural 4K sector size as far as I know, but would it be […]
SQL Server data files and RAID
Question : I have a server with a RAID1 volume (OS + apps) and a RAID10 volume (database). The RAID10 […]
Which hard disks for PostgreSQL? [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
Performance of mysql equi-join observed in HDD and SSD
Question : I experimented performance of queries having equi-joins. I have simplified version of EXPLAINs of the queries. Mysql version […]
Optimal drive configuration for SQL Server 2008R2
Question : I have a fairly busy database server running SQL Server 2008 R2 that has the following setup: SATA […]