MYSQL Connection Abbruch

Irgendwelche Probleme mit XAMPP für Windows? Dann ist hier genau der richtige Ort um nachzufragen.

MYSQL Connection Abbruch

Postby n3oth3on3 » 25. February 2009 21:03

Guten Tag,
bin zwar neu hier aber hab schon eine frage zu meinen Datenbanken. Hab zurzeit einen Root mit 1GB Ram worauf ein Server läuft, mein Problem ist sobalt auf dem Server mehr als 80 User drauf sind oder nach einer Zeit von 30 Minuten bricht der Server die connection ab, und startet dadurch neu. Am Server liegt nicht, da bin ich mir ziehmlich sicher. Es ist ein Gameserver zu einem Rollenspiel,das heißt kein CS Server oder so.

Das sind so die Fehler die ich mir vom Server ausgeben haben lass :

Code: Select all
25/02/2009 17:25:11 mysql_store_result(): SELECT `id` FROM `accounts` WHERE `name` = '595959' - MYSQL ERROR: Lost connection to MySQL server during query
25/02/2009 17:25:11 mysql_real_query(): DELETE FROM `account_storage` WHERE  `key` = 880  AND  `charname` = 'Jan of War' ; - MYSQL ERROR: Lost connection to MySQL server during query
25/02/2009 17:31:45 mysql_real_query(): DELETE FROM `account_storage` WHERE  `key` = 880  AND  `charname` = 'Flylas' ; - MYSQL ERROR: Lost connection to MySQL server during query


Hab heute dann die Config von hier gefunden und sie versucht auf meinen Windows 2003 Server zuändern, doch nun geht der Server gar nicht mehr an.
n3oth3on3
 
Posts: 5
Joined: 25. February 2009 21:01

Re: MYSQL Connection Abbruch

Postby Wiedmann » 25. February 2009 21:52

worauf ein Server läuft

Du hast aber schon einen XAMPP laufen?

Hab heute dann die Config von hier gefunden

Welche "Config"?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: MYSQL Connection Abbruch

Postby n3oth3on3 » 25. February 2009 22:12

Xampp ist am laufen und zurzeit laufen alle drei Dienste wie Apache, Mysql und FTP. Denn Satz mit dem Config kannst du streichen, hab in einem anderem Board eine config gefunden doch diese lief bei mir nicht, dann wurde mein Thread closed. So bin ich dann halt direkt zum Apache Forum gekommen.

Mein Problem sind nun die disconnetcs, kann das an der my.cfg liegen?

Hab die werte nun einfach auf das 4fache erhöht und ansich läufts nun, also nur MYSQL, aber der Server kommt nun schon nach 10 sekunden damit :

MYSQL Connection lost... Reconnecting...

Code: Select all
# Example MySQL config file for small systems.
#
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld daemon
# doesn't use much resources.
#
# You can copy this file to
# C:/xampp/mysql/bin/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is C:/xampp/mysql/data) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
[client]
# password       = your_password
port            = 3306
socket          = "C:/xampp/mysql/mysql.sock"

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port= 3306
socket= "C:/xampp/mysql/mysql.sock"
basedir="C:/xampp/mysql"
tmpdir="C:/xampp/tmp"
datadir="C:/xampp/mysql/data"
skip-locking
key_buffer = 64M
max_allowed_packet = 4M
table_cache = 256
sort_buffer_size = 2M
net_buffer_length = 32K
read_buffer_size = 1M
read_rnd_buffer_size = 2M
myisam_sort_buffer_size = 32M



# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
# commented in by lampp security
#skip-networking
skip-federated

# Replication Master Server (default)
# binary logging is required for replication
# log-bin deactivated by default since XAMPP 1.4.11
#log-bin=mysql-bin

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id   = 1

# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
#    the syntax is:
#
#    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
#    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
#
#    where you replace <host>, <user>, <password> by quoted strings and
#    <port> by the master's port number (3306 by default).
#
#    Example:
#
#    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
#    MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR
#
# 2) Set the variables below. However, in case you choose this method, then
#    start replication for the first time (even unsuccessfully, for example
#    if you mistyped the password in master-password and the slave fails to
#    connect), the slave will create a master.info file, and any later
#    change in this file to the variables' values below will be ignored and
#    overridden by the content of the master.info file, unless you shutdown
#    the slave server, delete master.info and restart the slaver server.
#    For that reason, you may want to leave the lines below untouched
#    (commented) and instead use CHANGE MASTER TO (see above)
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id       = 2
#
# The replication master for this slave - required
#master-host     =   <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user     =   <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password =   <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port     =  <port>
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin


# Point the following paths to different dedicated disks
#tmpdir = "C:/xampp/tmp"
#log-update = /path-to-dedicated-directory/hostname

# Uncomment the following if you are using BDB tables
#bdb_cache_size = 4M
#bdb_max_lock = 10000

# Comment the following if you are using InnoDB tables
#skip-innodb
innodb_data_home_dir = "C:/xampp/mysql/"
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = "C:/xampp/mysql/"
#innodb_log_arch_dir = "C:/xampp/mysql/"
## You can set .._buffer_pool_size up to 50 - 80 %
## of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 63M
innodb_additional_mem_pool_size = 16M
## Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 20M
innodb_log_buffer_size = 32M
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 120

[mysqldump]
quick
max_allowed_packet = 32M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 80M
sort_buffer_size = 80M
read_buffer = 8M
write_buffer = 8M

[myisamchk]
key_buffer = 80M
sort_buffer_size = 80M
read_buffer = 8M
write_buffer = 8M

[mysqlhotcopy]
interactive-timeout
n3oth3on3
 
Posts: 5
Joined: 25. February 2009 21:01

Re: MYSQL Connection Abbruch

Postby Wiedmann » 25. February 2009 22:45

Xampp ist am laufen

Welcher XAMPP?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: MYSQL Connection Abbruch

Postby n3oth3on3 » 25. February 2009 22:58

Wiedmann wrote:
Xampp ist am laufen

Welcher XAMPP?


1.7.0 der neuste der auf der Seite war.
n3oth3on3
 
Posts: 5
Joined: 25. February 2009 21:01

Re: MYSQL Connection Abbruch

Postby Wiedmann » 25. February 2009 23:15

1.7.0 der neuste der auf der Seite war.

Das hast du schonmal gemacht?
viewtopic.php?f=4&p=136761#p136761
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: MYSQL Connection Abbruch

Postby n3oth3on3 » 25. February 2009 23:23

Wenn ich das mache geht MYSQL gar nicht mehr an.Habs genau so gemacht wie es da stand... :(
n3oth3on3
 
Posts: 5
Joined: 25. February 2009 21:01

Re: MYSQL Connection Abbruch

Postby Wiedmann » 25. February 2009 23:26

Wenn ich das mache geht MYSQL gar nicht mehr an.

Dann hast du nicht das gemacht, auf das ich verlinkt habe (es geht um das Kopieren dieser DLL's).

(Diese Änderung hat mit dem MySQL - Dienst gar nichts zu tun.)
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: MYSQL Connection Abbruch

Postby n3oth3on3 » 25. February 2009 23:32

Wiedmann wrote:
Wenn ich das mache geht MYSQL gar nicht mehr an.

Dann hast du nicht das gemacht, auf das ich verlinkt habe (es geht um das Kopieren dieser DLL's).

(Diese Änderung hat mit dem MySQL - Dienst gar nichts zu tun.)



Edit : Hab nun wieder die standard my.cfg genommen nun gehen die Änderungen, bei MYSQL
Code: Select all
[26/02/2009 09:58:01] MYSQL Connection lost... Reconnecting...
[26/02/2009 09:58:12] MYSQL Connection lost... Reconnecting...
[26/02/2009 09:58:23] MYSQL Connection lost... Reconnecting...


Mein Server meint dies trotzdem :(
n3oth3on3
 
Posts: 5
Joined: 25. February 2009 21:01


Return to XAMPP für Windows

Who is online

Users browsing this forum: No registered users and 11 guests