June 19, 2013

Comment: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)

… easy though: # grep proc /proc/8416/limits Max processes 95918 95918 processes # echo -n “Max processes=95917:95918″ > /proc/8416/limits bash…

Post: Call for papers: Percona Live London

… step up and volunteer to present your unique insights into MySQL and MySQL-related technologies either as a keynote, tutorial or breakout… sponsors. This is the showcase event for Europe’s growing MySQL community of developers, business managers, technology evangelists, DBAs and entrepreneurs…

Post: MySQL Webinar: Percona XtraDB Cluster Operations, June 26

Percona XtraDB Cluster (PXC) was released over a year ago and since then there has been tremendous interest and adoption.  There’s plenty of talks that explain the fundamentals of PXC, but we’re starting to reach a threshold where it’s easier to find folks with PXC in production and such the need …

Comment: Percona Server 5.6.11-60.3 first Release Candidate now available

does/will Percona 5.6 include handlersocket? I assume it’s including the memcache nosql interface in mysql 5.6, correct?

Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!

… of node2) through Xtrabackup SST (state snapshot transfer). Node3 subsequently joins the cluster with node1 and node2 in its gcomm:// (since… restarted (and there are others when it comes up) it joins the cluster seamlessly. I would like to note here that…

Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

Why does the mysql client says it’s 5.1.70? Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 138 Server version: 5.1.70-rel14.7-log Percona Server (GPL), 14.7, Revision 572

Post: Percona MySQL University @Portland next Monday!

…, Percona Xtrabackup and Performance and Improvements and new Features in MySQL 5.6 Garrick Peterson, a member of Percona’s RemoteDBA… with MySQL, then this is an event you can’t afford to miss… :)   So register now! Please also join the Portland MySQL Meetup group for more MySQL-focused events in Portland If you love the ideal of Percona MySQL University and…

Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

….7 on June 10, 2013. A drop in replacement for MySQL, downloads are available  here and from the Percona Software Repositories… #1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on…. Bug fixed #1186690. Under very rare circumstances, deleting a zero-size bitmap file at the right moment would make server stop…

Post: Implementing SchemaSpy in your MySQL environment

… Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath=/usr/share/java/mysql-connector-java.jar Example Schema… great way for a high level overview of the table sizes and an easy way to use the search feature of…

Post: MySQL Query Patterns, Optimized - Webinar questions followup

On Friday I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars.  If you missed it, you can still… IDs for movies are distributed uniformly over the range 1..MAX(id)? Yes, there’s a risk if you have irregular… upcoming Percona Training classes in North America and Europe. Join Percona and the MySQL community at our events.  The next one is…