[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]