The peak oracle database has 80g of data written per hour. How fast can the hard disk be configured to read and write?

problem description

the peak oracle database has 80g of data written per hour. How fast can the hard disk be configured to read and write?

the environmental background of the problems and what methods you have tried

how do I match the right hard disk device? Is there any specific formula that can be roughly evaluated?

related codes

/ / Please paste the code text below (do not replace the code with pictures)

what result do you expect? What is the error message actually seen?

Jun.03,2021

on average, writes per second are about 22m (80 * 1000 / 3600), IO is not high.

A single ordinary RAID disk can write at least 100m per second, and the hard disk array on the server, SAS 5, is at least 3 disks. An ordinary server can meet the requirements.

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e4d544-4c62d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e4d544-4c62d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?