首页 > 代码库 > mysql innodb
mysql innodb
InnoDB tablespace and logs
配置默认每个表拥有自己的表空间;
innodb_file_per_table=1
对于以前的表示不受影响的, 只对新表有效;
tablespace 可以自动增长,大小受到文件系统的限制,还可以放到裸设备里面, 大小不再不受文件系统限制
"裸设备的extent"
1;配置表空间;
innodb_data_file_path ibdata1:10M:autoextend
如要要配置绝对路径,需要把Innodb_data_home_dir 置空
Innodb_data_home_dir =
innodb_data_file_path = /tmp/ibdata1:10M:autoextend[:max20M]; /tmp/ibdata1:10M:autoextend[:max20M]
注意:
ACID:
T
首先看看默认是否打开:
mysql> show variables like ‘autocommit‘;+---------------+-------+| Variable_name | Value |+---------------+-------+| autocommit | ON |+---------------+-------+1 row in set (0.00 sec)
测试1:
第一个窗口
set autocommit = 0 ;insert into t1 values (1,2);commit;
mysql> start transaction;Query OK, 0 rows affected (0.00 sec)mysql> insert into t1 values(111,111);Query OK, 1 row affected (0.00 sec)mysql> rollback;Query OK, 0 rows affected (0.04 sec)
InnoDB buffers
innodb_buffer_pool_size =134217728
innodb_additional_mem_pool_size=8388608
innodb_max_dirty_pages_pct =75
mysql> show variables like ‘%innodb_buffer%‘;+-------------------------------------+----------------+| Variable_name | Value |+-------------------------------------+----------------+| innodb_buffer_pool_dump_at_shutdown | OFF || innodb_buffer_pool_dump_now | OFF || innodb_buffer_pool_filename | ib_buffer_pool || innodb_buffer_pool_instances | 8 || innodb_buffer_pool_load_abort | OFF || innodb_buffer_pool_load_at_startup | OFF || innodb_buffer_pool_load_now | OFF || innodb_buffer_pool_size | 134217728 |+-------------------------------------+----------------+8 rows in set (0.00 sec)
mysql> show variables like ‘%have%‘;+----------------------+----------+| Variable_name | Value |+----------------------+----------+| have_compress | YES || have_crypt | NO || have_csv | YES || have_dynamic_loading | YES || have_geometry | YES || have_innodb | YES || have_ndbcluster | NO || have_openssl | DISABLED || have_partitioning | YES || have_profiling | YES || have_query_cache | YES || have_rtree_keys | YES || have_ssl | DISABLED || have_symlink | YES |+----------------------+----------+14 rows in set (0.43 sec)
mysql innodb
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。