Re: [OT] Problemas con Mysql (XBuffer?)

From: Date: Wed, 26 Mar 2003 00:28:34 +0000
Subject: Re: [OT] Problemas con Mysql (XBuffer?)
References: 1 2 3  Groups: php.general.es 
Request: Send a blank email to general-es+get-34246@lists.php.net to get a copy of this message
Disculpa lo extenso, pero este es el informe con la configuración actual. This Report was made using the WinMySQLadmin 1.0 Tool 25-03-2003 20:25:53 Description : How-To-Repeat : Fix : Synopsis : Submitter-Id : Originator : Organization : MySQL support : [none | licence | email support | extended email support ] Severity : [non-critical | serious | critical ] Priority : [low | medium | high ] Category : [mysqld, mysql client, C, PHP, PERL, ...] Class : [ sw-bug | doc-bug | change-request | support ] OS Platform : Windows NT detected Machine description: Compiler : VC++ 6.0 Architecture : i686 Total Memory : 261,616 MB RAM My.ini File [mysqld] basedir=C:/Archivos de programa/Abria Merlin/MySQL datadir=C:/Archivos de programa/Abria Merlin/MySQL/data Server Status Values Server Info 3.23.36 Host Info localhost via TCP/IP Client Info 3.23.33 Proto Info 10 Aborted_clients 1 Aborted_connects 0 Bytes_received 0 Bytes_sent 0 Connections 2237 Created_tmp_disk_tables 0 Created_tmp_tables 0 Created_tmp_files 0 Delayed_insert_threads 0 Delayed_writes 0 Delayed_errors 0 Flush_commands 1 Handler_delete 505 Handler_read_first 1 Handler_read_key 2164 Handler_read_next 16 Handler_read_prev 0 Handler_read_rnd 0 Handler_read_rnd_next 409601 Handler_update 147 Handler_write 0 Key_blocks_used 826 Key_read_requests 8749 Key_reads 826 Key_write_requests 1062 Key_writes 1044 Max_used_connections 2 Not_flushed_key_blocks 0 Not_flushed_delayed_rows 0 Open_tables 1 Open_files 2 Open_streams 0 Opened_tables 37 Questions 15158 Select_full_join 0 Select_full_range_join 0 Select_range 14 Select_range_check 0 Select_scan 43 Slave_running OFF Slave_open_temp_tables 0 Slow_launch_threads 0 Slow_queries 0 Sort_merge_passes 0 Sort_range 0 Sort_rows 0 Sort_scan 0 Table_locks_immediate 2914 Table_locks_waited 0 Threads_cached 0 Threads_created 2236 Threads_connected 1 Threads_running 1 Uptime 29563 Variables Values ansi_mode OFF back_log 50 basedir c:\archivos de programa\abria merlin\mysql\ binlog_cache_size 32768 character_set latin1 character_sets latin1 big5 czech euc_kr gb2312 gbk 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 concurrent_insert ON connect_timeout 5 datadir c:\archivos de programa\abria merlin\mysql\data\ delay_key_write ON delayed_insert_limit 100 delayed_insert_timeout 300 delayed_queue_size 1000 flush OFF flush_time 1800 have_bdb NO have_gemini NO have_innobase NO have_isam YES have_raid NO have_ssl NO init_file interactive_timeout 28800 join_buffer_size 131072 key_buffer_size 8388600 language c:\archivos de programa\abria merlin\mysql\share\english\ large_files_support ON log OFF log_update OFF log_bin OFF log_slave_updates OFF long_query_time 10 low_priority_updates OFF lower_case_table_names 1 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_recover_options OFF myisam_sort_buffer_size 8388608 net_buffer_length 16384 net_read_timeout 30 net_retry_count 10 net_write_timeout 60 open_files_limit 0 pid_file c:\archivos de programa\abria merlin\mysql\data\particul-4529xq.pid port 3306 protocol_version 10 record_buffer 131072 query_buffer_size 0 safe_show_database OFF server_id 0 skip_locking ON skip_networking OFF skip_show_database OFF slow_launch_time 2 socket MySQL sort_buffer 2097144 table_cache 64 table_type MYISAM thread_cache_size 0 thread_stack 65536 transaction_isolation READ-COMMITTED timezone Hora est. del Pacífico SA tmp_table_size 1048576 tmpdir c:\windows\temp\ version 3.23.36 wait_timeout 28800 "Andres Ferrando" <anferr@mecon.gov.ar> escribió en el mensaje news:20030325174346.665E.ANFERR@mecon.gov.ar... Hola! cuanto espacio libre tiene la partición donde tenés la base? y la de la carpeta temporal que usa mysql cuando hace las consultas? PD: gente, por favor quoteen un poco!! :)

« previous php.general.es (#34246) next »