atrum Posted February 3, 2011 Share Posted February 3, 2011 So I have been trying to resolve a performance issue I have been experiencing with mysql and writing to a large table. So in this scenario, I have a table that is 5G in size (huge I know) and I am running 1 - 2 queries every 10 seconds, which I believe is causing the issue. My question pertains to how mysql is handling the query. Does mysql have to read the entire contents of the table into memory before it appends the new data to it? Or does it insert it with out reading the table into memory? I should also mention that I am using the DELAYED option in my insert queries. Quote Link to comment https://forums.phpfreaks.com/topic/226592-query-performance-question/ Share on other sites More sharing options...
mikosiko Posted February 3, 2011 Share Posted February 3, 2011 for further analysis/help I suggest you to post: - Your Table description including all the indexes definition. - Your problematic queries - The explain plan for each one Quote Link to comment https://forums.phpfreaks.com/topic/226592-query-performance-question/#findComment-1169528 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.