How to properly store a large table with history in MySQL (MariaDB)?

Question

MySQL

Greetings! Tell me, there is a table with 10 columns, where the length of each value does not exceed 50 bytes. The table receives ~ 100 records per second in one transaction with an INSERT IGNORE query, now the table size is ~ 10 GB. And she loves to crash when the machine is rebooted. Repair works, but takes a long time. All settings are default.
From the table the data on 2 index columns is constantly requested. The average answer size is 50-60k lines.
Tell me which engine to choose for the table and how to configure the database for optimal operation in this mode?

PS Now I will create a second table where I will put the cache in order to reduce the number of requests to this table

Answer 1

And she loves to crash when restarting the machine

With a normal Linux reboot or with a Linux crash?