warning: Percona-XtraDB-Cluster-client-5.5.24-23.6.341.rhel6.i686.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Preparing... ########################################### [100%]
1:Percona-XtraDB-Cluster-########################################## [ 13%]
2:Percona-XtraDB-Cluster-########################################## [ 25%]
3:Percona-XtraDB-Cluster-########################################## [ 38%]
4:Percona-XtraDB-Cluster-########################################## [ 50%]
5:Percona-XtraDB-Cluster-########################################## [ 63%]
6:Percona-XtraDB-Cluster-########################################## [ 75%]
7:Percona-XtraDB-Cluster-########################################## [ 88%]
8:Percona-XtraDB-Cluster-########################################## [100%]
120807 9:21:23 [Note] Flashcache bypass: disabled
120807 9:21:23 [Note] Flashcache setup error is : ioctl failed
120807 9:21:23 [Note] WSREP: Read nil XID from storage engines, skipping position init
120807 9:21:23 [Note] WSREP: wsrep_load(): loading provider library 'none'
120807 9:21:23 [ERROR] /usr/sbin/mysqld: unknown option '--skip-locking'
120807 9:21:23 [ERROR] Aborting
120807 9:21:23 [Note] WSREP: Service disconnected.
120807 9:21:24 [Note] WSREP: Some threads may fail to exit.
120807 9:21:24 [Note] /usr/sbin/mysqld: Shutdown complete
Installation of system tables failed! Examine the logs in
/var/lib/mysql for more information.
You can try to start the mysqld daemon with:
shell> /usr/sbin/mysqld --skip-grant &
and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:
shell> /usr/bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql that may be helpful.
Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS. Another information source are the
MySQL email archives available at
http://lists.mysql.com/.
Please check all of the above before mailing us! And remember, if
you do mail us, you MUST use the /usr/bin/mysqlbug script!
Percona XtraDB Cluster is distributed with several useful UDFs from Percona Toolkit.
Run the following commands to create these functions:
mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
See
http://code.google.com/p/maatkit/source/browse/trunk/udf for more details
[root@myhostname ~]# service mysql restart
MySQL (Percona Server) PID file could not be found! [FAILED]
Starting MySQL (Percona Server).The server quit without upd[FAILED]D file (/var/lib/mysql/myhostname.mydomain.pid).#################my.cnf 4G#######################
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
default-character-set=tis620
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 820M
max_allowed_packet = 128M
table_cache = 1500
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 1M
myisam_sort_buffer_size = 512M
thread_cache_size = 8
query_cache_size= 386M
thread_concurrency = 8
default-character-set=tis620
skip-name-resolve
skip-character-set-client-handshake
init_connect = 'SET NAMES tis620'
innodb_file_per_table
innodb_data_home_dir = /var/lib/mysql/
#interactive_timeout = 600
#wait_timeout = 1200
innodb_data_file_path = ibdata1:100M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
############################# mysql 5.1.X
#innodb_log_arch_dir = /var/lib/mysql/
#############################
innodb_buffer_pool_size = 2456M
innodb_additional_mem_pool_size = 24M
innodb_log_file_size = 256M
innodb_log_buffer_size = 2M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb_thread_concurrency = 0
[mysqldump]
quick
max_allowed_packet = 16M
allow-keywords
[mysql]
no-auto-rehash
default-character-set=tis620
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
หัวข้อ: ทดสอบ server start mysql ไม่ได้ครับ (อ่าน 12592 ครั้ง)