Linux 3.19.0‐14‐generic MySQL Server 5.7.11 Percona Server 5.7.10‐3 Storage SAS HDD 2x SEAGATE ST600MP0005 15K rpm SATA SSD 2x Samsung 850 PRO NVMe SSD 2x Samsung XS1715 0‐14‐generic Percona Server 5.7.11‐4 Storage SAS HDD 2x SEAGATE ST600MP0005 15K rpm SATA SSD 2x Samsung 850 Pro SAS SSD 2x Samsung PM1633 NVMe 2x Samsung PM1725 It is SSDs. Mean CPU % utilization (User+Sys) on the Quad Socked Server Mean CPU % 15K rpm SAS‐HDD SATA SSD SAS SSD NVMe SSD 50 connections 0.4% 5.8% 15.9% 22.3% 100 connections 0.4% 13.4%

loc[tips['tip'] <= 9] {{ header }} 3.5.3 Comparison with SAS For potential users coming from SAS this page is meant to demonstrate how different SAS operations would be performed in pandas. If youre new DataFrame. This is often used in interactive work (e.g. Jupyter notebook or terminal) - the equivalent in SAS would be: proc print data=df(obs=5); run; 150 Chapter 3. Getting started pandas: powerful Python terminology translation pandas SAS DataFrame data set column variable row observation groupby BY-group NaN . DataFrame / Series A DataFrame in pandas is analogous to a SAS data set - a two-dimensional

. . . . . . . . . . 69 5 Virtual storage 71 5.1 Hard disk controllers: IDE, SATA (AHCI), SCSI, SAS . . . . . . . . . . . . . . . . 71 5.2 Disk image files (VDI, VMDK, VHD, HDD) . . . . . . . . . . adapters (LSI Logic and Bus- Logic); see chapter 5.1, Hard disk controllers: IDE, SATA (AHCI), SCSI, SAS, page 71 for details. Whereas providing one of these would be enough for VirtualBox by itself, this devices are present initially. Please see chapter 5.1, Hard disk controllers: IDE, SATA (AHCI), SCSI, SAS, page 71 for additional information. VirtualBox also provides a floppy controller, which is special:

. . . . . . . . . . 69 5 Virtual storage 71 5.1 Hard disk controllers: IDE, SATA (AHCI), SCSI, SAS . . . . . . . . . . . . . . . . 71 5.2 Disk image files (VDI, VMDK, VHD, HDD) . . . . . . . . . . adapters (LSI Logic and Bus- Logic); see chapter 5.1, Hard disk controllers: IDE, SATA (AHCI), SCSI, SAS, page 71 for details. Whereas providing one of these would be enough for VirtualBox by itself, this devices are present initially. Please see chapter 5.1, Hard disk controllers: IDE, SATA (AHCI), SCSI, SAS, page 71 for additional information. VirtualBox also provides a floppy controller, which is special:

. . . . 83 3 Contents 5 Virtual storage 85 5.1 Hard disk controllers: IDE, SATA (AHCI), SCSI, SAS . . . . . . . . . . . 85 5.2 Disk image files (VDI, VMDK, VHD, HDD) . . . . . . . . . . . . . . . adapters (LSI Logic and BusLogic); see chapter 5.1, Hard disk controllers: IDE, SATA (AHCI), SCSI, SAS, page 85 for details. Whereas providing one of these would be enough for VirtualBox by itself, this run a modern guest operating system. See chapter 5.1, Hard disk controllers: IDE, SATA (AHCI), SCSI, SAS, page 85 for details. To add another virtual hard disk or CD/DVD drive, select the storage controller

. . . . . . . . . . 70 5 Virtual storage 72 5.1 Hard disk controllers: IDE, SATA (AHCI), SCSI, SAS . . . . . . . . . . . . . . . . 72 5.2 Disk image files (VDI, VMDK, VHD, HDD) . . . . . . . . . . adapters (LSI Logic and Bus- Logic); see chapter 5.1, Hard disk controllers: IDE, SATA (AHCI), SCSI, SAS, page 72 for details. Whereas providing one of these would be enough for VirtualBox by itself, this devices are present initially. Please see chapter 5.1, Hard disk controllers: IDE, SATA (AHCI), SCSI, SAS, page 72 for additional information. VirtualBox also provides a floppy controller, which is special:

. . . . . . . . . . 71 5 Virtual storage 73 5.1 Hard disk controllers: IDE, SATA (AHCI), SCSI, SAS . . . . . . . . . . . . . . . . 73 5.2 Disk image files (VDI, VMDK, VHD, HDD) . . . . . . . . . . adapters (LSI Logic and Bus- Logic); see chapter 5.1, Hard disk controllers: IDE, SATA (AHCI), SCSI, SAS, page 73 for details. Whereas providing one of these would be enough for VirtualBox by itself, this devices are present initially. Please see chapter 5.1, Hard disk controllers: IDE, SATA (AHCI), SCSI, SAS, page 73 for additional information. VirtualBox also provides a floppy controller, which is special:

. . . . . . . . . . 69 5 Virtual storage 71 5.1 Hard disk controllers: IDE, SATA (AHCI), SCSI, SAS . . . . . . . . . . . . . . . . 71 5.2 Disk image files (VDI, VMDK, VHD, HDD) . . . . . . . . . . adapters (LSI Logic and Bus- Logic); see chapter 5.1, Hard disk controllers: IDE, SATA (AHCI), SCSI, SAS, page 71 for details. Whereas providing one of these would be enough for VirtualBox by itself, this devices are present initially. Please see chapter 5.1, Hard disk controllers: IDE, SATA (AHCI), SCSI, SAS, page 71 for additional information. VirtualBox also provides a floppy controller, which is special:

. . . . . . . . . . 73 5 Virtual storage 75 5.1 Hard disk controllers: IDE, SATA (AHCI), SCSI, SAS . . . . . . . . . . . . . . . . 75 5.2 Disk image files (VDI, VMDK, VHD, HDD) . . . . . . . . . . adapters (LSI Logic and Bus- Logic); see chapter 5.1, Hard disk controllers: IDE, SATA (AHCI), SCSI, SAS, page 75 for details. Whereas providing one of these would be enough for VirtualBox by itself, this devices are present initially. Please see chapter 5.1, Hard disk controllers: IDE, SATA (AHCI), SCSI, SAS, page 75 for additional information. VirtualBox also provides a floppy controller, which is special:

. . . . . . . . . . 69 5 Virtual storage 71 5.1 Hard disk controllers: IDE, SATA (AHCI), SCSI, SAS . . . . . . . . . . . . . . . . 71 5.2 Disk image files (VDI, VMDK, VHD, HDD) . . . . . . . . . . adapters (LSI Logic and Bus- Logic); see chapter 5.1, Hard disk controllers: IDE, SATA (AHCI), SCSI, SAS, page 71 for details. Whereas providing one of these would be enough for VirtualBox by itself, this devices are present initially. Please see chapter 5.1, Hard disk controllers: IDE, SATA (AHCI), SCSI, SAS, page 71 for additional information. VirtualBox also provides a floppy controller, which is special: