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 | > > | 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://www.ensita.net/ > > > __ ___ ___ ____ __ > > > / |/ /_ __/ __/ __ \/ / Gleb Paharenko > > > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > > > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET > > > <___/ www.mysql.com <http://www.mysql.com/> > > > > > > > > > > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
