…How do you monitor MySQL to determine when it’s not responsive? A: The easiest way to do this is to simply connect to…to try to install MySQL. It failed miserably on the mysql_install_db process. Every time I tried, I got some variant of this message: 130606 2…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…to MySQL 5.6, be sure to upgrade to Percona Toolkit 2.2, too. We also started beta support for Percona XtraDB Cluster in 2… IO::Socket::SSL Perl module is installed (easily available through your package manager…-time to limit how long they run. There are more changes in addition to those highlights…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… to offload traffic from MySQL 5.6 is to use a caching layer to store expensive result sets or objects. … how one would start the memcached plugin: mysql> install plugin daemon_memcached soname ‘libmemcached.so’; In an effort to not…2.33863 ms per/cmd 1.449 ms min per/cmd 7.324 ms max per/cmd 5…
Post: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
… shows how the packages would conflict when trying to install libmysqlclient.so. For example, when installing php-mysql alongside PS 5.5 in CentOS 6: # yum -q install Percona-Server-server-55 php-mysql Installing: Percona… M Percona-Server-shared-51 x86_64 5.1.67-rel14.3.506.rhel6 percona 2.8 M Percona-Server-shared-55…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…MySQL 5.0 and 5.1 installations that would upgrade or are in the process of upgrading to MySQL 5.5, I thought it necessary to…MySQL 5.5.3. Let’s see how this works now. Metadata Locking behavior starting MySQL 5.5.3 Starting with 5.5…| RENAME TABLE test_2 to test | | 10 | msandbox | localhost | test |…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
…concerns upgrading MySQL 4.1 to MySQL 5.5? This is jumping over 2 …to have upgrade testing done in the environment which is maximally close to production. Q: How safe is it to upgrade from MySQL 5.5 to Percona Server 5.5…to check out our Documentation to get most our of your Percona Server install…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
…. How can I recover deleted rows? We’re going to …to download Percona Data Recovery Tool and compile all the tools using the “make” command. In this example I’m going to install…: http://dev.mysql.com/doc/refman/5.5/en/innodb-physical-…, flags 1, columns 7, indexes 2, appr.rows 2844513 [...] INDEX: …
Post: How to use a smartphone for two-factor authentication with Percona Server for MySQL
February 24, 2013 By Leave a Comment
…in our documentation): mysql> INSTALL PLUGIN auth_pam SONAME ‘auth_pam.so’; 2. Configure PAM for …to authenticate using an OS account (assuming there is an account for user ‘vadim’) 4. Now, to install…are Ubuntu user – install package sudo apt-get install libpam-google-authenticator 5. From the user …
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
…2/4) installing mysql-clients [########################################################] 100% (3/4) installing libaio [########################################################] 100% (4/4) installing percona-server [########################################################] 100% Installing MySQL…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…. for what function) it was allocated, how it got there (a backtrace, …installed version, you’re ready to go. In this example, we’ll write the output to /tmp/massif.out. If you prefer to…mysql-5.5.28/usr/sbin/mysqld) | | | ->10.10% (7,135,744B) 0x3ECF60677B: start_thread (in /lib64/libpthread-2.5….
