Re: Inserts very slow

[Greg Hines]

Rick James Wrote:
-------------------------------------------------------
> Were the values in SHOW GLOBAL VARIABLES LIKE
> 'innodb%' identical on the two machines? Note
> especially
> innodb_flush_log_at_trx_commit
> innodb_doublewrite

DEVELOPMENT

Variable_name	Value
innodb_adaptive_hash_index	ON
innodb_additional_mem_pool_size	3145728
innodb_autoextend_increment	8
innodb_autoinc_lock_mode	1
innodb_buffer_pool_size	536870912
innodb_checksums	ON
innodb_commit_concurrency	0
innodb_concurrency_tickets	500
innodb_data_file_path	ibdata1:10M:autoextend
innodb_data_home_dir	
innodb_doublewrite	ON
innodb_fast_shutdown	1
innodb_file_io_threads	4
innodb_file_per_table	OFF
innodb_flush_log_at_trx_commit	1
innodb_flush_method	
innodb_force_recovery	0
innodb_lock_wait_timeout	50
innodb_locks_unsafe_for_binlog	OFF
innodb_log_buffer_size	2097152
innodb_log_file_size	56623104
innodb_log_files_in_group	2
innodb_log_group_home_dir	.\\
innodb_max_dirty_pages_pct	90
innodb_max_purge_lag	0
innodb_mirrored_log_groups	1
innodb_open_files	300
innodb_rollback_on_timeout	OFF
innodb_stats_on_metadata	ON
innodb_support_xa	ON
innodb_sync_spin_loops	20
innodb_table_locks	ON
innodb_thread_concurrency	8
innodb_thread_sleep_delay	10000
innodb_use_legacy_cardinality_algorithm	ON

PRODUCTION

Variable_name	Value
innodb_adaptive_hash_index	ON
innodb_additional_mem_pool_size	16777216
innodb_autoextend_increment	8
innodb_autoinc_lock_mode	1
innodb_buffer_pool_size	2147483648
innodb_checksums	ON
innodb_commit_concurrency	0
innodb_concurrency_tickets	500
innodb_data_file_path	ibdata1:10M:autoextend
innodb_data_home_dir	C:\\MySQLDatabases\\
innodb_doublewrite	ON
innodb_fast_shutdown	1
innodb_file_io_threads	4
innodb_file_per_table	OFF
innodb_flush_log_at_trx_commit	1
innodb_flush_method	
innodb_force_recovery	0
innodb_lock_wait_timeout	120
innodb_locks_unsafe_for_binlog	OFF
innodb_log_buffer_size	8388608
innodb_log_file_size	220200960
innodb_log_files_in_group	2
innodb_log_group_home_dir	.\\
innodb_max_dirty_pages_pct	90
innodb_max_purge_lag	0
innodb_mirrored_log_groups	1
innodb_open_files	300
innodb_rollback_on_timeout	OFF
innodb_stats_on_metadata	ON
innodb_support_xa	ON
innodb_sync_spin_loops	20
innodb_table_locks	ON
innodb_thread_concurrency	16
innodb_thread_sleep_delay	10000
innodb_use_legacy_cardinality_algorithm	ON