全文検索:
- 05 Percona Xtrabackup
- -v2 <code> # find / -name wsrep_sst_xtrabackup* /usr/bin/wsrep_sst_xtrabackup # ln -s /usr/bin/wsrep_sst_xtrabackup /usr/bin/wsrep_sst_xtrabackup-v2 </code> ==== 2.ncのエラー ==== === ncが入ってない ==... a fatal error with the following stacktrace: at /usr/bin/innobackupex line 4545. main::get_option('da
- 18 CentOS7 MariaDB
- ql/hoge .lower-test Feb 6 17:38:56 hoge sh: #007/usr/sbin/mysqld: Can't change dir to '/home/mysql/' (... RROR] Aborting' </code> ==== 対応 ==== <code> vi /usr/lib/systemd/system/mariadb.service ProtectSystem... d -i 's/^ProtectSystem=full/ProtectSystem=off/g' /usr/lib/systemd/system/mariadb.service sed -i 's/^ProtectHome=true/ProtectHome=false/g' /usr/lib/systemd/system/mariadb.service sed -i 's/^Pri
- 19 MySQL ログローテート
- just if mysqld is really running if test -x /usr/bin/mysqladmin && /usr/bin/mysqladmin ping &>/dev/null then /usr/bin/mysqladmin --defaults-extra-file=/root/.my.cnf
- 01 Galera構築
- wsrep provider library or 'none' wsrep_provider=/usr/lib64/galera/libgalera_smm.so # Provider specifi... ==== <code console> # /etc/init.d/mysql start # /usr/bin/mysqladmin -u root password '[Password]' </co
- 52 MySQLQ sysbench 1.0
- utf8; </code> ==== テーブル用意 ==== <code> sysbench /usr/share/sysbench/oltp_read_write.lua \ --db-driver... prepare </code> ===== 実行 ===== <code> sysbench /usr/share/sysbench/oltp_read_write.lua \ --db-driver
- 13 mysql56 + galera3
- 226 #wsrep_incoming_address="" wsrep_provider="/usr/lib64/galera-3/libgalera_smm.so" #wsrep_provider
- 51 MySQLベンチマーク(mysqlslap)
- n the given order: /etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf The following groups are re