ich verwende das ApacheFriends XAMPP (Basispaket) version 1.6.4
Apache 2.2.6 MySQL 5.0.45 PHP 5.2.4 doch
leider hab ich das Problem, dass mein Mysql Server nach ca. 6 stunden keine connection mehr zulässt. "Cant connect to database".. Es findet sich auch keine Errors in der *.err Datei. Wenn ich versuche den Dienst neuzustarten, bekomm ich die Fehlermeldung: "Do you already have another mysqld server running on port: 3306 ?", es ist jedoch keine mysql gestartet bzw. es läuft kein anderes Programm im hintergrund was diesen Port belegt. Laut xampp Port check ist der port Free....
Ich muss quasi jedesmal den gesamten MS WIN 2003 Server neustarten um wieder eine Mysqlverbindung zu bekommen.
Auszug aus my.cfg sowie Status der Mysql
- Code: Select all
Dieser MySQL-Server läuft bereits 0 Tage, 2 Stunden, 37 Minuten und 1 Sekunden.
Traffic Tip ø pro Stunde
Empfangen 1,029 KiB 393 KiB
Gesendet 56 MiB 22 MiB
Insgesamt 57 MiB 22 MiB
Verbindungen ø pro Stunde %
max. gleichzeitige Verbindungen 3 --- ---
Fehlgeschlagen 0 0,00 0,00%
Abgebrochen 0 0,00 0,00%
Insgesamt 563 215,14 100,00%
Abfragestatistik: Seit seinem Start wurden 9,193 Abfragen an diesen MySQL-Server gesandt.
Insgesamt ø pro Stunde ø pro Minute ø pro Sekunde
9,193 3,51 k 58,55 0,00 k
Abfrageart ø pro Stunde %
admin commands 0 0,00 0,00%
alter db 0 0,00 0,00%
alter table 0 0,00 0,00%
analyze 0 0,00 0,00%
backup table 0 0,00 0,00%
begin 0 0,00 0,00%
call procedure 0 0,00 0,00%
change db 555 212,08 6,43%
change master 0 0,00 0,00%
check 0 0,00 0,00%
checksum 0 0,00 0,00%
commit 0 0,00 0,00%
create db 0 0,00 0,00%
create function 0 0,00 0,00%
create index 0 0,00 0,00%
create table 0 0,00 0,00%
create user 0 0,00 0,00%
delete 123 47,00 1,43%
delete multi 0 0,00 0,00%
do 0 0,00 0,00%
drop db 0 0,00 0,00%
drop function 0 0,00 0,00%
drop index 0 0,00 0,00%
drop table 0 0,00 0,00%
drop user 0 0,00 0,00%
flush 0 0,00 0,00%
grant 0 0,00 0,00%
ha close 0 0,00 0,00%
ha open 0 0,00 0,00%
ha read 0 0,00 0,00%
help 0 0,00 0,00%
insert 109 41,65 1,26%
insert select 0 0,00 0,00%
kill 0 0,00 0,00%
load 0 0,00 0,00%
load master data 0 0,00 0,00%
load master table 0 0,00 0,00%
lock tables 0 0,00 0,00%
optimize 0 0,00 0,00%
preload keys 0 0,00 0,00%
purge 0 0,00 0,00%
purge before date 0 0,00 0,00%
rename table 0 0,00 0,00%
repair 0 0,00 0,00%
replace 35 13,37 0,41%
replace select 0 0,00 0,00%
reset 0 0,00 0,00%
restore table 0 0,00 0,00%
revoke 0 0,00 0,00%
revoke all 0 0,00 0,00%
Abfrageart ø pro Stunde %
rollback 0 0,00 0,00%
savepoint 0 0,00 0,00%
select 7,434 2,840,72 86,14%
set option 36 13,76 0,42%
show binlog events 0 0,00 0,00%
show binlogs 4 1,53 0,05%
show charsets 9 3,44 0,10%
show collations 9 3,44 0,10%
show column types 0 0,00 0,00%
show create db 0 0,00 0,00%
show create table 0 0,00 0,00%
show databases 9 3,44 0,10%
show errors 0 0,00 0,00%
show fields 0 0,00 0,00%
show grants 2 0,00 k 0,02%
show innodb status 0 0,00 0,00%
show keys 0 0,00 0,00%
show logs 0 0,00 0,00%
show master status 0 0,00 0,00%
show ndb status 0 0,00 0,00%
show new master 0 0,00 0,00%
show open tables 0 0,00 0,00%
show privileges 0 0,00 0,00%
show processlist 0 0,00 0,00%
show slave hosts 0 0,00 0,00%
show slave status 0 0,00 0,00%
show status 2 0,00 k 0,02%
show storage engines 0 0,00 0,00%
show tables 20 7,64 0,23%
show triggers 0 0,00 0,00%
show variables 19 7,26 0,22%
show warnings 0 0,00 0,00%
slave start 0 0,00 0,00%
slave stop 0 0,00 0,00%
stmt close 0 0,00 0,00%
stmt execute 0 0,00 0,00%
stmt fetch 0 0,00 0,00%
stmt prepare 0 0,00 0,00%
stmt reset 0 0,00 0,00%
stmt send long data 0 0,00 0,00%
truncate 0 0,00 0,00%
unlock tables 0 0,00 0,00%
update 266 101,65 3,08%
update multi 0 0,00 0,00%
xa commit 0 0,00 0,00%
xa end 0 0,00 0,00%
xa prepare 0 0,00 0,00%
xa recover 0 0,00 0,00%
xa rollback 0 0,00 0,00%
xa start 0 0,00 0,00%
Flush_commands 1
Last_query_cost 0
Slow_queries 0
Innodb_buffer_pool_pages_data 0
Innodb_buffer_pool_pages_dirty 0
Innodb_buffer_pool_pages_flushed 0
Innodb_buffer_pool_pages_free 0
Innodb_buffer_pool_pages_latched 0
Innodb_buffer_pool_pages_misc 0
Innodb_buffer_pool_pages_total 0
Innodb_buffer_pool_read_ahead_rnd 0
Innodb_buffer_pool_read_ahead_seq 0
Innodb_buffer_pool_read_requests 0
Innodb_buffer_pool_reads 0
Innodb_buffer_pool_wait_free 0
Innodb_buffer_pool_write_requests 0
Innodb_data_fsyncs 0
Innodb_data_pending_fsyncs 0
Innodb_data_pending_reads 0
Innodb_data_pending_writes 0
Innodb_data_read 0
Innodb_data_reads 0
Innodb_data_writes 0
Innodb_data_written 0
Innodb_dblwr_pages_written 0
Innodb_dblwr_writes 0
Innodb_log_waits 0
Innodb_log_write_requests 0
Innodb_log_writes 0
Innodb_os_log_fsyncs 0
Innodb_os_log_pending_fsyncs 0
Innodb_os_log_pending_writes 0
Innodb_os_log_written 0
Innodb_page_size 0
Innodb_pages_created 0
Innodb_pages_read 0
Innodb_pages_written 0
Innodb_row_lock_current_waits 0
Innodb_row_lock_time 0
Innodb_row_lock_time_avg 0
Innodb_row_lock_time_max 0
Innodb_row_lock_waits 0
Innodb_rows_deleted 0
Innodb_rows_inserted 0
Innodb_rows_read 0
Innodb_rows_updated 0
Ssl_accept_renegotiates 0
Ssl_accepts 0
Ssl_callback_cache_hits 0
Ssl_cipher
Ssl_cipher_list
Ssl_client_connects 0
Ssl_connect_renegotiates 0
Ssl_ctx_verify_depth 0
Ssl_ctx_verify_mode 0
Ssl_default_timeout 0
Ssl_finished_accepts 0
Ssl_finished_connects 0
Ssl_session_cache_hits 0
Ssl_session_cache_misses 0
Ssl_session_cache_mode NONE
Ssl_session_cache_overflows 0
Ssl_session_cache_size 0
Ssl_session_cache_timeouts 0
Ssl_sessions_reused 0
Ssl_used_session_cache_entries 0
Ssl_verify_depth 0
Ssl_verify_mode 0
Ssl_version
Handler_commit 0
Handler_delete 69
Handler_discover 0
Handler_prepare 0
Handler_read_first 1,192
Handler_read_key 17 k
Handler_read_next 3,219
Handler_read_prev 344
Handler_read_rnd 3,836
Handler_read_rnd_next 214 k
Handler_rollback 0
Handler_savepoint 0
Handler_savepoint_rollback 0
Handler_update 297
Handler_write 8,019
Qcache_free_blocks 0
Qcache_free_memory 0
Qcache_hits 0
Qcache_inserts 0
Qcache_lowmem_prunes 0
Qcache_not_cached 0
Qcache_queries_in_cache 0
Qcache_total_blocks 0
Slow_launch_threads 0
Threads_cached 0
Threads_connected 1
Threads_created 562
Threads_running 1
Threads_cache_hitrate_% 0,18 %
Binlog_cache_disk_use 0
Binlog_cache_use 0
Created_tmp_disk_tables 71
Created_tmp_files 0
Created_tmp_tables 205
Delayed_errors 0
Delayed_insert_threads 0
Delayed_writes 0
Not_flushed_delayed_rows 0
Key_blocks_not_flushed 0
Key_blocks_unused 229 k
Key_blocks_used 218
Key_read_requests 48 k
Key_reads 784
Key_write_requests 246
Key_writes 136
Key_buffer_fraction_% 12,45 %
Key_write_ratio_% 55,28 %
Key_read_ratio_% 1,65 %
Select_full_join 36
Select_full_range_join 0
Select_range 525
Select_range_check 0
Select_scan 2,821
Slave_open_temp_tables 0
Slave_retried_transactions 0
Slave_running OFF
Sort_merge_passes 0
Sort_range 39
Sort_rows 5,586
Sort_scan 1,005
Open_tables 33
Opened_tables 435
Table_locks_immediate 8,908
Table_locks_waited 0
Tc_log_max_pages_used 0
Tc_log_page_size 0
Tc_log_page_waits 0
Compression OFF
Open_files 64
Open_streams 0
Prepared_stmt_count 0
Uptime_since_flush_status 9,421
-------- MY.CFG
port = 3306
socket = mysql
# The MySQL server
[mysqld]
basedir=C:/xampp/mysql
tmpdir=c:/xampp/tmp
datadir=C:/xampp/mysql/data
port = 3306
socket = mysql
old-passwords
character-set-server = latin1
collation-server = latin1_general_ci
skip-locking
key_buffer = 256M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K
server-id = 1
skip-bdb
skip-innodb
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 8M
sort_buffer_size = 8M
[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M
[mysqlhotcopy]
interactive-timeout
[WinMySQLadmin]
Server=C:/xampp/mysql/bin/mysqld-nt.exe
#user=root
#password=
QueryInterval=10
Meine Suche im Netz, nach diesem Problem, war leider bislang ohne jeglichen Erfolg.
Hoffe ich habe soweit alle wichtigen Daten genannt um auf den Bug aufmerksam zu werden!
Bin da leider ein wenig verzweifelt und hoffe, dass mir da Jemand helfen kann!
Herzlichen Dank schon mal in voraus für eure Mühen und Hilfen!!!!
Grüße Max