Re: [OT] Problemas con Mysql (XBuffer?)
| From: | Mauricio Cer�n P. | 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!! :)