MariaDB 10 final - MariaDB Enterprise Open Source …
w:
?
?
?
e:
?info@
?
?
?
?
What¡¯s
?New
?in
?MariaDB
?10?
?
Author:
?Maria
?Luisa
?Raviol
?
Last
?update:
?06.10.2014
?
?
?
File
?Name:
?MariaDB_10_final.docx
?
?
Page
?1
?
?
w:
?
?
?
e:
?info@
?
?
?
1
? What¡¯s
?New
?in
?MariaDB
?10
?..........................................................................................................
?4
?
1.1
? What
?is
?MariaDB
?10?
?....................................................................................................................................................................
?4
?
1.2
? MariaDB
?10¡¯s
?Inheritance
?..........................................................................................................................................................
?4
?
1.3
? MySQL
?5.6
?Backported
?and
?Reimplemented
?Features
?..................................................................................................
?5
?
1.4
? MariaDB
?10
?Only
?Features
?........................................................................................................................................................
?5
?
1.5
? MariaDB
?10
?Additions
?.................................................................................................................................................................
?5
?
1.6
? References
?........................................................................................................................................................................................
?5
?
2
? MariaDB
?10
?Optimizer
?Features
?...................................................................................................
?6
?
2.1
? The
?Query
?Optimizer
?...................................................................................................................................................................
?6
?
2.1.1
? EXPLAIN
?Statement
?Enhanced
?.............................................................................................................................................
?6
?
2.1.2
? EXPLAIN
?FORMAT=JSON
?.........................................................................................................................................................
?6
?
2.1.3
? ANALYZE
?Statement
?..................................................................................................................................................................
?6
?
2.1.4
? Engine
?independent
?statistics
?................................................................................................................................................
?6
?
2.2
? Subquery
?Optimization
?...............................................................................................................................................................
?7
?
2.3
? Index
?Condition
?Pushdown
?(ICP)
?Optimization
?...............................................................................................................
?7
?
2.4
? Feature
?Comparison
?Table
?........................................................................................................................................................
?8
?
2.5
? References
?........................................................................................................................................................................................
?9
?
3
? Administration
?and
?user
?features
?...............................................................................................
?10
?
3.1
? Progress
?Reporting
?....................................................................................................................................................................
?10
?
3.2
? SHOW
?EXPLAIN
?...........................................................................................................................................................................
?10
?
3.3
? SHOW
?PLUGIN
?SONAME
?..........................................................................................................................................................
?10
?
3.4
? SHUTDOWN
?..................................................................................................................................................................................
?10
?
3.5
? KILL
?QUERY
?ID
?............................................................................................................................................................................
?11
?
3.6
? Per-?©\connection
?memory
?usage
?.............................................................................................................................................
?11
?
3.7
? Roles
?.................................................................................................................................................................................................
?11
?
3.8
? References
?.....................................................................................................................................................................................
?11
?
4
? MariaDB
?10
?Storage
?Engines
? ......................................................................................................
?12
?
4.1
? CONNECT
?Storage
?Engine
?.......................................................................................................................................................
?12
?
4.1.1
? CONNECT
?Engine
?¨C
?Advantages
?........................................................................................................................................
?12
?
4.1.2
? CONNECT
?Table
?Options
?.......................................................................................................................................................
?13
?
4.1.3
? CONNECT
?Engine
?¨C
?Features
?..............................................................................................................................................
?13
?
4.2
? TokuDB
?Storage
?Engine
?...........................................................................................................................................................
?13
?
4.2.1
? Note:
?..............................................................................................................................................................................................
?14
?
4.3
? The
?Spider
?Storage
?Engine
?.....................................................................................................................................................
?14
?
4.3.1
? Current
?Limitations
?................................................................................................................................................................
?14
?
4.4
? The
?Cassandra
?Storage
?Engine
?.............................................................................................................................................
?14
?
4.5
? References
?.....................................................................................................................................................................................
?15
?
5
? MariaDB
?10
?Replication
?Features
?...............................................................................................
?16
?
5.1
? MariaDB
?GTID
?..............................................................................................................................................................................
?16
?
5.2
? Group
?Commit
?..............................................................................................................................................................................
?16
?
5.3
? Multi¡ªSource
?Replication
?.....................................................................................................................................................
?17
?
5.4
? Parallel
?Slave
?................................................................................................................................................................................
?17
?
5.5
? Crash
?Safe
?Slave
?...........................................................................................................................................................................
?18
?
5.6
? References
?.....................................................................................................................................................................................
?18
?
?
?
?
?
File
?Name:
?MariaDB_10_final.docx
?
Page
?2
?
?
w:
?
?
?
e:
?info@
?
?
6
? MariaDB
?Audit
?Plugin
?.................................................................................................................
?18
?
6.1
? Logging
?............................................................................................................................................................................................
?18
?
6.2
? References
?.....................................................................................................................................................................................
?19
?
7
? Further
?readings
?.........................................................................................................................
?19
?
7.1
? MariaDB
?10
?and
?MySQL
?5.6
?...................................................................................................................................................
?19
?
?
?
File
?Name:
?MariaDB_10_final.docx
?
Page
?3
?
?
w:
?
?
?
e:
?info@
?
?
1 What¡¯s
?New
?in
?MariaDB
?10
?
MariaDB
?10
?was
?released
?on
?March
?31st
?2014
?
1.1 What
?is
?MariaDB
?10?
?
MariaDB
?10
?is
?technically
?a
?fork
?of
?MariaDB
?5.5
?with
?a
?set
?of
?extra
?features
?that
?have
?been
?added
?to
?
fulfill
?MariaDB
?users¡¯
?requests.
?
?
?
MariaDB
?10
?is
?backward
?compatible
?with
?MariaDB
?for
?everything
?that¡¯s
?related
?to
?file
?formats,
?
replication
?and
?configuration
?files
?but
?nevertheless
?it
?is
?application
?and
?data
?files
?compatible
?with
?
MySQL
?5.6
?as
?well.
?
?
MariaDB
?10
?is
?100%
?GPL
?and
?thousands
?of
?lines
?of
?code
?come
?from
?community
?contributors.
?
?
1.2 MariaDB
?10¡¯s
?Inheritance
?
MariaDB
?10
?inherits
?all
?the
?features
?already
?included
?in
?MariaDB
?5.5
?but
?to
?better
?understand
?the
?
complete
?inheritance
?here¡¯s
?a
?short
?summary
?of
?the
?main
?features
?of
?each
?version
?of
?MariaDB
?since
?
version
?5.1
?
? MariaDB
?5.1
?(based
?on
?MySQL
?5.1)
?
o Table
?elimination
?
o new
?storage
?engines
?
o cleanup
?
o better
?tests
?
o pool
?of
?threads
?
?
? MariaDB
?5.2
?(based
?on
?MariaDB
?5.1)
?
o Virtual
?columns
?
o extended
?user
?statistics
?
o segmented
?MyISAM
?keycache
?
?
? MariaDB
?5.3
?(based
?on
?MariaDB
?5.2)
?
o Biggest
?changes
?to
?optimizer
?(faster
?subqueries,
?joins,
?etc.)
?
o Microsecond
?precision
?
o faster
?HANDLER
?(HANDLER
?RED
?50%
?faster
?w/530,000
?qps)
?
o dynamic
?columns
?
o Better
?replication
?(group
?commit,
?etc.)
?
o HandlerSocket
?
?
? MariaDB
?5.5
?(based
?on
?MariaDB
?5.3
?+
?MySQL
?5.5)
?
o Opensource,
?more
?efficient
?threadpool
?
o Non-?©\blocking
?client
?library
?
o New
?LIMIT
?ROWS
?EXAMINED
?option
?
o Extended
?keys
?for
?XtraDB/InnoDB
?
o New
?SphinxSE
?
o Dynamic
?replication
?settings
?
File
?Name:
?MariaDB_10_final.docx
?
Page
?4
?
?
w:
?
?
?
e:
?info@
?
?
o Lots
?of
?security
?fixes,
?new
?status
?variables,
?etc.
?
1.3 MySQL
?5.6
?Backported
?and
?Reimplemented
?Features
?
o InnoDB/XtraDB
?(5.6.5)
?
o Optimised
?read
?only
?transaction,
?with
?support
?for
?TRANSACTION
?READ
?ONLY
?
o PERFORMANCE_SCHEMA
?(5.6.5)
?
o Online
?ALTER
?TABLE
?
?
o Privileges
?on
?temporary
?tables
?
o -?©\-?©\plugin-?©\load-?©\add
?
o GET
?DIAGNOSTIC
?statement
?
o Character
?set
?extensions
?
o Temporal
?literals
?
o Filesort
?optimisation
?for
?ORDER
?BY...LIMIT
?(shows
?only
?few
?rows
?of
?a
?resultset)
?
o Reimplemented:
?
o Errormessages(w/system
?error
?string)
?
?
o CURRENT_TIMESTAMP
?as
?DEFAULT
?for
?DATETIMEcolumns
?
?
o GlobalTransactionID
?
o Parallel
?replication
?
o EXISTS-?©\TO-?©\IN
?optimisation
?
1.4 MariaDB
?10
?Only
?Features
?
On
?top
?of
?all
?the
?features
?already
?listed,
?MariaDB
?10
?has
?a
?set
?of
?features
?that
?are
?unique:
?
o SHOW
?EXPLAIN
?for
?
?
o Faster
?ALTER
?TABLE
?with
?unique
?keys
?for
?Aria
?&
?MyISAM
?
o Per-?©\thread
?memory
?usage
?
o INFORMATION_SCHEMA.PROCESSLIST
?with
?MEMORY_USAGE
?&
?EXAMINED_ROWS
?now
?
?
o SHOW
?STATUS
?with
?memory
?usage
?
?
1.5 MariaDB
?10
?Additions
?
Some
?specific
?additions
?are
?part
?of
?the
?new
?MariaDB
?10
?offering
?and
?these
?are
?mainly:
?
o MariaDB
?Galera
?Cluster
?
o Connectors
?and
?Drivers
?
o MariaDB
?C
?Client
?Library
?
o MariaDB
?JDBC
?Driver
?
o MariaDB
?Audit
?Plugin
?
1.6 References
?
?
?©\vs-?©\mysql-?©\features/
?
?
?©\options.html#option_mysqld_plugin-?©\load-?©\add
?
?
File
?Name:
?MariaDB_10_final.docx
?
?
Page
?5
?
?
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- open source crm
- open source content management system
- open source ticketing system
- free open source crm
- open source help desk software
- c open source code
- open source task management
- open source project management software
- open source project management software 2019
- open source project management online
- open source project planning software
- open source project management tool