Re: MySQL insert performance
Please, sorry for a delayed reply. In my previous mail I've asked you include the output of 'show variables' statement, so please do it in your next message. I'd like (and probably others on the list) to see your settings. Also, perform the 'show status' just after the import; before the import restart your server, otherwise it could not contain usable information. Dhiren Bhatia <[EMAIL PROTECTED]> wrote: >This is on a development box, 1.5 GB RAM, 1CPU (1.6GHz) with the app server >& database server running on the same box. I'm using the Tomcat Database >Connection Pool to get a JDBC connection and insert the data. I dont have >too much free disk space on this machine (approx 2GB). At the time of the >insert, the CPU usage was minimal. > I have not set up any indexes on the table. The data is very simple, just 4 >columns. 3 Integers and 1 Varchar(45). > mysql> show status; >+--+---+ >| Variable_name | Value | >+--+---+ >| Aborted_clients | 0 | >| Aborted_connects | 0 | >| Binlog_cache_disk_use | 0 | >| Binlog_cache_use | 0 | >| Bytes_received | 78 | >| Bytes_sent | 70 | >| Com_admin_commands | 0 | >| Com_alter_db | 0 | >| Com_alter_table | 0 | >| Com_analyze | 0 | >| Com_backup_table | 0 | >| Com_begin | 0 | >| Com_change_db | 0 | >| Com_change_master | 0 | >| Com_check | 0 | >| Com_checksum | 0 | >| Com_commit | 0 | >| Com_create_db | 0 | >| Com_create_function | 0 | >| Com_create_index | 0 | >| Com_create_table | 0 | >| Com_dealloc_sql | 0 | >| Com_delete | 0 | >| Com_delete_multi | 0 | >| Com_do | 0 | >| Com_drop_db | 0 | >| Com_drop_function | 0 | >| Com_drop_index | 0 | >| Com_drop_table | 0 | >| Com_drop_user | 0 | >| Com_execute_sql | 0 | >| Com_flush | 0 | >| Com_grant | 0 | >| Com_ha_close | 0 | >| Com_ha_open | 0 | >| Com_ha_read | 0 | >| Com_help | 0 | >| Com_insert | 0 | >| Com_insert_select | 0 | >| Com_kill | 0 | >| Com_load | 0 | >| Com_load_master_data | 0 | >| Com_load_master_table | 0 | >| Com_lock_tables | 0 | >| Com_optimize | 0 | >| Com_preload_keys | 0 | >| Com_prepare_sql | 0 | >| Com_purge | 0 | >| Com_purge_before_date | 0 | >| Com_rename_table | 0 | >| Com_repair | 0 | >| Com_replace | 0 | >| Com_replace_select | 0 | >| Com_reset | 0 | >| Com_restore_table | 0 | >| Com_revoke | 0 | >| Com_revoke_all | 0 | >| Com_rollback | 0 | >| Com_savepoint | 0 | >| Com_select | 0 | >| Com_set_option | 0 | >| Com_show_binlog_events | 0 | >| Com_show_binlogs | 0 | >| Com_show_charsets | 0 | >| Com_show_collations | 0 | >| Com_show_column_types | 0 | >| Com_show_create_db | 0 | >| Com_show_create_table | 0 | >| Com_show_databases | 0 | >| Com_show_errors | 0 | >| Com_show_fields | 0 | >| Com_show_grants | 0 | >| Com_show_innodb_status | 0 | >| Com_show_keys | 0 | >| Com_show_logs | 0 | >| Com_show_master_status | 0 | >| Com_show_new_master | 0 | >| Com_show_open_tables | 0 | >| Com_show_privileges | 0 | >| Com_show_processlist | 0 | >| Com_show_slave_hosts | 0 | >| Com_show_slave_status | 0 | >| Com_show_status | 1 | >| Com_show_storage_engines | 0 | >| Com_show_tables | 0 | >| Com_show_variables | 0 | >| Com_show_warnings | 0 | >| Com_slave_start | 0 | >| Com_slave_stop | 0 | >| Com_truncate | 0 | >| Com_unlock_tables | 0 | >| Com_update | 0 | >| Com_update_multi | 0 | >| Connections | 2 | >| Created_tmp_disk_tables | 0 | >| Created_tmp_files | 3 | >| Created_tmp_tables | 0 | >| Delayed_errors | 0 | >| Delayed_insert_threads | 0 | >| Delayed_writes | 0 | >| Flush_commands | 1 | >| Handler_commit | 0 | >| Handler_delete | 0 | >| Handler_discover | 0 | >| Handler_read_first | 2 | >| Handler_read_key | 0 | >| Handler_read_next | 0 | >| Handler_read_prev | 0 | >| Handler_read_rnd | 0 | >| Handler_read_rnd_next | 20 | >| Handler_rollback | 0 | >| Handler_update | 0 | >| Handler_write | 0 | >| Key_blocks_not_flushed | 0 | >| Key_blocks_unused | 7173 | >| Key_blocks_used | 0 | >| Key_read_requests | 0 | >| Key_reads | 0 | >| Key_write_requests | 0 | >| Key_writes | 0 | >| Max_used_connections | 1 | >| Not_flushed_delayed_rows | 0 | >| Open_files | 0 | >| Open_streams | 0 | >| Open_tables | 0 | >| Opened_tables | 11 | >| Qcache_free_blocks | 0 | >| Qcache_free_memory | 0 | >| Qcache_hits | 0 | >| Qcache_inserts | 0 | >| Qcache_lowmem_prunes | 0 | >| Qcache_not_cached | 0 | >| Qcache_queries_in_cache | 0 | >| Qcache_total_blocks | 0 | >| Questions | 1 | >| Rpl_status | NULL | >| Select_full_join | 0 | >| Select_full_range_join | 0 | >| Select_range | 0 | >| Select_range_check | 0 | >| Select_scan | 0 | >| Slave_open_temp_tables | 0 | >| Slave_running | OFF | >| Slow_launch_threads | 0 | >| Slow_queries | 0 | >| Sort_merge_passes | 0 | >| Sort_range | 0 | >| Sort_rows | 0 | >| Sort_scan | 0 | >| Table_locks_immediate | 11 | >| Table_locks_waited | 0 |
Re: MySQL insert performance
what does the JDBC code look like that your using to do the inserts? On Fri, 2005-11-11 at 13:56 -0800, Dhiren Bhatia wrote: > Any ideas on how I can optimize this? Thanks. > > On 11/9/05, Dhiren Bhatia <[EMAIL PROTECTED]> wrote: > > > > This is on a development box, 1.5 GB RAM, 1CPU (1.6GHz) with the app > > server & database server running on the same box. I'm using the Tomcat > > Database Connection Pool to get a JDBC connection and insert the data. I > > dont have too much free disk space on this machine (approx 2GB). At the time > > of the insert, the CPU usage was minimal. > > I have not set up any indexes on the table. The data is very simple, just > > 4 columns. 3 Integers and 1 Varchar(45). > > mysql> show status; > > +--+---+ > > | Variable_name | Value | > > +--+---+ > > | Aborted_clients | 0 | > > | Aborted_connects | 0 | > > | Binlog_cache_disk_use | 0 | > > | Binlog_cache_use | 0 | > > | Bytes_received | 78 | > > | Bytes_sent | 70 | > > | Com_admin_commands | 0 | > > | Com_alter_db | 0 | > > | Com_alter_table | 0 | > > | Com_analyze | 0 | > > | Com_backup_table | 0 | > > | Com_begin | 0 | > > | Com_change_db | 0 | > > | Com_change_master | 0 | > > | Com_check | 0 | > > | Com_checksum | 0 | > > | Com_commit | 0 | > > | Com_create_db | 0 | > > | Com_create_function | 0 | > > | Com_create_index | 0 | > > | Com_create_table | 0 | > > | Com_dealloc_sql | 0 | > > | Com_delete | 0 | > > | Com_delete_multi | 0 | > > | Com_do | 0 | > > | Com_drop_db | 0 | > > | Com_drop_function | 0 | > > | Com_drop_index | 0 | > > | Com_drop_table | 0 | > > | Com_drop_user | 0 | > > | Com_execute_sql | 0 | > > | Com_flush | 0 | > > | Com_grant | 0 | > > | Com_ha_close | 0 | > > | Com_ha_open | 0 | > > | Com_ha_read | 0 | > > | Com_help | 0 | > > | Com_insert | 0 | > > | Com_insert_select | 0 | > > | Com_kill | 0 | > > | Com_load | 0 | > > | Com_load_master_data | 0 | > > | Com_load_master_table | 0 | > > | Com_lock_tables | 0 | > > | Com_optimize | 0 | > > | Com_preload_keys | 0 | > > | Com_prepare_sql | 0 | > > | Com_purge | 0 | > > | Com_purge_before_date | 0 | > > | Com_rename_table | 0 | > > | Com_repair | 0 | > > | Com_replace | 0 | > > | Com_replace_select | 0 | > > | Com_reset | 0 | > > | Com_restore_table | 0 | > > | Com_revoke | 0 | > > | Com_revoke_all | 0 | > > | Com_rollback | 0 | > > | Com_savepoint | 0 | > > | Com_select | 0 | > > | Com_set_option | 0 | > > | Com_show_binlog_events | 0 | > > | Com_show_binlogs | 0 | > > | Com_show_charsets | 0 | > > | Com_show_collations | 0 | > > | Com_show_column_types | 0 | > > | Com_show_create_db | 0 | > > | Com_show_create_table | 0 | > > | Com_show_databases | 0 | > > | Com_show_errors | 0 | > > | Com_show_fields | 0 | > > | Com_show_grants | 0 | > > | Com_show_innodb_status | 0 | > > | Com_show_keys | 0 | > > | Com_show_logs | 0 | > > | Com_show_master_status | 0 | > > | Com_show_new_master | 0 | > > | Com_show_open_tables | 0 | > > | Com_show_privileges | 0 | > > | Com_show_processlist | 0 | > > | Com_show_slave_hosts | 0 | > > | Com_show_slave_status | 0 | > > | Com_show_status | 1 | > > | Com_show_storage_engines | 0 | > > | Com_show_tables | 0 | > > | Com_show_variables | 0 | > > | Com_show_warnings | 0 | > > | Com_slave_start | 0 | > > | Com_slave_stop | 0 | > > | Com_truncate | 0 | > > | Com_unlock_tables | 0 | > > | Com_update | 0 | > > | Com_update_multi | 0 | > > | Connections | 2 | > > | Created_tmp_disk_tables | 0 | > > | Created_tmp_files | 3 | > > | Created_tmp_tables | 0 | > > | Delayed_errors | 0 | > > | Delayed_insert_threads | 0 | > > | Delayed_writes | 0 | > > | Flush_commands | 1 | > > | Handler_commit | 0 | > > | Handler_delete | 0 | > > | Handler_discover | 0 | > > | Handler_read_first | 2 | > > | Handler_read_key | 0 | > > | Handler_read_next | 0 | > > | Handler_read_prev | 0 | > > | Handler_read_rnd | 0 | > > | Handler_read_rnd_next | 20 | > > | Handler_rollback | 0 | > > | Handler_update | 0 | > > | Handler_write | 0 | > > | Key_blocks_not_flushed | 0 | > > | Key_blocks_unused | 7173 | > > | Key_blocks_used | 0 | > > | Key_read_requests | 0 | > > | Key_reads | 0 | > > | Key_write_requests | 0 | > > | Key_writes | 0 | > > | Max_used_connections | 1 | > > | Not_flushed_delayed_rows | 0 | > > | Open_files | 0 | > > | Open_streams | 0 | > > | Open_tables | 0 | > > | Opened_tables | 11 | > > | Qcache_free_blocks | 0 | > > | Qcache_free_memory | 0 | > > | Qcache_hits | 0 | > > | Qcache_inserts | 0 | > > | Qcache_lowmem_prunes | 0 | > > | Qcache_not_cached | 0 | > > | Qcache_queries_in_cache | 0 | > > | Qcache_total_blocks | 0 | > > | Questions | 1 | > > | Rpl_status | NULL | > > | Select_full_join | 0 | > > | Select_full_range_join | 0 | > > | Select_range | 0 | > > | Select_range_check | 0 | > > | Select_scan | 0 | > > | Slave_open_temp_tables | 0 | > > | Slave_running | OFF | > > | Slow_launch_threads | 0 | > > | Slow_queries | 0 | > > | Sort_merge_passes | 0 | > > | Sort_range | 0
Re: MySQL insert performance
Any ideas on how I can optimize this? Thanks. On 11/9/05, Dhiren Bhatia <[EMAIL PROTECTED]> wrote: > > This is on a development box, 1.5 GB RAM, 1CPU (1.6GHz) with the app > server & database server running on the same box. I'm using the Tomcat > Database Connection Pool to get a JDBC connection and insert the data. I > dont have too much free disk space on this machine (approx 2GB). At the time > of the insert, the CPU usage was minimal. > I have not set up any indexes on the table. The data is very simple, just > 4 columns. 3 Integers and 1 Varchar(45). > mysql> show status; > +--+---+ > | Variable_name | Value | > +--+---+ > | Aborted_clients | 0 | > | Aborted_connects | 0 | > | Binlog_cache_disk_use | 0 | > | Binlog_cache_use | 0 | > | Bytes_received | 78 | > | Bytes_sent | 70 | > | Com_admin_commands | 0 | > | Com_alter_db | 0 | > | Com_alter_table | 0 | > | Com_analyze | 0 | > | Com_backup_table | 0 | > | Com_begin | 0 | > | Com_change_db | 0 | > | Com_change_master | 0 | > | Com_check | 0 | > | Com_checksum | 0 | > | Com_commit | 0 | > | Com_create_db | 0 | > | Com_create_function | 0 | > | Com_create_index | 0 | > | Com_create_table | 0 | > | Com_dealloc_sql | 0 | > | Com_delete | 0 | > | Com_delete_multi | 0 | > | Com_do | 0 | > | Com_drop_db | 0 | > | Com_drop_function | 0 | > | Com_drop_index | 0 | > | Com_drop_table | 0 | > | Com_drop_user | 0 | > | Com_execute_sql | 0 | > | Com_flush | 0 | > | Com_grant | 0 | > | Com_ha_close | 0 | > | Com_ha_open | 0 | > | Com_ha_read | 0 | > | Com_help | 0 | > | Com_insert | 0 | > | Com_insert_select | 0 | > | Com_kill | 0 | > | Com_load | 0 | > | Com_load_master_data | 0 | > | Com_load_master_table | 0 | > | Com_lock_tables | 0 | > | Com_optimize | 0 | > | Com_preload_keys | 0 | > | Com_prepare_sql | 0 | > | Com_purge | 0 | > | Com_purge_before_date | 0 | > | Com_rename_table | 0 | > | Com_repair | 0 | > | Com_replace | 0 | > | Com_replace_select | 0 | > | Com_reset | 0 | > | Com_restore_table | 0 | > | Com_revoke | 0 | > | Com_revoke_all | 0 | > | Com_rollback | 0 | > | Com_savepoint | 0 | > | Com_select | 0 | > | Com_set_option | 0 | > | Com_show_binlog_events | 0 | > | Com_show_binlogs | 0 | > | Com_show_charsets | 0 | > | Com_show_collations | 0 | > | Com_show_column_types | 0 | > | Com_show_create_db | 0 | > | Com_show_create_table | 0 | > | Com_show_databases | 0 | > | Com_show_errors | 0 | > | Com_show_fields | 0 | > | Com_show_grants | 0 | > | Com_show_innodb_status | 0 | > | Com_show_keys | 0 | > | Com_show_logs | 0 | > | Com_show_master_status | 0 | > | Com_show_new_master | 0 | > | Com_show_open_tables | 0 | > | Com_show_privileges | 0 | > | Com_show_processlist | 0 | > | Com_show_slave_hosts | 0 | > | Com_show_slave_status | 0 | > | Com_show_status | 1 | > | Com_show_storage_engines | 0 | > | Com_show_tables | 0 | > | Com_show_variables | 0 | > | Com_show_warnings | 0 | > | Com_slave_start | 0 | > | Com_slave_stop | 0 | > | Com_truncate | 0 | > | Com_unlock_tables | 0 | > | Com_update | 0 | > | Com_update_multi | 0 | > | Connections | 2 | > | Created_tmp_disk_tables | 0 | > | Created_tmp_files | 3 | > | Created_tmp_tables | 0 | > | Delayed_errors | 0 | > | Delayed_insert_threads | 0 | > | Delayed_writes | 0 | > | Flush_commands | 1 | > | Handler_commit | 0 | > | Handler_delete | 0 | > | Handler_discover | 0 | > | Handler_read_first | 2 | > | Handler_read_key | 0 | > | Handler_read_next | 0 | > | Handler_read_prev | 0 | > | Handler_read_rnd | 0 | > | Handler_read_rnd_next | 20 | > | Handler_rollback | 0 | > | Handler_update | 0 | > | Handler_write | 0 | > | Key_blocks_not_flushed | 0 | > | Key_blocks_unused | 7173 | > | Key_blocks_used | 0 | > | Key_read_requests | 0 | > | Key_reads | 0 | > | Key_write_requests | 0 | > | Key_writes | 0 | > | Max_used_connections | 1 | > | Not_flushed_delayed_rows | 0 | > | Open_files | 0 | > | Open_streams | 0 | > | Open_tables | 0 | > | Opened_tables | 11 | > | Qcache_free_blocks | 0 | > | Qcache_free_memory | 0 | > | Qcache_hits | 0 | > | Qcache_inserts | 0 | > | Qcache_lowmem_prunes | 0 | > | Qcache_not_cached | 0 | > | Qcache_queries_in_cache | 0 | > | Qcache_total_blocks | 0 | > | Questions | 1 | > | Rpl_status | NULL | > | Select_full_join | 0 | > | Select_full_range_join | 0 | > | Select_range | 0 | > | Select_range_check | 0 | > | Select_scan | 0 | > | Slave_open_temp_tables | 0 | > | Slave_running | OFF | > | Slow_launch_threads | 0 | > | Slow_queries | 0 | > | Sort_merge_passes | 0 | > | Sort_range | 0 | > | Sort_rows | 0 | > | Sort_scan | 0 | > | Table_locks_immediate | 11 | > | Table_locks_waited | 0 | > | Threads_cached | 0 | > | Threads_connected | 1 | > | Threads_created | 1 | > | Threads_running | 1 | > | Uptime | 13 | > +--+---+ > 156 rows in set ( 0.07 sec) > Thanks. > > On 11/9/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > > > > Hello. > > > > > > > > As others suggest send the 'CREATE' statement for you
Re: MySQL insert performance
This is on a development box, 1.5 GB RAM, 1CPU (1.6GHz) with the app server & database server running on the same box. I'm using the Tomcat Database Connection Pool to get a JDBC connection and insert the data. I dont have too much free disk space on this machine (approx 2GB). At the time of the insert, the CPU usage was minimal. I have not set up any indexes on the table. The data is very simple, just 4 columns. 3 Integers and 1 Varchar(45). mysql> show status; +--+---+ | Variable_name | Value | +--+---+ | Aborted_clients | 0 | | Aborted_connects | 0 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 0 | | Bytes_received | 78 | | Bytes_sent | 70 | | Com_admin_commands | 0 | | Com_alter_db | 0 | | Com_alter_table | 0 | | Com_analyze | 0 | | Com_backup_table | 0 | | Com_begin | 0 | | Com_change_db | 0 | | Com_change_master | 0 | | Com_check | 0 | | Com_checksum | 0 | | Com_commit | 0 | | Com_create_db | 0 | | Com_create_function | 0 | | Com_create_index | 0 | | Com_create_table | 0 | | Com_dealloc_sql | 0 | | Com_delete | 0 | | Com_delete_multi | 0 | | Com_do | 0 | | Com_drop_db | 0 | | Com_drop_function | 0 | | Com_drop_index | 0 | | Com_drop_table | 0 | | Com_drop_user | 0 | | Com_execute_sql | 0 | | Com_flush | 0 | | Com_grant | 0 | | Com_ha_close | 0 | | Com_ha_open | 0 | | Com_ha_read | 0 | | Com_help | 0 | | Com_insert | 0 | | Com_insert_select | 0 | | Com_kill | 0 | | Com_load | 0 | | Com_load_master_data | 0 | | Com_load_master_table | 0 | | Com_lock_tables | 0 | | Com_optimize | 0 | | Com_preload_keys | 0 | | Com_prepare_sql | 0 | | Com_purge | 0 | | Com_purge_before_date | 0 | | Com_rename_table | 0 | | Com_repair | 0 | | Com_replace | 0 | | Com_replace_select | 0 | | Com_reset | 0 | | Com_restore_table | 0 | | Com_revoke | 0 | | Com_revoke_all | 0 | | Com_rollback | 0 | | Com_savepoint | 0 | | Com_select | 0 | | Com_set_option | 0 | | Com_show_binlog_events | 0 | | Com_show_binlogs | 0 | | Com_show_charsets | 0 | | Com_show_collations | 0 | | Com_show_column_types | 0 | | Com_show_create_db | 0 | | Com_show_create_table | 0 | | Com_show_databases | 0 | | Com_show_errors | 0 | | Com_show_fields | 0 | | Com_show_grants | 0 | | Com_show_innodb_status | 0 | | Com_show_keys | 0 | | Com_show_logs | 0 | | Com_show_master_status | 0 | | Com_show_new_master | 0 | | Com_show_open_tables | 0 | | Com_show_privileges | 0 | | Com_show_processlist | 0 | | Com_show_slave_hosts | 0 | | Com_show_slave_status | 0 | | Com_show_status | 1 | | Com_show_storage_engines | 0 | | Com_show_tables | 0 | | Com_show_variables | 0 | | Com_show_warnings | 0 | | Com_slave_start | 0 | | Com_slave_stop | 0 | | Com_truncate | 0 | | Com_unlock_tables | 0 | | Com_update | 0 | | Com_update_multi | 0 | | Connections | 2 | | Created_tmp_disk_tables | 0 | | Created_tmp_files | 3 | | Created_tmp_tables | 0 | | Delayed_errors | 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Flush_commands | 1 | | Handler_commit | 0 | | Handler_delete | 0 | | Handler_discover | 0 | | Handler_read_first | 2 | | Handler_read_key | 0 | | Handler_read_next | 0 | | Handler_read_prev | 0 | | Handler_read_rnd | 0 | | Handler_read_rnd_next | 20 | | Handler_rollback | 0 | | Handler_update | 0 | | Handler_write | 0 | | Key_blocks_not_flushed | 0 | | Key_blocks_unused | 7173 | | Key_blocks_used | 0 | | Key_read_requests | 0 | | Key_reads | 0 | | Key_write_requests | 0 | | Key_writes | 0 | | Max_used_connections | 1 | | Not_flushed_delayed_rows | 0 | | Open_files | 0 | | Open_streams | 0 | | Open_tables | 0 | | Opened_tables | 11 | | Qcache_free_blocks | 0 | | Qcache_free_memory | 0 | | Qcache_hits | 0 | | Qcache_inserts | 0 | | Qcache_lowmem_prunes | 0 | | Qcache_not_cached | 0 | | Qcache_queries_in_cache | 0 | | Qcache_total_blocks | 0 | | Questions | 1 | | Rpl_status | NULL | | Select_full_join | 0 | | Select_full_range_join | 0 | | Select_range | 0 | | Select_range_check | 0 | | Select_scan | 0 | | Slave_open_temp_tables | 0 | | Slave_running | OFF | | Slow_launch_threads | 0 | | Slow_queries | 0 | | Sort_merge_passes | 0 | | Sort_range | 0 | | Sort_rows | 0 | | Sort_scan | 0 | | Table_locks_immediate | 11 | | Table_locks_waited | 0 | | Threads_cached | 0 | | Threads_connected | 1 | | Threads_created | 1 | | Threads_running | 1 | | Uptime | 13 | +--+---+ 156 rows in set (0.07 sec) Thanks. On 11/9/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > > Hello. > > > > As others suggest send the 'CREATE' statement for your table, and, > > please, include the output of : > > 'show status'; > > 'show variables'; > > > > > > > > > > > How long should it take to insert approx 30,000 rows into MySQL. It > > > takes me > > > about 30 mins. I'm using version 4.1.10-nt. Any ideas? > > > Thanks, > > > Dhiren > > > > > > > > > Dhiren Bhatia wrote: > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET http://ww
Re: MySQL insert performance
Hello. As others suggest send the 'CREATE' statement for your table, and, please, include the output of : 'show status'; 'show variables'; > How long should it take to insert approx 30,000 rows into MySQL. It > takes me > about 30 mins. I'm using version 4.1.10-nt. Any ideas? > Thanks, > Dhiren > Dhiren Bhatia wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL insert performance
That seems like a long time. Although I don't know how much data you are importing, how many indexes you have on the database, memory, etc. How you are going about importing can affect your speed dramatically. If you are importing a tab delimited (or other delimination) file, you should get much better speed. If you are importing a mysql dump that does individual inserts, then the speed you are seeing may be the best you'll get. On Nov 9, 2005, at 1:47 PM, Dhiren Bhatia wrote: How long should it take to insert approx 30,000 rows into MySQL. It takes me about 30 mins. I'm using version 4.1.10-nt. Any ideas? Thanks, Dhiren -- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL insert performance
> How long should it take to insert approx 30,000 rows into MySQL. Depends on the data and field structure. Do you have lots of indexes on the table? >It takes me about 30 mins. There are some tips at http://dev.mysql.com/doc/refman/4.1/en/insert-speed.html -- Scott Noyes [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]