June 19, 2013

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

Hm, yeah, I just tried it on my F18 system (kernel 3.9) and got the same error. Apparently this is a 2.6.x hack only, or maybe there is some other workaround for newer kernel versions that I’m not aware of.

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

… “Max processes=95917:95918″ > /proc/8416/limits bash: echo: write error: Invalid argument # uname -a Linux testbed 3.2.0-45…

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?

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 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… the upstream bug #69379 which caused MySQL clients to return bogus error number for host-not-found errors on Ubuntu 13.04. Bug…

Post: Migrating between MySQL schemas with Percona Xtrabackup

…_old Make sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run: ALTER TABLE… you to compare and restore values (potentially corrupted via user error or other issues) with SQL rather than needing to import…_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT CONCAT(‘ALTER TABLE…

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… a quick sanity check of your schema for any significant errors or items requiring review. Columns – a listing of all columns…

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… replication integrity And finally, Andrew Ferlitsch will share with how MySQL can be used to provide access to government data. The…… :)   So register now! Please also join the Portland MySQL Meetup group for more MySQL-focused events in Portland If you love the…