ลง Percona-Server-51-5.1.55-rel12.6.200.rhel5.x86_64 บน CentOS 5.5 ไม่ผ่านครับ

ลองปรับ my.cnf ในจุดที่มีระบบฟ้องแล้วก้ยังเป็นเหมือนเดิม

รบกวนขอคำแนะนำด้วยครับ ขอบคุณทุกท่านที่เสียสละเวลาเข้ามาตอบครับ

Preparing...                ########################################### [100%]
   1:Percona-Server-client-5########################################### [100%]
Preparing...                ########################################### [100%]
   1:Percona-Server-shared-5########################################### [100%]
Preparing...                ########################################### [100%]
   1:Percona-Server-server-5########################################### [100%]
110322 18:20:06 [Note] Flashcache bypass: disabled
110322 18:20:06 [Note] Flashcache setup error is : ioctl failed

110322 18:20:06 [ERROR] You need to use --log-bin to make --binlog-format work.
110322 18:20:06 [ERROR] Aborting

110322 18:20:06 [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!

Starting MySQL (Percona Server).Manager of pid-file quit without updating file.[FAILED]
Giving mysqld 2 seconds to start
Percona Server is distributed with several useful UDF (User Defined Function) from Maatkit
Run following command 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
MySQL manager or server PID file could not be found!       [FAILED]
Starting MySQL (Percona Server).Manager of pid-file quit wi[FAILED]dating file.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

อยากทราบว่าทำไมเวลานำไฟล์ backup นำมา restore ใส่ server slave แล้วจะ replicate ปรากฏว่า เลขในช่อง MaxReplicateID น้อยกว่า ช่อง LastReplicateID ทำให้ไม่สามารถ replicate ข้อมูลไปยัง slave ได้ รบกวนผู้รู้ช่วยชี้แนะด้วยครับ ขอบคุณครับ

ไม่แน่ใจว่าเป็นเพราะอะไร เปลี่ยน version mysql แล้วก้ไม่หายครับ รบกวนด้วยครับ

รบกวนช่วยดูไฟล์ config ของ my.cnf ให้ด้วยครับว่า มีอะไรผิดพลาดหรือปล่าว ขอบคุณครับ

CentOS 5.4 64 bit Ram 8 G


MySQL percona-5.1.42-9.rhel5 64 bit

ไฟล์ config ของ my.cnf ที่ใช้อยู่ครับ

[client]
port      = 3306
socket      = /var/lib/mysql/mysql.sock
default-character-set=tis620

[mysqld]
port      = 3306
socket      = /var/lib/mysql/mysql.sock
#key_buffer = 40-50 % of RAM
key_buffer = 2400M
max_allowed_packet = 1024M
max_heap_table_size = 2048M
max_connections=2000
table_cache = 1500
table_open_cache = 1500
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 1M
#myisam_sort_buffer_size = 10-20 % of RAM
myisam_sort_buffer_size = 1024M
myisam_max_sort_file_size = 2048M
myisam_max_extra_sort_file_size = 2048M
myisam_repair_threads = 1
myisam_recover
thread_cache_size = 8
query_cache_type=1
#query_cache_size= 10 % of RAM
query_cache_size= 720M
thread_concurrency = 8
default-character-set=tis620
skip-name-resolve
skip-character-set-client-handshake
skip-locking
init_connect = 'SET NAMES tis620'
big-tables
default-storage-engine = INNODB
join_buffer_size = 4M
concurrent_insert = 2
join_buffer_size = 2M
concurrent_insert = 2

log_bin_trust_function_creators = 1     

innodb_file_per_table
innodb_data_home_dir = /var/lib/mysql/
innodb_log_group_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 = 40-60 % of RAM
innodb_buffer_pool_size = 4200M
innodb_additional_mem_pool_size = 24M
innodb_log_file_size = 512M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 50
innodb_thread_concurrency = 0
#ulimit -n 30000


innodb_support_xa=0
innodb_open_files = 2000
innodb_locks_unsafe_for_binlog=1
innodb_flush_method=O_DIRECT
innodb_doublewrite=0




innodb_adaptive_checkpoint = 1
innodb_io_capacity = 10000
innodb_write_io_threads = 16
innodb_read_io_threads = 16



[mysqldump]
quick
max_allowed_packet = 1024M
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