"Been there, done that. Indexing your tables, especially on the trade_date and blockchain_id columns, is key. Also, make sure to set MySQL's innodb_buffer_pool_size to a decent chuck of RAM, like 50-75%."
"Yo, just a heads up - I've had success with indexing and partitioning in MySQL for high-traffic crypto apps. Also, consider using InnoDB instead of MyISAM since it's more suited for concurrent writes, which are key in crypto trading."