Optimizing MySql
 

I have a succession of mysql queries that are automatically executed everyday

The total time for execution is around 10 min but during this time the server load attend to 150-200

Is the possibility to give on a mysql query a max amount of memory to not charge the server load to much? i wold prefer the queries take 1 hour instead 10 min but not tho charge my server so much..