MySQL Forums
Forum List  »  Optimizer & Parser

Re: Query Optimisation of a slow query
Posted by: Gaurav Bhuyan
Date: September 21, 2011 12:21AM

TABLE_NAME ENGINE VERSION ROW_FORMAT TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE AUTO_INCREMENT CREATE_TIME UPDATE_TIME CHECK_TIME TABLE_COLLATION CHECKSUM CREATE_OPTIONS TABLE_COMMENT
p_network_traffic_throughput InnoDB 10 Compact 137948 79 11026432 0 20561920 10943987712 137146 2011-08-25 11:52:14 (null) (null) utf8_general_ci 0
p_network_traffic_throughput_tmp1 InnoDB 10 Compact 106333 162 17317888 0 15253504 10943987712 141807 2011-09-20 17:04:45 (null) (null) utf8_general_ci 0
p_network_traffic_throughput_tmp2 InnoDB 10 Compact 122824 123 15220736 0 15253504 10943987712 0 2011-09-20 17:06:14 (null) (null) utf8_general_ci 0

p_network_traffic_bearer InnoDB 10 Compact 2425 94 229376 0 442368 10943987712 2437 2011-09-16 12:22:23 (null) (null) utf8_general_ci (null)


Is the table status output.

I can add another field and add 1 second to it, instead of using a.date_time. So how will I use a trick group by query for c.id?

Thanks for all the help.

Options: ReplyQuote


Subject
Views
Written By
Posted
3425
September 13, 2011 03:26AM
1222
September 16, 2011 10:21PM
1152
September 19, 2011 01:01AM
1039
September 20, 2011 09:20PM
Re: Query Optimisation of a slow query
955
September 21, 2011 12:21AM
1002
September 21, 2011 02:38AM
975
September 22, 2011 12:03AM
978
September 20, 2011 01:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.