Java Development Post interview category B (with answer)

This article to undertake the above: Java Research and development Post interview classification A (with answer): http://www.cnblogs.com/wp5719/p/5870243.html

Answer your own online search, if there is a mistake or error, please advise.

seven. mysql database

The 1.MYSQL storage engine is different.

MyISAM: has a high insert, query speed, but does not support transactions .
InnoDB: Thedefault database for MySQL after version 5.5, the preferred engine for transactional databases, supports acid transactions, and supports row-level locking.
BDB: Another option for transactional databases originating from Berkeley DB, supporting other transactional features such as COMMIT and ROLLBACK .
Memory : All data is placed into the storage engine, which has very high insertion, update and query efficiency. However, it occupies a memory space that is proportional to the amount of data. And its contents are lost when MySQL restarts.
Merge: Combine a certain number of MyISAM tables into a single whole, which is useful for super-large data storage .
Archive: Ideal for storing large amounts of independent data as historical records. Because they are not often read. Archive has an efficient insertion speed, but its support for queries is relatively poor.
Federated: Combine different MySQL servers to logically make up a complete database. Ideal for distributed applications .
cluster/ndb: A highly redundant storage engine that provides services in conjunction with multiple data machines to improve overall performance and security. Suitable for applications with high data volumes, security and performance requirements.
CSV: A storage engine that logically divides data by commas . It creates one for each data table in the database subdirectory. CSV file. This is an ordinary text file, where each row of data occupies a line of text. The CSV storage engine does not support indexing.
blackhole: Black hole engine, any data written will disappear, generally used to record binlog do replication relay.

Talk about MySQL two storage engines: http://www.cnblogs.com/kevingrace/p/5685355.html

2. Single index, federated index, primary key index.

Index: http://baike.baidu.com/link?url=anmtlzbhaaqvpc8hw0rvwa8bvstgpwsbfmbsifljic1wvqaofharepitxi_- Hpmaohv8h7-fto3g1oqtnrxqtvfqn0wtsz0_9odrp5irodo

3.Mysql How to divide the table, and after the table if you want to do a conditional paging query how to do (if not by the table field to query, almost inefficient, no solution).

Reference Answer: http://blog.csdn.net/ahjxhy2010/article/details/50540500

MySQL optimized sub-Library sub-table: http://www.4wei.cn/archives/1001958

4. After the table wants to make an ID multiple tables are self-increasing, efficiency implementation.

MySQL table self-increment ID solution: http://www.ttlsa.com/mysql/mysql-table-to-solve-the-increment-id-scheme/

MySQL Sub-Library sub-table environment Global ID generation scheme: https://my.oschina.net/u/142836/blog/174465

5.MYSQL of the master-slave real-time backup synchronization configuration, as well as the principle (from the library to read the main library binlog), read and write separation.

MySQL implements master/slave hot standby and read/write separation: http://blog.csdn.net/sanjay_f/article/details/48916171

6. Common SQL statements.
7. Indexed data structure, B + tree.

The origins of B + tree, data structure, basic operations, and application of database indexing: http://www.cnblogs.com/yanghuahui/p/3483047.html

B-Tree and B + Tree applications: Data Search and database index: http://blog.csdn.net/hguisu/article/details/7786014

8. The four characteristics of the transaction, as well as their respective characteristics (atomic, isolated), etc., how the project solves these problems.
9. Database lock: Row lock, table lock, optimistic lock, pessimistic lock.
10. Several granularity of database transactions.
11. Relationship-type and non-relational database differences.

Java Development Post interview category B (with answer)