after upgrade ssl replication doesn’t work anymore: ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1) same certificates worked fine with 5.5.30, OpenSSL 1.0.0
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.5.31-30.3[/caption] Percona is glad to announce the… here and from the Percona Software Repositories). Based on MySQL 5.5.31, including all the bug fixes in it, Percona Server…. Bug fixed #1179978. Release notes for Percona Server for MySQL 5.5.31-30.3 are available in our online documentation. Bugs…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… the Percona Server version I was using for the test (5.5.28-29.1). This is needed as the plugin needs…: {“msg-type”:”activity”,”date”:”1369155747373″,”thread-id”:”6439″,”query-id”:”0“,”user”:”debian-sys-maint”,”priv_user”:”debian-sys-maint”,”host…”} {“msg-type”:”activity”,”date”:”1369155747383″,”thread-id”:”6440″,”query-id”:”0“,”user”:”debian-sys-maint”,”priv_user”:”debian-sys-maint”,”host…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 22, 2013 By 8 Comments
… part of the reason we decided not to merge MySQL 5.6 global transaction ID into MariaDB. In MariaDB global transaction… read the documentation or try it out in MariaDB 10.0: https://kb.askmonty.org/en/global-transaction-id/
Comment: Derived Tables and Views Performance
May 21, 2013 By 16 Comments
…(11) NOT NULL default ‘0‘, `sort` int(11) default NULL, PRIMARY KEY (`id`)) —————————————————————————————————— $mysql=mysql_connect(’127.0.0.1′,’root’,”); mysql_select_db…); echo “”; while ($row = mysql_fetch_assoc($result)) { if ($row['Count'] > 0) { echo “” . $row['label'] . “”; display_menu($row['id'], $level + 1); echo…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
… disabled the query cache by set global query_cache_size = 0; All this on a fairly decent size server where I…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… have personally only worked with one customer that’s using 5.6), is that I question its readiness. There have been some unfortunate performance regressions compared to 5.5, such as bug #69258, and bug #69318, and I think… being able to retract them. MHA should work fine with 5.6 if you’re not using GTID-based replication. If…
Post: Summertime Percona MySQL training update
June 6, 2013 By 1 Comment
… Monday, June 17, 2013 , 9am – 5pm Eastern Moving to MySQL 5.6 – Manchester, UK Begins Monday, June 17, 2013 , 9am – 5pm In July we have: Moving to MySQL 5.6 – Utrecht, Netherlands Begins Monday, July 1, 2013 , 9am – 5pm… Begins Monday, July 22, 2013 , 9am – 5pm Moving to MySQL 5.6 – Belfast, IE Begins Thursday, August 1, 2013 , 9am – 5pm…
Comment: Percona Server 5.6.11-60.3 first Release Candidate now available
June 5, 2013 By 2 Comments
Hi, do you have any plans on doing benchmark between Percona 5.5 and 5.6 ? Best Regards
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… query in a suboptimal form. Q: Doesn’t the primary key solution for random selection only work when the IDs for…, and making lookups to the `kind_types` table by primary key, the result was a query that took half the time…
