MariaDB 와 MySQL - 기능

More Storage Engines 더 많은 저장 엔진

In addition to the standard MyISAM, Blackhole, CSV, Memory, and Archive storage engines, the following are also included with MariaDB Source and Binary packages:

표준 MyISAM, Blackhole, CSV, Memory, 그리고 Archive과 더불어, MariaDB 소스와 바이너리 패키지에는, 다음 저장 엔진들이 포함되어 있다 :

• Aria
• XtraDB (drop-in replacement for InnoDB)(InnoDB 의 대체)
• PBXT (In MariaDB 5.1, 5.2 and 5.3. Disabled in 5.5)
• FederatedX (drop-in replacement for Federated) (Federated 의 대체)
• OQGRAPH — new in 5.2
• SphinxSE — new in 5.2
• IBMDB2I. Oracle removed this in MySQL 5.1.55 but we have kept the code in MariaDB until the version 5.5.
• IBMDB2I. Oracle 은 MySQL 5.1.55 에서 이 코드를삭제했지만, MariaDB 는 5.5 버전까지 보존하고 있다
• Cassandra in MariaDB-10.0
  • We are working on adding other no-sql storage engines into MariaDB.
  • 우리는 MariaDB 내에 no-sql 저장 엔진을 추가하고 있는 중이다.

Speed improvements 성능 개선

• A lot of optimizer enhancements in MariaDB 5.3. Sub queries are now finally usable! The complete list and a comparison with MySQL is here. You can find a benchmark here.
• 많은 최적화 개선 MariaDB 5.3. 서브 질의가 사용 가능! 전체 목록과 MySQL 는 여기. 벤치마크를 찾으려면 여기.

• Faster and safer replication: Group commit for the binary log. This makes many setups that uses replication and lot's of updates more than 2x times faster.
• 더 빠르고 안전한 복제: 바이너리 로그에 대한 Group 커밋. This makes many setups that uses replication and lot's of updates 2배 이상 빠르게.

• Improvements for Innodb asynchronous IO subsystem on Windows.
• 개선 for Innodb 비동기 IO subsystem on Windows.

• Index for MEMORY(HEAP) engine is faster. According to a simple test, 24 % faster on INSERT for integer index and 60 % faster for index on a CHAR(20) column.
• MEMORY(HEAP) 엔진 인덱싱이 더 빨라짐. 테스트에 따르면, INSERT 문의 성능은 integer 인덱스에 대해서 24 %, CHAR(20) 컬럼 인덱스에 대해서 60% 향상.

• CHECKSUM TABLE is faster.
• CHECKSUM TABLE 더 빨라짐.

• We improved the performance of character set conversions (and removed conversions when they were not really needed). Overall speed improvements is 1-5 % (according to sql-bench) but can be higher for big results sets with all characters between 0x00-0x7f.
• Pool of Threads in MariaDB 5.1 and even better in MariaDB 5.5. This allows you to run MariaDB with 200,000+ connections and with a notable speed improvement when using many connections.
• There are some improvements to DBUG code to make its execution faster when debug is compiled in but not used.
• Our use of the Aria storage engine enables faster complex queries (queries which normally use disk-based temporary tables). The Aria storage engine is used for internal temporary tables, which should give you a speedup when doing complex selects. Aria is usually faster for temporary tables when compared to MyISAM because Aria caches row data in memory and normally doesn't have to write the temporary rows to disk.
• The test suite is extend and now runs much faster than before even though it tests more things.

Extensions & new features

We've added a lot of new features to MariaDB. If a patch or feature is useful, safe, and stable — we make every effort to include it in MariaDB. The most notable features are:

• Microseconds in MariaDB — new in 5.3
• Microsecond Precision in Processlist
• Table Elimination
• Virtual Columns — new in 5.2
• Extended User Statistics — new in 5.2
• Segmented Key Cache — new in 5.2
• Pluggable Authentication — new in 5.2
• Storage-engine-specific CREATE TABLE — new in 5.2
• Enhancements to INFORMATION SCHEMA.PLUGINS table — new in 5.2
• Group commit for the binary log. This makes replication notable faster! — new in 5.3
• Added --rewrite-db mysqlbinlog option to change the used database — new in 5.2
• Progress reporting for ALTER TABLE and LOAD DATA INFILE. — new in 5.3
• Faster joins and subqueries. — new in 5.3
• HandlerSocket and faster HANDLER calls. — new in 5.3
• Dynamic Columns support. — new in 5.3
• GIS Functionality — new in 5.3
• Multi-source replication. — new in 10.0
• SHOW EXPLAIN gives you the EXPLAIN plan for a query running in another thread. — new in 10.0

For a full list, please see features for each release

Better Testing

• More tests in the test suite.
• Bugs in tests fixed.
• Test builds with different configure options to get better feature testing.
• Remove invalid tests. (e.g. Don't test feature ''X'' if that feature is not in the build you are testing.)

Fewer warnings and bugs

• Bugs are bad. Fix as many bugs as possible and try to not introduce new ones.
• Compiler warnings are also bad. Eliminate as many compiler warnings as possible.

Truly Open Source

• All code in MariaDB is released under GPL, LPGL or BSD. MariaDB does not have closed source modules like the one you can find in MySQL enterprise edition. In fact, all the closed source features in MySQL 5.5 enterprise edition are found in the MariaDB open source version.
• MariaDB includes test cases for all fixed bugs. Oracle doesn't provide test cases for new bugs fixed in MySQL 5.5.
• All bugs and development plans are public.
• MariaDB is developed by the community in true open source spirit.

Related links

See also Compatiblity between MariaDB and MySQL