江湖救急 mysql 无法启动。

Question

InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use InnoDB's own implementation
110808 14:35:51  InnoDB: highest supported file format is Barracuda.
InnoDB: Error: trying to access page number 3148816594 in space 0,
InnoDB: space name ./ibdata1,
InnoDB: which is outside the tablespace bounds.
InnoDB: Byte offset 0, len 16384, i/o type 10.
InnoDB: If you get this error at mysqld startup, please check that
InnoDB: your my.cnf matches the ibdata files that you have in the
InnoDB: MySQL server.
110808 14:35:51  InnoDB: Assertion failure in thread 3086730960 in file fil/fil0fil.c line 4317
InnoDB: We intentionally generate a memory trap.
key_buffer_size=8388608
read_buffer_size=6291456
max_used_connections=0
max_threads=50
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 366913 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Answer 1

./ibdata1 这个文件有没有问题？ 检查一下你的my.cnf 文件中的设置。另外检查一下磁盘的状态和权限。

Answer 2

磁盘还有空间 259G  128G  118G  53% /

Answer 3

[mysqld]
#innodb_force_recovery=4
default-character-set = gbk
character-set-server = gbk
replicate-ignore-db = mysql
replicate-ignore-db = test
replicate-ignore-db = information_schema
user    = mysql
port    = 3306
socket  = /tmp/mysql.sock
basedir = /usr/local/webserver/mysql
datadir = /data0/mysql/3306/data
log-error = /data0/mysql/3306/mysql_error.log
pid-file = /data0/mysql/3306/mysql.pid
open_files_limit    = 10240
back_log = 600
max_connections = 50
max_connect_errors = 600
table_cache = 614
external-locking = FALSE
max_allowed_packet = 32M
sort_buffer_size = 1M
join_buffer_size = 1M
thread_cache_size = 300
thread_concurrency = 8
query_cache_size = 512M
query_cache_limit = 2M
query_cache_min_res_unit = 2k
default-storage-engine = MyISAM
thread_stack = 192K
transaction_isolation = READ-COMMITTED
tmp_table_size = 246M
max_heap_table_size = 246M
long_query_time = 3
log-slave-updates
log-bin = /data0/mysql/3306/binlog/binlog
binlog_cache_size = 128M
binlog-do-db = discuz
binlog-ignore-db=test
binlog-ignore-db=mysql
binlog-ignore-db=information_schema
binlog_format = MIXED
max_binlog_cache_size = 256M
max_binlog_size = 6M
relay-log-index = /data0/mysql/3306/relaylog/relaylog
relay-log-info-file = /data0/mysql/3306/relaylog/relaylog relay-log-info-file = /data0/mysql/3306/relaylog/relaylog
 53 relay-log = /data0/mysql/3306/relaylog/relaylog
 54 expire_logs_days = 30
 55 key_buffer_size = 8M
 56 read_buffer_size = 6M
 57 read_rnd_buffer_size = 16M
 58 bulk_insert_buffer_size = 64M
 59 myisam_sort_buffer_size = 128M
 60 myisam_max_sort_file_size = 1G
 61 myisam_repair_threads = 1
 62 myisam_recover
 63
 64 interactive_timeout = 120
 65 wait_timeout = 120
 66
 67 skip-name-resolve
 68 master-connect-retry = 10
 69 slave-skip-errors = 1032,1062,126,1114,1146,1048,1396
 70
 71 #master-host     =   192.168.1.2
 72 #master-user     =   username
 73 #master-password =   password
 74 #master-port     =  3306
 75
 76 server-id = 1
 77
 78 innodb_additional_mem_pool_size = 16M
 79 innodb_buffer_pool_size =512M
 80 innodb_data_file_path = ibdata1:256M:autoextend
 81 innodb_file_io_threads = 4
 82 innodb_thread_concurrency = 8
 83 innodb_flush_log_at_trx_commit = 2
 84 innodb_log_buffer_size = 16M
 85 innodb_log_file_size = 128M
 86 innodb_log_files_in_group = 3
 87 innodb_max_dirty_pages_pct = 90
 88 innodb_lock_wait_timeout = 120
 89 innodb_file_per_table = 0
 90
 91 #log-slow-queries = /data0/mysql/3306/slow.log
 92 #long_query_time = 10
 93
 94 [mysqldump]
 95 quick
 96 max_allowed_packet = 32M

Answer 4

# df -k
Filesystem           1K-blocks      Used Available Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
                      63768352   2113588  58363220   4% /
/dev/cciss/c0d0p1        98747     12066     81582  13% /boot
tmpfs                  1557940         0   1557940   0% /dev/shm

Answer 5

# df -kh
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
                      259G  128G  118G  53% /
/dev/sda1              99M   12M   82M  13% /boot
tmpfs                 8.0G     0  8.0G   0% /dev/shm上个发错了