In my last blog post I showed you how to get the entire Percona “Stack” up and running on a Raspberry Pi. This time around, I would like to show the impact on performance between using an SSD hard disk and a standard hard disk.
Disk performance is a key factor in Percona Server for MySQL (or any RDB platform) performance on a Raspberry Pi 4.
Test set up
Each test below was run three times per Hard Disk and I took the best of the three for comparison.
- Raspberry Pi 4+ with 4GB ram.
- Disk 1: USB3 Western Digital My Passport Ultra, 1TB
- Disk 2: USB3 KEXIN 240GB Portable External SSD Drive
Hardware stayed consistent …[Read more]