PDA

Archiv verlassen und diese Seite im Standarddesign anzeigen : MYSQL-Problem?



d-talk72
09.05.07, 08:14
Hallo zusammen, hoffe ich schreibe es nicht ins falsche Forum.....,

habe seit einigen Tagen, mehr und mehr Probleme mit meinem Root Server. Dort läuft Debian 3.1 und Confixx 3.2

Erhalte derzeit schon mindestens 8-10 Mal am Tag eine Mail vom Server mit folgendem Inhalt:

Warning: mysqlcheck has found corrupt tables

confixx.allgemein
warning : 1 client is using or hasn't closed the table properly
confixx.register
warning : 1 client is using or hasn't closed the table properly
confixx.zeiten
warning : 1 client is using or hasn't closed the table properly
usr_web1_1.datastore
warning : 1 client is using or hasn't closed the table properly
usr_web1_1.postparsed
warning : 1 client is using or hasn't closed the table properly
usr_web1_1.regimage
warning : 1 client is using or hasn't closed the table properly
usr_web1_1.thread
warning : 1 client is using or hasn't closed the table properly
usr_web2_1.threads
warning : 1 client is using or hasn't closed the table properly
usr_web2_1.useronlineguests
warning : 1 client is using or hasn't closed the table properly
usr_web3_2.thread
warning : 1 client is using or hasn't closed the table properly
usr_web6_1.ufb_sessions
warning : 1 client is using or hasn't closed the table properly
usr_web6_2.threads
warning : 1 client is using or hasn't closed the table properly

Improperly closed tables are also reported if clients are accessing
the tables *now*. A list of current connections is below.

+----+------------------+-----------+------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------------------+-----------+------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| 7 | web2 | localhost | usr_web2_1 | Query | 2 | Copying to tmp table | SELECT threads.ID, threads.titel, threads.icon, threads.hits, threads.pollquestion, threads.closed, |
| 8 | debian-sys-maint | localhost | | Query | 0 | | show processlist |
+----+------------------+-----------+------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
Uptime: 10 Threads: 2 Questions: 931 Slow queries: 0 Opens: 1223 Flush tables: 1 Open tables: 64 Queries per second avg: 93.100


Jedesmal wird davor der komplette Server rebootet....

Eine weitere Email enthält folgendes:

mysqldump: Got error: 145: Table './usr_web6_1/ufb_users' is marked as crashed and should be repaired when using LOCK TABLES

Repair-Tables hat bisher leider nix gebracht...

Hätte hier jemand einen Tipp für mich, was ich machen könnte?

Im Error Log steht noch folgendes:

7:35:54 2007] [warn] RSA server certificate CommonName (CN) `manzanoxxxx.webperoni.de' does NOT match server name!?

Gruss
d-talk72

Roger Wilco
09.05.07, 10:28
Wegen der kaputten(?) MySQL-Tabellen:
http://dev.mysql.com/doc/refman/5.0/en/myisamchk.html
http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html

Die letzte Warnung wird von deinem Webserver generiert und ist eigentlich selbsterklärend.