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. 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 Link to comment https://forums.phpfreaks.com/topic/226592-query-performance-question/#findComment-1169528 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.