Mysql und Log-Inhalt

michael12
Posts: 7
Joined: 2006-04-08 12:22

Mysql und Log-Inhalt

Post by michael12 »

Hallo,

kann mir jemand sagen, was diese Logeinträge genau besagen ? Das Warning in den Datenbanken hört sich nicht gut an.

Jul 18 13:15:45 R22129 mysqld[1609]: 070718 13:15:45 InnoDB: Database was not shut down normally!
Jul 18 13:15:45 R22129 mysqld[1609]: InnoDB: Starting crash recovery.
Jul 18 13:15:45 R22129 mysqld[1609]: InnoDB: Reading tablespace information from the .ibd files...
Jul 18 13:15:45 R22129 mysqld[1609]: InnoDB: Restoring possible half-written data pages from the doublewrite
Jul 18 13:15:45 R22129 mysqld[1609]: InnoDB: buffer...
Jul 18 13:15:45 R22129 mysqld[1609]: 070718 13:15:45 InnoDB: Starting log scan based on checkpoint at
Jul 18 13:15:45 R22129 mysqld[1609]: InnoDB: log sequence number 0 1228906.
Jul 18 13:15:45 R22129 mysqld[1609]: InnoDB: Doing recovery: scanned up to log sequence number 0 1228998
Jul 18 13:15:46 R22129 mysqld[1609]: InnoDB: Last MySQL binlog file position 0 4, file name /var/log/mysql/mysql-bin.000270
Jul 18 13:15:46 R22129 mysqld[1609]: 070718 13:15:46 InnoDB: Flushing modified pages from the buffer pool...
Jul 18 13:15:46 R22129 mysqld[1609]: 070718 13:15:46 InnoDB: Started; log sequence number 0 1228998
Jul 18 13:15:46 R22129 mysqld[1609]: Version: '4.1.15-Debian_0.dotdeb.4-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Source distribution
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: WARNING: mysqlcheck has found corrupt tables
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: confixx.allgemein
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: warning : 1 client is using or hasn't closed the table properly
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: confixx.grep
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: warning : 1 client is using or hasn't closed the table properly
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: confixx.kunden
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: warning : 1 client is using or hasn't closed the table properly
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: confixx.register
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: warning : 1 client is using or hasn't closed the table properly
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: confixx.transfer
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: warning : 1 client is using or hasn't closed the table properly
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: confixx.zeiten
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: warning : 1 client is using or hasn't closed the table properly
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: usr_web10_1.witze
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: warning : 1 client is using or hasn't closed the table properly
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: usr_web4_2.access_log
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: warning : 1 client is using or hasn't closed the table properly
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: usr_web4_2.cron_status
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: warning : 1 client is using or hasn't closed the table properly
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: usr_web4_2.domain
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: warning : 1 client is using or hasn't closed the table properly
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: usr_web4_2.sessions
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: warning : 1 client is using or hasn't closed the table properly
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: usr_web5_1.pikomedia_lists
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: warning : 1 client is using or hasn't closed the table properly
Jul 18 13:15:54
R22129 /etc/mysql/debian-start[2515]:
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: Improperly closed tables are also reported if clients are accessing
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: the tables *now*. A list of current connections is below.
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]:
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: +----+------------------+-----------+----+---------+------+-------+------------------+
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: | Id | User | Host | db | Command | Time | State | Info |
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: +----+------------------+-----------+----+---------+------+-------+------------------+
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: | 5 | debian-sys-maint | localhost | | Query | 0 | | show processlist |
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: +----+------------------+-----------+----+---------+------+-------+------------------+
Jul 18 13:15:54 R22129 /etc/mysql/debian-start[2515]: Uptime: 8 Threads: 1 Questions: 334 Slow queries: 0 Opens: 275 Flush tables: 1 Open tables: 64 Queries per second avg: 41.750

Gruss
Top

Roger Wilco
Administrator
Administrator
Posts: 6001
Joined: 2004-05-23 12:53

Re: Mysql und Log-Inhalt

Post by Roger Wilco »

Dein mysqld wurde nicht korrekt beendet und die einzelnen Datenbanken/Tabellen daher nicht richtig geschlossen. Überprüfe die Datenbanken/Tabellen (http://dev.mysql.com/doc/refman/5.0/en/check-table.html) und repariere sie sofern nötig.
Top