Re: How can I optimize this query?
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
cityblocks MyISAM 10 Fixed 3786204 20 75724080 5629499534213119 231022592 0 NULL 2010-03-16 09:52:36 2010-03-16 09:53:17 2010-03-16 10:02:55 latin1_general_ci NULL
citylocation MyISAM 10 Dynamic 271269 38 10381556 281474976710655 2510848 0 NULL 2010-03-16 09:53:31 2010-03-16 09:53:32 NULL latin1_general_ci NULL
Variable_name Value
bulk_insert_buffer_size 8388608
innodb_buffer_pool_awe_mem_mb 0
innodb_buffer_pool_size 317718528
innodb_log_buffer_size 4194304
join_buffer_size 131072
key_buffer_size 163577856
myisam_sort_buffer_size 214958080
net_buffer_length 16384
preload_buffer_size 32768
read_buffer_size 61440
read_rnd_buffer_size 258048
sort_buffer_size 262136
Subject
Views
Written By
Posted
5310
March 12, 2010 02:40PM
2341
March 13, 2010 04:07PM
1768
March 13, 2010 04:17PM
1932
March 16, 2010 08:22AM
2400
April 14, 2010 02:27AM
1933
March 16, 2010 07:58AM
Re: How can I optimize this query?
1847
March 16, 2010 08:16AM
1847
March 16, 2010 08:21AM
1813
March 16, 2010 08:16AM
1833
March 16, 2010 09:40AM
1866
March 16, 2010 01:59PM
1867
March 27, 2010 03:36PM
1629
April 14, 2010 07:21AM
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.