Hi guys,
the VMWare machine has 512Mb of RAM and 2.5 Ghz processor and uses SCSI
discs. I do not have an access to the VMWare host - so I do not have an
exact config parameters.
It looks like ESX Server virtual machine allows for 1Gb network, but it's
possible that some packets are lost because of my client's firewall
settings.
Here are my mysql server status params:
**************
| back_log 50
| basedir C:\mysql\
| binlog_cache_size 32768
| bulk_insert_buffer_size 8388608
| character_set latin1
| character_sets latin1 big5 czech euc_kr gb2312 gbk
latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7
cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek
win1250 croat cp1257 latin5 |
| concurrent_insert ON
| connect_timeout 5
| convert_character_set
| datadir C:\mysql\data\
| delay_key_write ON
| delayed_insert_limit 100
| delayed_insert_timeout 300
| delayed_queue_size 1000
| flush OFF
| flush_time 1800
| ft_boolean_syntax + -><()~*:""&|
| ft_min_word_len 4
| ft_max_word_len 254
| ft_max_word_len_for_sort 20
| ft_stopword_file (built-in)
| have_bdb NO
| have_crypt NO
| have_innodb YES
| have_isam YES
| have_raid NO
| have_symlink YES
| have_openssl NO
| have_query_cache YES
| init_file
| innodb_additional_mem_pool_size | 1048576
| innodb_buffer_pool_size 8388608
| innodb_data_file_path ibdata1:10M:autoextend
| innodb_data_home_dir
| innodb_file_io_threads 4
| innodb_force_recovery 0
| innodb_thread_concurrency 8
| innodb_flush_log_at_trx_commit 0
| innodb_fast_shutdown ON
| innodb_flush_method
| innodb_lock_wait_timeout 50
| innodb_log_arch_dir .\
| innodb_log_archive OFF
| innodb_log_buffer_size 1048576
| innodb_log_file_size 5242880
| innodb_log_files_in_group 2
| innodb_log_group_home_dir .\
| innodb_mirrored_log_groups 1
| interactive_timeout 28800
| join_buffer_size 131072
| key_buffer_size 8388600
| language C:\mysql\share\english\
| large_files_support ON
| local_infile ON
| log OFF
| log_update OFF
| log_bin OFF
| log_slave_updates OFF
| log_slow_queries OFF
| log_warnings OFF
| long_query_time 10
| low_priority_updates OFF
| lower_case_table_names ON
| 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_heap_table_size 16777216
| max_join_size 4294967295
| max_sort_length 1024
| max_user_connections 0
| max_tmp_tables 32
| max_write_lock_count 4294967295
| myisam_max_extra_sort_file_size | 268435456
| myisam_max_sort_file_size 2147483647
| myisam_recover_options OFF
| myisam_sort_buffer_size 8388608
| named_pipe OFF
| net_buffer_length 16384
| net_read_timeout 30
| net_retry_count 10
| net_write_timeout 60
| new OFF
| open_files_limit 0
| pid_file C:\mysql\data\SERV.pid
| log_error .\SERV.err
| port 3306
| protocol_version 10
| read_buffer_size 131072
| read_rnd_buffer_size 262144
| rpl_recovery_rank 0
| query_cache_limit 1048576
| query_cache_size 0
| query_cache_type ON
| server_id 0
| slave_net_timeout 3600
| skip_external_locking ON
| skip_networking OFF
| skip_show_database OFF
| slow_launch_time 2
| sort_buffer_size 2097144
| sql_mode 0
| table_cache 64
| table_type MYISAM
| thread_cache_size 0
| thread_stack 196608
| tx_isolation REPEATABLE-READ
| timezone Eastern Daylight Time
| tmp_table_size 33554432
| tmpdir C:\WINNT\TEMP\
| version 4.0.12-nt
| wait_timeout 28800
********************
On 10/27/05, Elena C <ecurry007@stripped> wrote:
>Folks,
>
>I have Mysql db server (4.0.12-nt) running on Windows 2000 partition that
>is
First of all, upgrade to the latest stable version *be careful with
upgrades from 4 to 4.1* this can be a bug fixed long ago, or not.
>actually a VMWare - ESX Server virtual machine.
Emulated? Hmmm, can't expect much from this kind of system.
>This VMWare machine has 524Mb of Ram allocated.
>The set of the databases on this server is minimal, and my.cnf values are
>set to "my.small" file.
>Nevertheless the db server stalls a couple of times a week with the system
>running up to 99% of CPU resources for mysqld alone for more than 3 min,
>and
>mysql service has to be restarted.
Could be so many things, could you post the configuration of the
virtual machine running it? Its hard to debug errors with a system
like this.
>I am trying to determine the cause of this. One of my "guesses" is that the
>network connection to this machine is notoriously slow, and there are
>network delays.
I don't think so, that would be no reason for such a "hunger" for resources.
>Does anyone know of mysql system issues that relate to the network outages?
>What happens if the query is issued to mysql server and the network
>connection terminates at that point - (the result set that suppose to be
>sent back to the client does not reach the client)?
The connection is closed after wait_timeout (variable) and a warning
is issued if you have log_warnings set.
>Sincerely,
>Elena.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------
