Rick James Wrote:
-------------------------------------------------------
> So, down from 5 minutes to under 2?
Yes, but I think that depends on the condition of the network...
> innodb_buffer_pool_size 112197632
> Change to 1600M
What is the right way to make this change?
> Please provide the EXPLAIN.
SHOW TABLE STATUS LIKE '_tbl1';
SHOW TABLE STATUS LIKE '_tbl2';
Name = _tbl1
Engine = InnoDB
Version = 10
Row_format = Compact
Rows = 3666243
Avg_row_length = 210
Data_length = 771751936
Max_data_length = 0
Index_length = 874053632
Data_free = 1432354816
Auto_increment = 3669961
Create_time = 3/3/2011 16:51:51
Collation = latin1_swedish_ci
Name = _tbl2
Engine = InnoDB
Version = 10
Row_format = Compact
Rows = 9395
Avg_row_length = 392
Data_length = 3686400
Max_data_length = 0
Index_length = 1310720
Data_free = 1432354816
Auto_increment = 9291
Create_time = 20/6/2011 14:43:38
Collation = latin1_swedish_ci