If I change my innodb_buffer_pool_size to anything above 2000M I cant get mysql to restart. SO I have kept it at 2000M. Im not sure how to tell how much of the 8G RAM is available to mysql ?? I ran your query using the 5 tables in question... select...