mySQL der Grund warum mein Server häufig crasht?

beiter

Registered User
Hallo.. Ich hab schon die Suche benutzt, leider noch nicht das gefunden was ich suche.

Ich habe bei Alturo.de einen Server. 2Ghz. 256MB RAM. Doch in den letzten Tagen crasht der Server öfters.

Ich schick ich mal ein paar Infos.

MySQL 4.1.11-Debian_4sarge2-log

Meine my.cnf

Code:
[client]
port		= 3306
socket		= /var/run/mysqld/mysqld.sock
[mysqld_safe]
socket		= /var/run/mysqld/mysqld.sock
nice		= 0
err-log               = /var/log/mysql/mysql.err 


[mysqld]

user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /tmp
language	= /usr/share/mysql/english
log-slow-queries = /var/log/mysql/mysql-slow.log

old_passwords	= 1

bind-address		= 127.0.0.1

key_buffer		= 25M
max_allowed_packet	= 16M
thread_stack		= 128K


query_cache_limit	= 1048576
query_cache_size        = 16777216
query_cache_type        = 1

log-bin			= /var/log/mysql/mysql-bin.log


max_binlog_size         = 104857600
binlog-do-db		= include_database_name
binlog-ignore-db	= include_database_name

skip-bdb

Die mysql.err und mysql.log Dateien sind leider leer. :(

Code:
+-----+------+-----------+----+---------+------+-------+------------------+
| Id  | User | Host      | db | Command | Time | State | Info             |
+-----+------+-----------+----+---------+------+-------+------------------+
| 637 | root | localhost |    | Query   | 0    |       | show processlist |
+-----+------+-----------+----+---------+------+-------+------------------+

Code:
mysql      658  0.1  9.2 128992 22592 ?      S    03:42   1:04 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysq
root       659  0.0  0.2  1572  508 ?        S    03:42   0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld

Ich hoffe ihr könnt mir helfen.. Danke schön.
 
Back
Top