江湖救急 mysql 无法启动。

[jc]

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.

[ACMAIN_CHM]

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

[jc]

磁盘还有空间

259G 128G 118G 53% /

[ACMAIN_CHM]

临时文件交换区呢？

[jc]

[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

[jc]

# 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

[jc]

# 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

上个发错了