Fulltext results:

05 Percona Xtrabackup

10 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

10 InnoDBパフォーマンス

7 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

01 Galera構築

6 Hits, Last modified: 7 years ago

read_concurrency = 48 ##innodb_buffer_pool_size = 16G ##innodb_log_file_size = 1946M sort_buffer_size = 16M join_buffer_size = 16M query_cache_size = 128M query_cache_limit = 4M [mysqld_safe] log-error=/var/... he first interface) wsrep_sst_receive_address=172.16.21.176 # SST authentication string. This will be

11 Galera同期(複数台構成)

6 Hits, Last modified: 6 years ago

回は例として、下記の構成でnode2のMySQLがダウンしたと想定して説明。 |node1|192.168.0.11|<color blue>OK</color>| |node2|192.168.0.12|<color red>障害</color>| |node3|192.168.0.13|<color blue>OK</color>| ===== 1.稼働中のノードでフルバックアップ =... 2.バックアップをコピー ===== <code> [node2]# rsync -av 192.168.0.11:/backup/xtrabackup/base/ /backup/xtrabackup

02 MySQL max_connections

4 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

3 Hits, Last modified: 4 years ago

--time=300 \ --db-ps-mode=disable \ --threads=16 \ run </code> <code> SQL statistics: queri... files, 1GiB each 1GiB total file size Block size 16KiB Number of IO requests: 0 Read/Write ratio for ... erations: reads/s: 33768.16 writes/s: 33768.21 fs

13 mysql56 + galera3

2 Hits, Last modified: 9 years ago

itional_mem_pool_size=20M innodb_log_buffer_size=16M join_buffer_size = 128M sort_buffer_size = 2M... ql> set global wsrep_cluster_address='gcomm://192.168.10.11'; </code> === 確認 === wsrep_cluster_sizeク

16 MySQL auto_increment リセット

1 Hits, Last modified: 7 years ago

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