… x86_64 x86_64 GNU/Linux [percona@db1 ~]$ cat /etc/*release Red Hat Enterprise Linux Server release 5.2 (Tikanga) From this, I… name : Intel(R) Xeon(R) CPU L5335 @ 2.00GHz stepping : 11 cpu MHz : 1995.022 cache size : 4096 KB physical id… stock MySQL server are extremely limited, and for serious analysis it’s basically mandatory to use a server that has the Percona patches…
Post: Introducing the “Version Check” Feature in Percona Toolkit
September 10, 2012 By Leave a Comment
… 5.1.61, 5.2.11, 5.3.5, 5.5.22 Security vulnerability in MySQL/MariaDB sql/password.c MySQL 5.1.61 DSA-2429-1 mysql-5.1 — several vulnerabilities MySQL 5.5.25a Slave crash regression Percona Server 5.5.27-28.0 regression Server hang in 5.5.27-rel28 MariaDB before 5.5.25…
Post: Is MySQL 5.6 slower than MySQL 5.5?
February 18, 2013 By 23 Comments
… Percona we surely will be doing fine tuning for our Percona Server for MySQL version 5.6 release. Another thing to remember about MySQL 5… some old Dell PowerEdge 2850 server. The questions I tried to answer are how much slower 5.6 is for such simple… –max-time=300 run For single thread MySQL 5.5 is 11% faster than MySQL 5.6. If you disable Performance Schema in MySQL…
Post: Clarification on MySQL security vulnerability
June 19, 2012 By 2 Comments
…/MariaDB sql/password.c: 64bit Ubuntu Oneiric (11.10) binaries are vulnerable in Percona Server ONLY on some hardware/virtualization platforms (confirmed on… 12.04 LTS, are NOT vulnerable. The latest Percona Server binaries, 5.1.63 and 5.5.24, are NOT vulnerable. The very complicated nature…
Post: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
February 4, 2013 By 12 Comments
…[1135] Can’t create a new thread (errno 11); if you are not out of available…session. If you’re running RHEL/CentOS 5, Ubuntu, or versions of Fedora prior to… service mysql restart Shutting down MySQL (Percona Server)… SUCCESS! Starting MySQL (Percona Server).. SUCCESS! [~] (root@revolution 23:59:45…
Post: Debian / Ubuntu Percona builds
March 9, 2009 By 8 Comments
… announcements), and you can get it there http://www.percona.com/downloads/Percona-Server-5.0/LATEST/deb/, and your feedback is welcome! As…, which I mentioned before (http://www.mysqlperformanceblog.com/2009/02/11/limiting-innodb-data-dictionary/). Speaking of deb binaries I tried… to interpret, so I removed any mentioning of embedded server as 5.0 actually is not supposed to work in embedded mode…
Post: Percona XtraBackup 1.4
November 22, 2010 By 10 Comments
… by commas. (Yasufumi Kinoshita) Other Changes: Ported to the Percona Server 5.1.47-11 code base. (Yasufumi Kinoshita) XtraBackup now uses the memory… found at Bugs in Percona XtraBackup. For general questions, use our Percona Discussions Group, and for development questions our Percona Development Group. For…
Post: PBXT in tpcc-like benchmark
June 2, 2010 By 10 Comments
Finally I was able to run PBXT 1.0.11 pre-GA in tpcc-like workload, apparently there was bug … (32 GB on server), and compared 1 and 16 users in MySQL-5.1.46/PBXT and Percona Server / XtraDB – 5.1.45-rel10.2…. While full results and config are on Wiki: http://www.percona.com/docs/wiki/benchmark:pbxt:tpcc:start there are graphs…
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
… results of my testing of the new Group Commit in Percona Server 5.1. As background information, the problem appears when you have…-back cache online. There are two versions tested: Percona Server 5.1.57 – released and Percona Server 5.1.57 with the Group Commit Fix applied… 1066.05 256 2108.14 2044.85 2004.13 1669.11 As you can see, enabling binary logs with system without…
Post: When is MIN(DATE) != MIN(DATE) ?
September 4, 2012 By 5 Comments
…week with an interesting MySQL puzzle. He was running Percona Server 5.5.21 with a table structure that looks something … min(update_date) from foo; +———————+ | min(update_date) | +———————+ | 1058-11-06 00:00:00 | +———————+ (root@localhost) [test]> update …
