…to do with it. The other approach is to filter what gets written to the binary…How do you monitor MySQL to determine when it’s not responsive? A: The easiest way to do this is to simply connect to… mounted, and went to try to install MySQL. It failed miserably on the mysql_install_db process. Every …
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… When you upgrade to MySQL 5.6, be sure to upgrade to Percona Toolkit 2… binary, and tcpdump), so you shouldn’t have a problem finding queries to …::Socket::SSL Perl module is installed (easily available through your package …time to limit how long they run. There are more changes in addition to those …
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… (with their IDs) to the error log. mysql (employees) > CREATE TABLE… if you have a binary backup. Just use constraint_parser …
Post: Distro Packages, Pre-built Binaries or Compile Your Own MySQL
September 4, 2012 By 7 Comments
… consulting customers, but widely from different forums and blogs – how should I install MySQL on my server and what pros and cons does… open source world, with the freedom to customize software to fit every organizational needs, compiling custom MySQL binaries takes a third of the options…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…function) it was allocated, how it got there (… but powerful way to profile MySQL memory usage;…installed version, you’re ready to go. In this example, we’ll write the output to /tmp/massif.out. If you prefer to…binaries you have are stripped, you have a few options to get a debug build of mysqld to…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… tool included with Flexviews. It continues with an overview of how to install and run FlexCDC, and concludes with a demonstration of the… name. The Binary Log is the MySQL log which records changes to tables in the database. FlexCDC reads the binary log to determine what rows… a message “setup completed” otherwise. Verify installation The binary log stores it progress in a metadata table: $ mysql -e ‘select * from flexviews.binlog…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… promise to provide binaries, even… how to get Percona Server for MySQL…installing percona-server [########################################################] 100% Installing MySQL system tables… OK Filling help tables… OK [...more setup information, please read...] [Optional] Set Percona server to…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… galera and built-in mysql replication are independent from each other. Q: I installed Percona as cluster … how to start up a cluster from scratch (i.e. a standalone XtraDB Cluster machine, convert it to …odd. Q: How is configuration for the arbitrator? A: You should use the garbd binary for that, …
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… thing to mention having multiple instances of different MySQL versions on the same box typically means you will install them from binary distribution instead… 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…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… wrote about how to make MySQL replication reliable, part of which is to eliminate temporary tables. …MySQL 5.1 and later, but most installations I know of are using statement-based replication, even on MySQL…how the stored procedure call is logged to the binary log. Let’s create a stored procedure to…
