แสดงกระทู้
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
32 bit V8.28 กดปุ่ม start แล้ว Error แบบนี้ แก้ไขอย่างไรครับเจอปัญหานี้เหมือนกันครับ
ฝากทดสอบตัวใหม่นะครับ ผมเปลี่ยนมาใช้ nc แทน sftp แล้วครับ น่าจะแก้ปัญหาขนาดแฟ้มเกิน 4Gb ได้ครับขอบคุณครับ
คาดว่าจะเป็นเดือนหน้าครับ ตอนนี้ก้พยายามใช้ทรัพยากรที่มีให้คุ้มค่าไปก่อนลองถอย os มาเป้น centos4.7-server cd ดูครับ .................มันเกี่ยวกันไหมนี้
ผมว่า รพ.เขาน่าจะซื้อแรมเพิ่ม บอกมาเป็นปีแล้ว
ผอ.ก็เปลี่ยนคนใหม่แล้ว
เห็นว่าลงทุนเรื่อง IT และกำลังจะซื้อ Server HP ใหม่ CPU sixCORE x2 แรม 32-64 G
พอดีนั่งดื่่มเบียร์กันหลังประชุม สสจ.
ช่วยบอกด้วยครับว่า ram server เท่าไร
ต้องไล่ดูตั้งแต่ os linux +mysql+my.cnf
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
default-character-set=tis620
[mysqld]
default_storage_engine=INNODB
default_table_type = INNODB
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-external-locking
key_buffer = 512M
max_allowed_packet = 1024M
table_cache = 2048
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 1M
join_buffer_size = 2M
bulk_insert_buffer_size = 40M
max_heap_table_size = 512M
myisam_sort_buffer_size = 512M
myisam_max_sort_file_size = 512M
myisam_repair_threads = 1
myisam_recover
thread_cache_size = 1600
query_cache_size= 1024M
thread_cache_size = 8
thread_concurrency = 8
character-set-server=tis620
max_connections = 400
skip-name-resolve
skip-character-set-client-handshake
init_connect = 'SET NAMES tis620'
transaction_isolation = REPEATABLE-READ
tmp_table_size = 512M
log-bin=mysql-bin
binlog_format=mixed
innodb_file_per_table
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_files_in_group = 3
innodb_log_group_home_dir = /var/lib/mysql/
innodb_max_dirty_pages_pct = 90
innodb_buffer_pool_size = 8G
innodb_additional_mem_pool_size = 24M
innodb_log_file_size = 512M
innodb_log_buffer_size = 8M
innodb_file_io_threads = 4
innodb_thread_concurrency = 16
innodb_flush_log_at_trx_commit = 1
innodb_fast_shutdown = 0
innodb_flush_method=O_DIRECT
innodb_doublewrite = 0
innodb_file_io_threads = 4
innodb_lock_wait_timeout = 10
innodb_thread_concurrency = 0
innodb_support_xa = 0
innodb_locks_unsafe_for_binlog = 1
innodb_open_files = 4000
concurrent_insert = 2
[mysqldump]
quick
max_allowed_packet = 4096M
allow-keywords
[mysql]
no-auto-rehash
default-character-set=tis620
[isamchk]
key_buffer = 512M
sort_buffer_size = 512M
read_buffer = 8M
write_buffer = 8M
[myisamchk]
key_buffer = 512M
sort_buffer_size = 512M
read_buffer = 8M
write_buffer = 8M
[mysqlhotcopy]
interactive-timeout
[mysqld_safe]
open-files-limit = 8192
ได้หรือยังครับ พี่
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)
-hardware หรือเปล่าครับ server รันมากี่ปีแล้วครับ
auto backup hosxp เก็บไว้ที่เครื่่องลูกหลายจุดหรือเปล่าครับ
ผมใช้คำำสั่ง innobackupex-1.5.1 /mysqlbackup มี error ครับ
to /mysqlbackup/2010-07-29_13-41-20/hos/fp_women.ibd
xtrabackup: Error: xtrabackup_copy_datafile() failed.
xtrabackup: Warining: failed to copy, but continuing.
Copying ./hos/anc_ill_history.ibd
to /mysqlbackup/2010-07-29_13-41-20/hos/anc_ill_history.ibd
xtrabackup: Error: xtrabackup_copy_datafile() failed.
xtrabackup: Warining: failed to copy, but continuing.
Copying ./hos/icd10tm_operation.ibd
to /mysqlbackup/2010-07-29_13-41-20/hos/icd10tm_operation.ibd
xtrabackup: Error: xtrabackup_copy_datafile() failed.
xtrabackup: Warining: failed to copy, but continuing.
Copying ./hos/community_house.ibd
to /mysqlbackup/2010-07-29_13-41-20/hos/community_house.ibd
xtrabackup: Error: xtrabackup_copy_datafile() failed.
xtrabackup: Warining: failed to copy, but continuing.
Copying ./hos/dtapp.ibd
to /mysqlbackup/2010-07-29_13-41-20/hos/dtapp.ibd
xtrabackup: Error: xtrabackup_copy_datafile() failed.
xtrabackup: Warining: failed to copy, but continuing.
Copying ./hos/adr_continue_rechallenge.ibd
to /mysqlbackup/2010-07-29_13-41-20/hos/adr_continue_rechallenge.ibd
xtrabackup: Error: xtrabackup_copy_datafile() failed.
xtrabackup: Warining: failed to copy, but continuing.
Copying ./hos/operation_time_type.ibd
to /mysqlbackup/2010-07-29_13-41-20/hos/operation_time_type.ibd
xtrabackup: Error: xtrabackup_copy_datafile() failed.
xtrabackup: Warining: failed to copy, but continuing.
100729 13:41:59 InnoDB: Operating system error number 9 in a file operation.
InnoDB: Error number 9 means 'Bad file descriptor'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.html
InnoDB: File operation call: 'close'.
InnoDB: Cannot continue operation.
innobackupex-1.5.1: Error: ibbackup child process has died at /usr/bin/innobackupex-1.5.1 line 478.