MySQL Forums
Forum List  »  Optimizer & Parser

Re: How can I optimize this query?
Posted by: Martin Schiff
Date: March 16, 2010 08:16AM

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 	 


Options: ReplyQuote


Subject
Views
Written By
Posted
5214
March 12, 2010 02:40PM
2311
March 13, 2010 04:07PM
1742
March 13, 2010 04:17PM
1899
March 16, 2010 08:22AM
2368
April 14, 2010 02:27AM
Re: How can I optimize this query?
1816
March 16, 2010 08:16AM
1829
March 27, 2010 03:36PM


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.