ตามหัวข้อเลยครับ Database เน้นการ Query เป็นหลัก
[h=3]Extensions & new features[/h][COLOR=#000000][FONT=Droid Serif]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:[/FONT][/COLOR]
[LIST]
[]Microseconds in MariaDB [COLOR=green][I]— new in 5.3[/I][/COLOR]
[]Microsecond Precision in Processlist
[]Table Elimination
[]Virtual Columns [COLOR=green][I]— new in 5.2[/I][/COLOR]
[]Extended User Statistics [COLOR=green][I]— new in 5.2[/I][/COLOR]
[]Segmented Key Cache [COLOR=green][I]— new in 5.2[/I][/COLOR]
[]Pluggable Authentication [COLOR=green][I]— new in 5.2[/I][/COLOR]
[]Storage-engine-specific CREATE TABLE [COLOR=green][I]— new in 5.2[/I][/COLOR]
[]Enhancements to INFORMATION SCHEMA.PLUGINS table [COLOR=green][I]— new in 5.2[/I][/COLOR]
[][COLOR=#ff0000]Group commit for the binary log[/COLOR][COLOR=#ff0000]. This makes [/COLOR][URL=“http://www.facebook.com/note.php?note_id=10150261692455933”][COLOR=#ff0000]replication notable faster![/COLOR][COLOR=#ff0000] [I]— new in 5.3[/I][/COLOR]
[]Added --rewrite-db mysqlbinlog option to change the used database [COLOR=green][I]— new in 5.2[/I][/COLOR]
[]Progress reporting for [URL=“https://kb.askmonty.org/en/alter-table/”]ALTER TABLE and [URL=“https://kb.askmonty.org/en/load-data-infile/”]LOAD DATA INFILE. [COLOR=green][I]— new in 5.3[/I][/COLOR]
[][COLOR=#ff0000]Faster [/COLOR][COLOR=#ff0000]joins and subqueries[/COLOR][COLOR=#ff0000]. [I]— new in 5.3[/I][/COLOR]
[]HandlerSocket and faster [URL=“https://kb.askmonty.org/en/handler/”]HANDLER calls. [COLOR=green][I]— new in 5.3[/I][/COLOR]
[]Dynamic Columns support. [COLOR=green][I]— new in 5.3[/I][/COLOR]
[]GIS Functionality[COLOR=green] [I]— new in 5.3[/I][/COLOR]
[]Multi-source replication. [COLOR=green][I]— new in 10.0[/I][/COLOR]
[]SHOW EXPLAIN gives you the EXPLAIN plan for a query running in another thread.[COLOR=green] [I]— new in 10.0[/I][/COLOR]
[/LIST]
[URL=“https://mariadb.org/”]