MySQL architecture and Storage engine architecture

MySQL Architecture

650) this.width=650; "title=" Tixi.png "src=" http://s3.51cto.com/wyfs02/M01/6E/5E/ Wkiom1v6r2fqicxuaak2-qjgvto877.jpg "alt=" Wkiom1v6r2fqicxuaak2-qjgvto877.jpg "/>

MySQL Storage engine architecture

650) this.width=650; "title=" Yingqing.png "src=" Http://s3.51cto.com/wyfs02/M01/6E/5E/wKiom1V6R47jlvc1AAI0o_ Qnnp0940.jpg "alt=" Wkiom1v6r47jlvc1aai0o_qnnp0940.jpg "/>

The tuning experience brought by the architecture:

Per-threads-bufferr bits per connection session memory, not too large

Query cache

Recommended to close, otherwise waiting for query cache lock in frequently updated systems

Read_buffer_size

Sequential scan for tables

Read_rnd_bufer_size

This parameter is used for random reading of the table

Sort_buffer_size

Used for sorting

Thread_stack

stack size for each thread

Join_buffer_size

Join Operation for Table

Key_buffer_size

This parameter is used to cache the index of the MyISAM storage engine, mysql5.5 default to InnoDB storage engine, smaller, 64M
MyISAM Index and data file separate, InnoDB put together

Innodb_add_mem_pool_size

used to store data dictionaries and other internal structures, typically set to 16M can be

Binlog_cache_size

in general, if there is no large transaction in the database, the write is not very frequent, set it to 1~2m

If there is a large transaction, increase the buffer value appropriately

This article is from the DBA Sky blog, so be sure to keep this source http://9425473.blog.51cto.com/9415473/1661145

MySQL architecture and Storage engine architecture