forum.lissyara.su

Код: Выделить всё

mysql> check table request_prices;
+----------------------+-------+----------+----------------------------------------------+
| Table                | Op    | Msg_type | Msg_text                                     |
+----------------------+-------+----------+----------------------------------------------+
| della.request_prices | check | warning  | Table is marked as crashed                   |
| della.request_prices | check | error    | Record at pos: 45870212 is not remove-marked |
| della.request_prices | check | error    | record delete-link-chain corrupted           |
| della.request_prices | check | error    | Corrupt                                      |
+----------------------+-------+----------+----------------------------------------------+
4 rows in set (0.04 sec)
крашед

Код: Выделить всё

State: Waiting for table
   Info: SELECT (IF(c.is_absolute = 0, AVG(price), AVG(price/distance))) average, c.id, c.parent_id, is_absol
*************************** 291. row ***************************
     Id: 27036
   User: della
   Host: localhost
     db: della
Command: Query
   Time: 47664
  State: Waiting for table
   Info: SELECT (IF(c.is_absolute = 0, AVG(price), AVG(price/distance))) average, c.id, c.parent_id, is_absol
*************************** 292. row ***************************
     Id: 27052
   User: della
   Host: localhost
     db: della
Command: Query
   Time: 47657
  State: Waiting for table
   Info: SELECT (IF(c.is_absolute = 0, AVG(price), AVG(price/distance))) average, c.id, c.parent_id, is_absol
*************************** 293. row ********

Код: Выделить всё

Your MySQL connection id is 101694
Server version: 5.1.30-log FreeBSD port: mysql-server-5.1.30

Код: Выделить всё

mysql_args="--auto-repair"

Код: Выделить всё

zg# mysqld_safe --help | grep auto-repair
zg# mysql --help | grep auto-repair
zg# mysqlcheck --help | grep auto-repair
  --auto-repair       If a checked table is corrupted, automatically fix it.
                      with --auto-repair to correct tables requiring
auto-repair                       FALSE
zg#

Код: Выделить всё

zg# cat /etc/my.cnf
[mysqld]
datadir=/home/db
default-character-set=cp1251
init-connect = "set names 'cp1251'"
skip-character-set-client-handshake
#log = /root/mysql-query.log

[mysqlcheck]
auto-repair
zg# mysqlcheck --help | grep auto-repair
  --auto-repair       If a checked table is corrupted, automatically fix it.
                      with --auto-repair to correct tables requiring
auto-repair                       TRUE
zg#