[mySQL] Basso uso CPU con UPDATE

[cipi]

Ciao a tutti,
ritorno coi miei problemi con mySQL. Mi domandavo se è normale che lanciando degli UPDATE di tabelle la CPU rimanga abbastanza inutilizzata. Mi spiego, ad esempio:

UPDATE
table001
Inner Join table002 ON table001.ID = table002.ID
Inner Join table003 ON table001.ID2 = table003.ID2 AND table003.code = table002.code
Inner Join table004 ON table002.status = table004.status
set table001.IDstatus = table004.IDstatus;

La ram è ok (allocato circa 1 Gb costantemente) ma il processo prende il 2-10% della CPU disponibile (Pentium 4 3.2 GHz).
thx

[cipi]

La risposta di mysqld --verbose --help
abort-slave-event-count 0
allow-suspicious-udfs FALSE
auto-increment-increment 1
auto-increment-offset 1
automatic-sp-privileges TRUE
back_log 50
basedir F:/Programmi/MySQL/MySQL Server 5.1/
bind-address (No default value)
binlog-row-event-max-size 1024
binlog_cache_size 32768
binlog_format (No default value)
bulk_insert_buffer_size 8388608
character-set-client-handshake TRUE
character-set-filesystem binary
character-set-server latin1
character-sets-dir F:\Programmi\MySQL\MySQL Server 5.1\share\charsets\
chroot (No default value)
collation-server latin1_swedish_ci
completion-type 0
concurrent-insert 1
connect_timeout 5
console FALSE
datadir .
datetime_format %Y-%m-%d %H:%i:%s
date_format %Y-%m-%d
debug d:t:i:O,\mysqld.trace
default-character-set latin1
default-collation latin1_swedish_ci
default-storage-engine INNODB
default-table-type INNODB
default-time-zone (No default value)
default_week_format 0
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
des-key-file (No default value)
disconnect-slave-event-count 0
div_precision_increment 4
enable-locking FALSE
enable-named-pipe FALSE
enable-pstack FALSE
engine-condition-pushdown TRUE
expire_logs_days 0
external-locking FALSE
flush_time 1800
ft_max_word_len 84
ft_min_word_len 4
ft_query_expansion_limit 20
ft_stopword_file (No default value)
gdb FALSE
general-log FALSE
group_concat_max_len 1024
help TRUE
init-connect (No default value)
init-file (No default value)
init-slave (No default value)
innodb TRUE
innodb-additional-mem-pool-size 2097152
innodb-autoextend-increment 8
innodb-buffer-pool-size 1048576000
innodb-checksums TRUE
innodb-commit-concurrency 0
innodb-concurrency-tickets 500
innodb-data-file-path (No default value)
innodb-data-home-dir (No default value)
innodb-doublewrite TRUE
innodb-fast-shutdown 1
innodb-file-io-threads 4
innodb-file-per-table FALSE
innodb-flush-log-at-trx-commit 1
innodb-flush-method (No default value)
innodb-force-recovery 0
innodb-lock-wait-timeout 50
innodb-locks-unsafe-for-binlog FALSE
innodb-log-arch-dir (No default value)
innodb-log-buffer-size 1048576
innodb-log-file-size 25165824
innodb-log-files-in-group 2
innodb-log-group-home-dir (No default value)
innodb-max-dirty-pages-pct 90
innodb-max-purge-lag 0
innodb-mirrored-log-groups 1
innodb-open-files 300
innodb-rollback-on-timeout FALSE
innodb-stats-on-metadata TRUE
innodb-status-file FALSE
innodb-support-xa TRUE
innodb-sync-spin-loops 20
innodb-table-locks TRUE
innodb-thread-concurrency 8
innodb-thread-sleep-delay 10000
interactive_timeout 28800
join_buffer_size 131072
key_buffer_size 26214400
key_cache_age_threshold 300
key_cache_block_size 1024
key_cache_division_limit 100
language F:\Programmi\MySQL\MySQL Server 5.1\share\english\
lc-time-names en_US
local-infile TRUE
log (No default value)
log-bin (No default value)
log-bin-index (No default value)
log-bin-trust-function-creators FALSE
log-bin-trust-routine-creators FALSE
log-error
log-isam myisam.log
log-output TABLE
log-queries-not-using-indexes FALSE
log-short-format FALSE
log-slave-updates FALSE
log-slow-admin-statements FALSE
log-slow-queries (No default value)
log-tc tc.log
log-tc-size 24576
log-update (No default value)
log-warnings 1
long_query_time 10
low-priority-updates FALSE
lower_case_table_names 1
master-connect-retry 60
master-host (No default value)
master-info-file master.info
master-password (No default value)
master-port 3306
master-retry-count 86400
master-ssl FALSE
master-ssl-ca (No default value)
master-ssl-capath (No default value)
master-ssl-cert (No default value)
master-ssl-cipher (No default value)
master-ssl-key (No default value)
master-user test
max-binlog-dump-events 0
max_allowed_packet 1048576
max_binlog_cache_size 4294967295
max_binlog_size 1073741824
max_connections 100
max_connect_errors 10
max_delayed_threads 20
max_error_count 64
max_heap_table_size 16777216
max_join_size 4294967295
max_length_for_sort_data 1024
max_prepared_stmt_count 16382
max_relay_log_size 0
max_seeks_for_key 4294967295
max_sort_length 1024
max_sp_recursion_depth 0
max_tmp_tables 32
max_user_connections 0
max_write_lock_count 4294967295
memlock FALSE
multi_range_count 256
myisam-recover OFF
myisam_block_size 1024
myisam_data_pointer_size 6
myisam_max_extra_sort_file_size 107374182400
myisam_max_sort_file_size 107374182400
myisam_repair_threads 1
myisam_sort_buffer_size 36700160
myisam_stats_method nulls_unequal
myisam_use_mmap FALSE
ndb-use-copying-alter-table FALSE
net_buffer_length 16384
net_read_timeout 30
net_retry_count 10
net_write_timeout 60
new FALSE
old FALSE
old-alter-table FALSE
old-passwords FALSE
old-style-user-limits FALSE
open_files_limit 622
optimizer_prune_level 1
optimizer_search_depth 62
pid-file F:\Programmi\MySQL\MySQL Server 5.1\Data\enepc156.pid
plugin_dir F:\Programmi\MySQL\MySQL Server 5.1\lib/
plugin_load (No default value)
port 3306
port-open-timeout 0
preload_buffer_size 32768
query_alloc_block_size 8192
query_cache_limit 1048576
query_cache_min_res_unit 4096
query_cache_size 0
query_cache_type 1
query_cache_wlock_invalidate FALSE
query_prealloc_size 8192
range_alloc_block_size 2048
read_buffer_size 61440
read_only FALSE
read_rnd_buffer_size 258048
record_buffer 61440
relay-log (No default value)
relay-log-index (No default value)
relay-log-info-file relay-log.info
relay_log_purge TRUE
relay_log_space_limit 0
replicate-same-server-id FALSE
report-host (No default value)
report-password (No default value)
report-port 3306
report-user (No default value)
rpl-recovery-rank 0
safe-user-create FALSE
secure-auth FALSE
secure-file-priv (No default value)
server-id 0
shared-memory FALSE
shared-memory-base-name MYSQL
show-slave-auth-info FALSE
skip-grant-tables FALSE
skip-slave-start FALSE
slave-load-tmpdir C:\DOCUME~1\admin\IMPOST~1\Temp
slave_compressed_protocol FALSE
slave_net_timeout 3600
slave_transaction_retries 10
slow-query-log FALSE
slow_launch_time 2
socket MySQL
sort_buffer_size 262136
sporadic-binlog-dump-fail FALSE
sql-mode STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
ssl FALSE
ssl-ca (No default value)
ssl-capath (No default value)
ssl-cert (No default value)
ssl-cipher (No default value)
ssl-key (No default value)
symbolic-links TRUE
sync-binlog 0
sync-frm TRUE
sysdate-is-now FALSE
table_cache 256
table_definition_cache 128
table_lock_wait_timeout 50
table_open_cache 256
tc-heuristic-recover (No default value)
temp-pool TRUE
thread_cache_size 8
thread_concurrency 10
thread_stack 196608
timed_mutexes FALSE
time_format %H:%i:%s
tmpdir (No default value)
tmp_table_size 18874368
transaction_alloc_block_size 8192
transaction_prealloc_size 4096
updatable_views_with_limit 1
use-symbolic-links TRUE
verbose TRUE
wait_timeout 28800
warnings 1

To see what values a running MySQL server is using, type
'mysqladmin variables' instead of 'mysqld --verbose --help'.

070910 11:52:42 [Note] mysqld: Shutdown complete


C:\Documents and Settings\admin\Documenti>

[cipi]

:help: