Large-scale mRNA translation and the intricate effects of competition for the finite pool of ribosomes