Percona Server v5.6.31-77.0 发布,MySQL 数据库改进

jopen 8年前
   <p style="text-align: center;"><img alt="" src="https://simg.open-open.com/show/84c3deaa9a2f297b1ea345f7149449f6.jpg" /></p>    <p>Percona 为 MySQL 数据库服务器进行了改进,在功能和性能上较 MySQL 有着很显著的提升。该版本提升了在高负载情况下的 InnoDB 的性能、为 DBA 提供一些非常有用的性能诊断工具;另外有更多的参数和命令来控制服务器行为。</p>    <p>Percona Server 只包含 MySQL 的服务器版,并没有提供相应对 MySQL 的 Connector 和 GUI 工具进行改进。</p>    <h2>更新日志</h2>    <p>新特性:</p>    <ul>     <li><em>Percona Server</em> implemented <a href="/misc/goto?guid=4958991949988811202">protocol support for TLS 1.1 and TLS 1.2</a>. This implementation turns off TLS v1.0 support by default.</li>     <li><em>TokuDB</em> MTR suite is now part of the default MTR suite in <em>Percona Server</em> 5.6.</li>    </ul>    <p>Bugs修复:</p>    <ul>     <li>Querying the <a href="/misc/goto?guid=4958991950112414960"><code>GLOBAL_TEMPORARY_TABLES</code></a> table caused server crash if temporary table owning threads would execute new queries. Bug fixed <a href="/misc/goto?guid=4958991950223696157" rel="nofollow">#1581949</a>.</li>     <li><a href="/misc/goto?guid=4958991950322598356">Audit Log Plugin</a> would hang when trying to write log record of <a href="/misc/goto?guid=4958991950437565856"><code>audit_log_buffer_size</code></a> length. Bug fixed<a href="/misc/goto?guid=4958991950547244500" rel="nofollow">#1588439</a>.</li>     <li>Audit log in <code>ASYNC</code> mode could skip log records that don’t fit into log buffer. Bug fixed <a href="/misc/goto?guid=4958991950646890538" rel="nofollow">#1588447</a>.</li>     <li>The <a href="/misc/goto?guid=4958987033235317121"><code>innodb_log_block_size</code></a> feature attempted to diagnose the situation where the logs have been created with a log block value that differs from the current <a href="/misc/goto?guid=4958987033235317121"><code>innodb_log_block_size</code></a> setting. But this diagnostics came too late, and a misleading error <code>No valid checkpoints found</code> was produced first, aborting the startup. Bug fixed <a href="/misc/goto?guid=4958991950816501804" rel="nofollow">#1155156</a>.</li>     <li>Some transaction deadlocks did not increase the <code>INFORMATION_SCHEMA.INNODB_METRICS</code> <code>lock_deadlocks</code>counter. Bug fixed <a href="/misc/goto?guid=4958991950912304783" rel="nofollow">#1466414</a> (upstream <a href="/misc/goto?guid=4958991951021114103" rel="nofollow">#77399</a>).</li>     <li><em>InnoDB</em> tablespace import failed when trying to import a table with different data directory. Bug fixed <a href="/misc/goto?guid=4958991951123675504" rel="nofollow">#1548597</a>(upstream <a href="/misc/goto?guid=4958991951223918784" rel="nofollow">#76142</a>).</li>     <li><a href="/misc/goto?guid=4958991950322598356">Audit Log Plugin</a> truncated SQL queries to 512 bytes. Bug fixed <a href="/misc/goto?guid=4958991951349719025" rel="nofollow">#1557293</a>.</li>     <li>Regular user extra port connection failed if <code>max_connections</code> plus one <code>SUPER</code> user were already connected on the main port, even if it connecting would not violate the <a href="/misc/goto?guid=4958991951479178502"><code>extra_max_connections</code></a>. Bug fixed <a href="/misc/goto?guid=4958991951576415901" rel="nofollow">#1583147</a>.</li>     <li>The error log warning <code>Too many connections</code> was only printed for connection attempts when<code>max_connections</code> plus one <code>SUPER</code> have connected. If the extra <code>SUPER</code> is not connected, the warning was not printed for a non-<code>SUPER</code> connection attempt. Bug fixed <a href="/misc/goto?guid=4958991951683050660" rel="nofollow">#1583553</a>.</li>     <li><code>mysqlbinlog</code> did not free the existing connection before opening a new remote one. Bug fixed <a href="/misc/goto?guid=4958991951796263160" rel="nofollow">#1587840</a>(upstream <a href="/misc/goto?guid=4958991951901601393" rel="nofollow">#81675</a>).</li>     <li>Fixed memory leaks in <code>mysqltest</code>. Bugs fixed <a href="/misc/goto?guid=4958991952001182420" rel="nofollow">#1582718</a> and <a href="/misc/goto?guid=4958991952112737481" rel="nofollow">#1588318</a>.</li>     <li>Fixed memory leaks in <code>mysqlcheck</code>. Bug fixed <a href="/misc/goto?guid=4958991952225921697" rel="nofollow">#1582741</a>.</li>     <li>Fixed memory leak in <code>mysqlbinlog</code>. Bug fixed <a href="/misc/goto?guid=4958991952330165709" rel="nofollow">#1582761</a> (upstream <a href="/misc/goto?guid=4958991952433484593" rel="nofollow">#78223</a>).</li>     <li>Fixed memory leaks in <code>mysqldump</code>. Bug fixed <a href="/misc/goto?guid=4958991952541053267" rel="nofollow">#1587873</a> and <a href="/misc/goto?guid=4958991952649915110" rel="nofollow">#1588845</a> (upstream <a href="/misc/goto?guid=4958991952759680015" rel="nofollow">#81714</a>).</li>     <li>Fixed memory leak in non-existing defaults file handling. Bug fixed <a href="/misc/goto?guid=4958991952872464830" rel="nofollow">#1588344</a>.</li>     <li>Fixed memory leak in <code>mysqlslap</code>. Bug fixed <a href="/misc/goto?guid=4958991952980324778" rel="nofollow">#1588361</a>.</li>     <li><em>Transparent Huge Pages</em> check will now only happen if <code>tokudb_check_jemalloc</code> option is set. Bugs fixed<a href="/misc/goto?guid=4958991953082462350" rel="nofollow">#939</a> and <a href="/misc/goto?guid=4958991953195086490" rel="nofollow">#713</a>.</li>     <li>Logging in <code>ydb</code> environment validation functions now prints more useful context. Bug fixed <a href="/misc/goto?guid=4958991953300374178" rel="nofollow">#722</a>.</li>    </ul>    <p>其他Bugs修复: <a href="/misc/goto?guid=4958991953397275382" rel="nofollow">#1588386</a>, <a href="/misc/goto?guid=4958985195841371509" rel="nofollow">#1529885</a>, <a href="/misc/goto?guid=4958991953548654322" rel="nofollow">#1541698</a> (upstream <a href="/misc/goto?guid=4958991953654975341" rel="nofollow">#80261</a>), <a href="/misc/goto?guid=4958991953754307230" rel="nofollow">#1582681</a>, <a href="/misc/goto?guid=4958991953868477564" rel="nofollow">#1583589</a>, <a href="/misc/goto?guid=4958991953976430668" rel="nofollow">#1587426</a> (upstream, <a href="/misc/goto?guid=4958991954086531358" rel="nofollow">#81657</a>),<a href="/misc/goto?guid=4958991954181489270" rel="nofollow">#1589431</a>, <a href="/misc/goto?guid=4958990793564503798" rel="nofollow">#956</a>, and <a href="/misc/goto?guid=4958990793390230696" rel="nofollow">#964</a>.</p>    <h2>下载</h2>    <ul>     <li><a href="/misc/goto?guid=4958991954368761090" rel="nofollow"><strong>Source code</strong> (zip)</a></li>     <li><a href="/misc/goto?guid=4958991954467179821" rel="nofollow"><strong>Source code</strong> (tar.gz)</a></li>    </ul>    <p> </p>