Re: INNODB large database performance

[Paul Smith]

This is the response when i use explain. Regarding the qustion...
Can two rows for the same Channel be inserted with the same DATETIME? No only one per datetime and channelID. Can you explain why this is a red flag in your book?

Results...

id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY <derived2> ALL \N \N \N \N 11040 Using temporary; Using filesort
2 DERIVED cg ALL \N \N \N \N 8089 Using where; Using temporary; Using filesort
2 DERIVED g eq_ref PRIMARY PRIMARY 4 eddie.cg.GroupID 1 Using where
2 DERIVED d ref PRIMARY,FK_data_ChannelID FK_data_ChannelID 4 eddie.cg.ChannelID 798479 Using where
2 DERIVED sr eq_ref PRIMARY PRIMARY 4 slave.d.SiteRateID 1


Thanks for your response and time.



Edited 1 time(s). Last edit at 02/23/2013 03:33PM by Paul Smith.