Fulltext results:
- 51 MySQLベンチマーク(mysqlslap)
- f Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. R... generated tables. --auto-generate-sql-load-type=name Specify test load type: mi... on in server/client protocol. -c, --concurrency=name Number of clients to simulate for query to run. --create=name File or string to use create tables. --cr
- 01 Galera構築
- tions #wsrep_provider_options= # Logical cluster name. Should be the same for all nodes. wsrep_cluster_name="onapp_db_cluster" # Group communication system ... er_address="gcomm://:4567" # Human-readable node name (non-unique). Hostname by default. #wsrep_node_name= # Base replication <address|hostname>[:port] of t
- 14 MariaDB
- '; +------------------------+--------+ | Variable_name | Value | +------------------------+---... le'; +-----------------------+-------+ | Variable_name | Value | +-----------------------+------... --------------------------+----------+ | Variable_name | Value | +-----------------------... -------------------------+-----------+ | Variable_name | Value | +------------------------
- 15 InnoDB テーブルロック
- ct * from lock_test; +----+--------+-----+ | id | name | age | +----+--------+-----+ | 1 | tanaka | ... k_test ( id int primary key auto_increment, name varchar(32) not null, age int not null ) engin... DB default charset=utf8; insert into lock_test (name, age) values ('tanaka', 20), ('suzuki', 30), (... sec) mysql> UPDATE lock_test SET age = 21 WHERE name = 'tanaka'; Query OK, 1 row affected (0.00 sec) R
- 50 MySQLベンチマーク(sysbench)
- {simple,complex,nontrx,sp} [complex] --oltp-sp-name=STRING name of store procedure to call in SP test mode [] --oltp-read-only=[on|off] g... ds to sleep after each request [0] --oltp-table-name=STRING name of test table [sbtest] --oltp-table-size=N number of records in test t
- 04 MyISAMからInnoDBへ変換
- からInnoDBへ変換 ====== <code> alter table hoge_table_name engine = InnoDB; </code> これで一括変換できる。 <code> dbname="test_db" for i in `mysql $dbname -e 'show tables'| grep -v Tables_in_` do echo $i mysql $dbname -e "alter table $i engine = InnoDB" done </code>
- 13 mysql56 + galera3
- LERA__' > /etc/yum.repos.d/galera.repo [galera] name = Galera baseurl = http://releases.galeracluster... = 2M # Galera # Cluster setting wsrep_cluster_name="Galera_CLUSTER" wsrep_cluster_address="gcomm://" ## インストールノードごとに名称を変えること ## wsrep_node_name="$( hostname -s )" wsrep_node_address="" wsrep_sst_receive_address="" wsrep_sst_method="xtrabackup-v
- 02 MySQL max_connections
- --------------+----------------------+ | Variable_name | Value | +----------... ax%'; +----------------------+-------+ | Variable_name | Value | +----------------------+-------+... ected%'; +-------------------+-------+ | Variable_name | Value | +-------------------+-------+ | Thr
- 16 MySQL auto_increment リセット
- t リセット ====== 先にデータを削除しておく。 DELETE FROM `table_name`; ALTER TABLE `table_name` SET auto_increment = 1; TRUNCATEでも同じ感じになる。 TRUNCATE TABLE `table_name`; {{tag>mysql}}
- 07 INNODB/MyISAM 確認方法
- のテーブルがMyISAMなのか確認できる。 <code> mysql> SELECT table_name, engine, table_schema FROM information_schema.tab... ----------+--------+--------------------+ | table_name | engine | ta
- 17 MySQL テーブル断片化
- 片化 ====== 確認 mysql> select table_schema, table_name, data_free, table_rows from information_schema.tables; 解消 mysql> ALTER TABLE `table_name` ENGINE INNODB; ※テーブル大きいと結構時間かかる {{tag>mysql}}
- 03 InnoDBテーブル分割
- /code> ===== リストア ===== <code console> # mysql < all_backup.sql </code> これで、tablename.idb ができるようになります。
- 05 Percona Xtrabackup
- wsrep_sst_method=xtrabackup-v2 <code> # find / -name wsrep_sst_xtrabackup* /usr/bin/wsrep_sst_xtraback
