Fulltext results:

10 InnoDBパフォーマンス

27 Hits, Last modified: 13 months ago

p ib_logfile -rw-rw---- 1 mysql mysql 256M 7月 28 16:49 2016 ib_logfile0 -rw-rw---- 1 mysql mysql 256M 7月 28 16:49 2016 ib_logfile1 -rw-rw---- 1 mysql mysql 256M 7月 14 04:25 2016 ib_logfile10 -rw-rw---- 1 mysql m

02 MySQL max_connections

3 Hits, Last modified: 3 years ago

-----------------+ | max_allowed_packet | 16777216 | | max_binlog_cache_size | 18446744073709547520 | | max_binlog_size ... | | max_heap_table_size | 16777216 | | max_insert_delayed_threads | 20 | | max_join_size

52 MySQLQ sysbench 1.0

2 Hits, Last modified: 4 years ago

--time=300 \ --db-ps-mode=disable \ --threads=16 \ run </code> <code> SQL statistics: queri... erations: reads/s: 33768.16 writes/s: 33768.21 fs

01 Galera構築

1 Hits, Last modified: 8 years ago

he first interface) wsrep_sst_receive_address=172.16.21.176 # SST authentication string. This will be... ql> SET GLOBAL wsrep_cluster_address='gcomm://192.168.100.10:4567'; </code> <color red>※2号機から実施</color... /mysql start --wsrep_cluster_address="gcomm://192.168.100.10:4567" </code> ==== 確認 ==== <code> # mys

05 Percona Xtrabackup

1 Hits, Last modified: 6 years ago

rsyncでコピー <code console> # rsync -av -e ssh 192.168.20.248:/var/lib/mysql/ /var/lib/mysql/ </code> ... ql> SET GLOBAL wsrep_cluster_address='gcomm://192.168.20.247:4567'; </code> ===== ③シェル ===== ==== バッ... e> # gzip -d hogehoge.gz real 46m41.813s user 8m6.167s sys 3m49.137s </code> === リストア === <code conso... nc === <code console> # time rsync -av -e ssh 192.168.20.117:/var/lib/mysql/ /var/lib/mysql/ real 387m

16 MySQL auto_increment リセット

1 Hits, Last modified: 7 years ago

====== 16 MySQL auto_increment リセット ====== 先にデータを削除しておく。 DELETE FROM `table_name`; ALTER TABLE