全文検索:
- 10 InnoDBパフォーマンス
- -- 1 mysql mysql 256M 7月 16 13:22 2016 ib_logfile12 -rw-rw---- 1 mysql mysql 256M 7月 17 18:16 2016 i... ib_logfile3 -rw-rw---- 1 mysql mysql 256M 7月 7 12:15 2016 ib_logfile4 -rw-rw---- 1 mysql mysql 256M... 016 ib_logfile7 -rw-rw---- 1 mysql mysql 256M 7月 12 00:09 2016 ib_logfile8 -rw-rw---- 1 mysql mysql 2
- 20 CentOS7 MariDB Galera
- yum install MariaDB-server MariaDB-server 10.4.12-1.el7.centos MariaDB-client 10.4.12-1.el7.centos MariaDB-common 10.4.12-1.el7.centos galera-4 26.4.3-1.rhel7.el7.centos </code> ===== 初期
- 50 MySQLベンチマーク(sysbench)
- ば良いと思う。 transactions: 11273 (187.88 per sec.) ※187.88/sec トランザクションを実行できた。 ... nning mixed OLTP test Using Special distribution (12 iterations, 1 pct of values are returned in 75 p... 236733 transactions: 11273 (187.88 per sec.) deadlocks: ... 0.0013s total number of events: 11273 total time taken by event execution: 59.887
- 01 Galera構築
- ra構築 ====== [[http://www.sebastien-han.fr/blog/2012/04/01/mysql-multi-master-replication-with-galera/... e = 16M join_buffer_size = 16M query_cache_size = 128M query_cache_limit = 4M [mysqld_safe] log-error... ddress # In some systems bind-address defaults to 127.0.0.1, and with mysqldump SST # it will have (mo
- 11 Galera同期(複数台構成)
- 168.0.11|<color blue>OK</color>| |node2|192.168.0.12|<color red>障害</color>| |node3|192.168.0.13|<color
- 12 Galera Permission Error
- ====== 12 Galera Permission Error ====== Galeraを1台で普通に起動しようとしてるだけなのに、下記のエラーが出て起動できない。 なんと原因はSELinuxでし
- 52 MySQLQ sysbench 1.0
- d: read: 13620712 write: 3811897 ... 012s total number of events: 20261233 Latency (ms): min: ... fairness: events (avg/stddev): 20261233.0000/0.00 execution time (avg/stddev): 27