Importing from CSV file, is crashing mysql server
Let's do some calculation:

uuid: 36 bytes (Add 1 because it is varchar) ==&gt; 37
uuid_tags_codes: 4 bytes
When indexed, full length of uuid field: 100 bytes

(37+4+100)bytes * 162,281,544 rows = 21.3 G


So, 21G without adding the overhead! Therefore, your first problem is the space.

To answer your questions: 


It is more than 6-8G. To ba safe you need ~30G. Single MyISAM table can handle that. I don't recommend it though. MyISAM is not as safe as InnoDB for example.
MySQL is not wrong solution, but I think there are better solution. Since it is kind of look up table, key-value store would do better job. For example, memcache, Redis.
You can improve the structure by making uuid char(36). In fact, this article has even more efficient solution. Also, use the smallest integer type that fits your maximum value of uuid_tags_codes
You may want to load the data first to the table without its indexes, then create the required index.


HTH