ユーザ用ツール

サイト用ツール


01_linux:11_データベース:01_mysql:14_mariadb

差分

この文書の現在のバージョンと選択したバージョンの差分を表示します。

この比較画面にリンクする

01_linux:11_データベース:01_mysql:14_mariadb [2017/07/28 13:12] (現在)
matsui 作成
ライン 1: ライン 1:
 +====== 14 MariaDB ======
  
 +-MariaDB-server-10.2.7-1
 +
 +<​code>​
 +MariaDB [(none)]>​ show global variables like '​default_storage_engine';​
 ++------------------------+--------+
 +| Variable_name ​         | Value  |
 ++------------------------+--------+
 +| default_storage_engine | InnoDB |
 ++------------------------+--------+
 +1 row in set (0.00 sec)
 +
 +MariaDB [(none)]>​ show global variables like '​innodb_file_per_table';​
 ++-----------------------+-------+
 +| Variable_name ​        | Value |
 ++-----------------------+-------+
 +| innodb_file_per_table | ON    |
 ++-----------------------+-------+
 +1 row in set (0.00 sec)
 +
 +MariaDB [(none)]>​ show global variables like '​innodb_log_file_%';​
 ++---------------------------+----------+
 +| Variable_name ​            | Value    |
 ++---------------------------+----------+
 +| innodb_log_file_size ​     | 50331648 |
 +| innodb_log_files_in_group | 2        |
 ++---------------------------+----------+
 +2 rows in set (0.00 sec)
 +
 +MariaDB [(none)]>​ show global variables like '​innodb_buffer_pool_size%';​
 ++-------------------------+-----------+
 +| Variable_name ​          | Value     |
 ++-------------------------+-----------+
 +| innodb_buffer_pool_size | 134217728 |
 ++-------------------------+-----------+
 +1 row in set (0.00 sec)
 +
 +MariaDB [(none)]>​ show global variables like '​innodb_flush_log_at_trx_commit%';​
 ++--------------------------------+-------+
 +| Variable_name ​                 | Value |
 ++--------------------------------+-------+
 +| innodb_flush_log_at_trx_commit | 1     |
 ++--------------------------------+-------+
 +1 row in set (0.00 sec)
 +
 +MariaDB [(none)]>​ show global variables like '​innodb_autoinc_lock_mode%';​
 ++--------------------------+-------+
 +| Variable_name ​           | Value |
 ++--------------------------+-------+
 +| innodb_autoinc_lock_mode | 1     |
 ++--------------------------+-------+
 +1 row in set (0.00 sec)
 +
 +MariaDB [(none)]>​ show global variables like '​binlog_format%';​
 ++---------------+-------+
 +| Variable_name | Value |
 ++---------------+-------+
 +| binlog_format | MIXED |
 ++---------------+-------+
 +1 row in set (0.00 sec)
 +
 +MariaDB [(none)]>​ show global variables like '​innodb_locks_unsafe_for_binlog%';​
 ++--------------------------------+-------+
 +| Variable_name ​                 | Value |
 ++--------------------------------+-------+
 +| innodb_locks_unsafe_for_binlog | OFF   |
 ++--------------------------------+-------+
 +1 row in set (0.00 sec)
 +</​code>​
 +
 +
 +/etc/my.cnf
 +
 +default_storage_engine=InnoDB
 +innodb_file_per_table=1
 +binlog_format=ROW
 +innodb_autoinc_lock_mode=2
 +innodb_locks_unsafe_for_binlog=1
 +innodb_flush_log_at_trx_commit=0
 +innodb_buffer_pool_size=512M
 +innodb_log_file_size=64M
 +innodb_log_files_in_group=10
 +
 +
 +{{tag>​mysql}}
01_linux/11_データベース/01_mysql/14_mariadb.txt · 最終更新: 2017/07/28 13:12 by matsui

Yesterday:1646 Today:1386 Total:11887