8000 Merge pull request #1 from morgo/master · webdevgit/morgo.github.io@003b91f · GitHub
[go: up one dir, main page]

Skip to content

Commit 003b91f

Browse files
committed
Merge pull request morgo#1 from morgo/master
fetch latest
2 parents b47d9ba + 6b611a8 commit 003b91f

File tree

1 file changed

+7
-5
lines changed

1 file changed

+7
-5
lines changed

index.html

Lines changed: 7 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -33,7 +33,7 @@ <h3>Replication</h3>
3333
<li class="rt">Multi-threaded slave ordered commits (Sequential Consistency) [<a href="http://dev.mysql.com/worklog/task/?id=6813">1</a>]</li>
3434
<li class="rt">Support <tt>SLAVE_TRANSACTION_RETRIES</tt> in multi-threaded slave mode [<a href="http://dev.mysql.com/worklog/task/?id=6964">1</a>]</li>
3535
<li class="nd">A <tt>WAIT_FOR_EXECUTED_GTID_SET</tt> function has been introduced [<a href="http://dev.mysql.com/worklog/task/?id=7796">1</a> <a href="https://dev.mysql.com/doc/refman/5.7/en/gtid-functions.html#function_wait-for-executed-gtid-set">2</a>]</li>
36-
<li class="rt">Optimize GTIDs for Passive Slaves [<a href="https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html#sysvar_executed_gtids_compression_period">1</a> <a href="http://dev.mysql.com/worklog/task/?id=6559">2</a>]</li>
36+
<li class="rt">Optimize GTIDs for Passive Slaves [<a href="https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html#sysvar_gtid_executed_compression_period">1</a> <a href="http://dev.mysql.com/worklog/task/?id=6559">2</a>]</li>
3737
<li class="rt">GTID Replication no longer requires <tt>log-slave-updates</tt> be enabled</li>
3838
<li class="rt">XA Support when the binary log is turned on [<a href="https://dev.mysql.com/doc/refman/5.7/en/xa-restrictions.html">1</a>]</li>
3939
<li class="rt">GTIDs in the OK packet [<a href="http://dev.mysql.com/worklog/task/?id=6128">1</a>]</li>
@@ -61,7 +61,7 @@ <h3>InnoDB</h3>
6161
<li class="id">Improved read-write transaction scalability [<a href="http://dev.mysql.com/worklog/task/?id=6578">1</a> <a href="http://dev.mysql.com/worklog/task/?id=6363">2</a> <a href="http://dev.mysql.com/worklog/task/?id=6326">3</a> <a href="http://mysqlserverteam.com/mysql-5-7-improves-dml-oriented-workloads/">4</a>]</li>
6262
<li class="rt">Several optimizations for high performance temporary tables [<a href="https://dev.mysql.com/doc/refman/5.7/en/innodb-temporary-table-undo-logs.html">1</a> <a href="http://mysqlserverteam.com/mysql-5-7-innodb-intrinsic-tables/">2</a> <a href="http://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_temp_data_file_path">3</a> <a href="https://blogs.oracle.com/mysqlinnodb/entry/https_blogs_oracle_com_mysqlinnodb">4</a> <a href="https://www.flamingspork.com/blog/2013/04/26/a-few-notes-on-innodb-in-mysql-5-7-1/">5</a>]</li>
6363
<li class="id"><tt>ALTER TABLE RENAME INDEX</tt> only requires meta-data change [<a href="http://dev.mysql.com/worklog/task/?id=6555">1</a>]</li>
64-
<li class="rt">Inplace <tt>VARCHAR</tt> only requires meta-data change [<a href="http://dev.mysql.com/worklog/task/?id=6554">1</a>]</li>
64+
<li class="rt">Increasing <tt>VARCHAR</tt> size only requires meta-data change [<a href="http://dev.mysql.com/worklog/task/?id=6554">1</a>]</li>
6565
<li class="rt"><tt>ALTER TABLE</tt> performance improved [<a href="http://dev.mysql.com/worklog/task/?id=7277">1</a>]</li>
6666
<li class="zf">Multiple page_cleaner threads [<a href="http://dev.mysql.com/worklog/task/?id=6642">1</a>]</li>
6767
<li class="zf">Optimized buffer pool flushing [<a href="http://dev.mysql.com/worklog/task/?id=7047">1</a>]</li>
@@ -135,7 +135,8 @@ <h3>Optimizer</h3>
135135
NO_AUTO_CREATE_USER,
136136
NO_ENGINE_SUBSTITUTION</tt>
137137
</li>
138-
<lt class="rt">Defaults change: <tt>optimizer_switch=condition_fanout_filter=on,derived_merge=on</tt></li>
138+
<lt class="rt">Defaults change: <tt>optimizer_switch=condition_fanout_filter=on,
139+
derived_merge=on</tt></li>
139140
<li class="id">Defaults change: <tt>EXTENDED</tt> and <tt>PARTITIONS</tt> keywords for <tt>EXPLAIN</tt> enabled by default</li>
140141
</ol>
141142
</div>
@@ -154,21 +155,22 @@ <h3>Security</h3>
154155
<li class="nd">Password strength enforcement</li>
155156
<li class="id">test database no longer created on installation</li>
156157
<li class="id">Anonymous users no longer created on installation</li>
157-
<li class="id">MySQL Firewall (* commercial; feature also backported)</li>
158158
<li class="id">Random password generated by default on installation</li>
159159
<li class="id">New <tt>ALTER USER</tt> command</li>
160160
<li class="id"><tt>SET password=''</tt> now accepts a password instead of hash</li>
161161
<li class="id">Server now generates SSL keys by default</li>
162162
<li class="id">Insecure <tt>old_password</tt> hash removed [<a href="https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html#function_old-password">1</a>]</li>
163163
<li class="rt">Ability to create utility users for stored programs that can not login [<a href="https://dev.mysql.com/doc/refman/5.7/en/mysql-no-login-plugin.html">1</a>]</li>
164164
<li class="id"><tt>mysql.user.password</tt> field renamed as <tt>authentication_string</tt> to better describe its current usage.</li>
165+
<li class="nd">Support for tablespace encryption [<a href="https://dev.mysql.com/doc/refman/5.7/en/innodb-tablespace-encryption.html">1</a>]</li>
165166
</ol>
166167
</div>
167168
<!-- and Information Schema -->
168169
<a name="performance_schema"></a>
169170
<h3>Performance Schema</h3>
170171
<div class="dual-column">
171172
<ol>
173+
<li class="rt">Scalable memory allocation [<a href="http://mysqlserverteam.com/new-in-mysql-5-7-performance-schema-scalable-memory-allocation/">1</a>]</li>
172174
<li class="id">Overhead has been reduced in client connect/disconnect phases</li>
173175
<li class="rt">Memory footprint has been reduced</li>
174176
<li class="rt">pfs_lock implementation has been improved</li>
@@ -307,7 +309,7 @@ <h3>Misc</h3>
307309
<li class="id"><tt>SET GLOBAL offline_mode=1</tt> [<a href="http://dev.mysql.com/worklog/task/?id=3836">1</a> <a href="http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_offline_mode">2</a>]</li>
308310
<li class="id"><tt>super_read_only</tt> option [<a href="http://dev.mysql.com/worklog/task/?id=6799">1</a>]</li>
309311
<li class="rt">Detect transaction boundaries</li>
310-
<li class="rt">Server version token and check </li>
312+
<li class="rt">Server version token and check [<a href="https://dev.mysql.com/doc/refman/5.7/en/version-tokens.html">1</a></li>
311313
<li class="nd"><tt>SELECT GET_LOCK()</tt> can now acquire multiple locks [<a href="https://dev.mysql.com/worklog/task/?id=1159">1</a> <a href="https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html#function_get-lock">2</a>]</li>
312314
<li class="nd">Configurable maximum statement execution time on a global and per query basis [<a href="http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_max_execution_time">1</a> <a href="http://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html#optimizer-hints-execution-time">2</a>]</li>
313315
<li class="rt">Better handling of connection id rollover</li>

0 commit comments

Comments
 (0)
0