Re: Query Optimisation of a slow query
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.
Subject
Views
Written By
Posted
3878
September 13, 2011 03:26AM
1444
September 16, 2011 10:21PM
1352
September 19, 2011 01:01AM
1245
September 20, 2011 09:20PM
Re: Query Optimisation of a slow query
1163
September 21, 2011 12:21AM
1220
September 21, 2011 02:38AM
1160
September 22, 2011 12:03AM
1152
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.