ผมลง CentOS 5.6 +Percona 55-5.5.14-rel20.5.149.rhel5.x86_64.rpm แล้ว start mysql ไม่ได้ ไม่ทราบว่าเกิดจากอะไรครับ
แรม 4G ครับ
my.cnf
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
#basedir = /var/lib/mysql
#datadir = /var/lib/mysql/data
default-character-set=tis620
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 512M
max_allowed_packet = 32M
table_cache = 1000
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 1M
max_heap_table_size = 128M
myisam_sort_buffer_size = 128M
thread_cache = 8
query_cache_size= 256M
thread_concurrency = 8
default-character-set=tis620
skip-name-resolve
innodb_file_per_table
skip-character-set-client-handshake
init_connect = 'SET NAMES tis620'
max_connections = 1000
######################################## 5.1.25--->X cpu multicore
innodb_thread_concurrency = 0
########################################
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
############################# mysql 5.1.X
#innodb_log_arch_dir = /var/lib/mysql/
#############################
#############################
# add rc.local ---> ulimit -n 30000
#############################
innodb_buffer_pool_size = 2048M
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 256M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 32M
allow-keywords
[mysql]
no-auto-rehash
default-character-set=tis620
[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 1M
write_buffer = 1M
[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 1M
write_buffer = 1M
[mysqlhotcopy]
interactive-timeout
-------------------------------------------------------------------------------------
อันนี้ .err ครับ
110824 22:41:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
110824 22:41:54 [Note] Flashcache bypass: disabled
110824 22:41:54 [Note] Flashcache setup error is : ioctl failed
110824 22:41:54 [Note] Plugin 'FEDERATED' is disabled.
110824 22:41:54 InnoDB: The InnoDB memory heap is disabled
110824 22:41:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins
110824 22:41:54 InnoDB: Compressed tables use zlib 1.2.3
110824 22:41:54 InnoDB: Using Linux native AIO
110824 22:41:54 InnoDB: Initializing buffer pool, size = 2.0G
110824 22:41:54 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file /var/lib/mysql/ibdata1 did not exist:
InnoDB: a new database to be created!
110824 22:41:54 InnoDB: Setting file /var/lib/mysql/ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
110824 22:41:55 InnoDB: Log file /var/lib/mysql/ib_logfile0 did not exist: new to be created
InnoDB: Setting log file /var/lib/mysql/ib_logfile0 size to 256 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200
110824 22:41:58 InnoDB: Log file /var/lib/mysql/ib_logfile1 did not exist: new to be created
InnoDB: Setting log file /var/lib/mysql/ib_logfile1 size to 256 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
110824 22:42:01 InnoDB: Waiting for the background threads to start
110824 22:42:02 Percona XtraDB (
http://www.percona.com) 1.1.8-20.1 started; log sequence number 0
110824 22:42:02 [ERROR] /usr/sbin/mysqld: unknown option '--skip-locking'
110824 22:42:02 [ERROR] Aborting
110824 22:42:02 InnoDB: Starting shutdown...
110824 22:42:06 InnoDB: Shutdown completed; log sequence number 1597945
110824 22:42:06 [Note] /usr/sbin/mysqld: Shutdown complete
110824 22:42:06 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
หัวข้อ: start mysql ไม่ได้ครับ (อ่าน 14680 ครั้ง)