What kind of experience have people had with myisam and large tables, on the order of ~50GB(for a single table, other tables are ~2gigs including index)(I am not concerned with OS file size limits.) and billions of rows?
What are the most important settings to tweak in the my.cnf file? I have 2gigs of ram and 4 xenon processors.
I first tried prototyping my database with Innodb, but the transactional nature of it seemed to kill my performance. Am I crazy to not use Innodb? Is it a bad assumption that Innodb is slower? My evaluation is based on the usage of "load data infile" to create the initial values.