June 19, 2013

Post: How to recover table structure from InnoDB dictionary

… e.g. sakila/actor. `ID` is a table identifier. We will need the table id to find indexes of the table. mysql… have all necessary information to generate CREATE TABLE statement. 0. Download the latest revision of the recovery tool bzr branch lp… of the dictionary tables into some MySQL server. Use LOAD DATA INFILE constraints_parser generates mysql>LOAD DATA INFILE ‘/path/to/SYS…

Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80

… on your laptop or desktop PC. Download Fedora ARM Installer (available for Linux and Windows). Download the Arch Linux ARM image from… start mysqld Connect using the mysql client: [root@alarmpi ~]# /usr/bin/mysql Welcome to the MySQL monitor. Commands end with ; or \g. [...] mysql> SHOW ENGINES…

Post: Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6

… inconsistently. Previously, pt-heartbeat respected the MySQL time zone, but this caused false readings (e.g. very high lag) with slaves running… the server. Percona Toolkit packages can also be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories…

Post: Identifying the load with the help of pt-query-digest and Percona Server

… atomically, not just for new connections as in MySQL. This is very helpful for measurement as otherwise … memory consuming, so ideally you would want to download the “slow query log” to another machine and …, option_value FROM wp_options WHERE autoload = ‘yes’\G This is the actual part of the output …

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

… name, address, and the like. We are using MySQL 5.5.30 and MySQL 5.6.10 with no configuration tuning other… ft_min_word_length. First, MyISAM, with MySQL 5.5, on the SEO data set: mysql: SELECT id, title, MATCH(title, body… for Starting or Maintaining a Successful Business | 1.3383517265319824 | | 7112 | Download Idaho Tax Forms for Individual or Business Needs | 0.9273209571838379…

Post: A recovery trivia or how to recover from a lost ibdata1 file

… ‘s/ENGINE=InnoDB/ENGINE=MyISAM/g‘ schema.sql root@domU:/mnt/tables# cat schema.sql | mysql -u root test The MyISAM table…_TABLENAME.ibd /var/lib/mysql/recover/ chown mysql.mysql /var/lib/mysql/recover/$CURRENT_TABLENAME.ibd sleep 1 echo “importing tablespace” mysql -u root -e… modified schema, the recovery completed. The customer was able to download the tables in MyISAM format and then he just convert…

Post: MySQL Backup tools used by Percona Remote DBA for MySQL

… the majority of data on the server was lost. e.g. there is one primary schema and that schema was dropped… to s3 vs xtrabackup given the time needed to upload/download. Though it depends on the available bandwidth and should be… term backups Decompressing Percona XtraBackup for MySQL  in parallel using all your resources available Downloading from s3 in parallel Parallel encryption/description…

Post: Announcing Percona XtraBackup 2.0.0 GA

… also had a number of other limitations (e.g. could not be used with parallel file copying…of the topics at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically, there are…20 @ Ballroom F You can download Percona XtraBackup 2.0.0 from our downloads site or install it using…

Post: Percona Server 5.5.13-20.4 Stable Release

… on July 1st, 2011 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.13, Percona Server…: #802348 (Y. Kinoshita). XtraDB crashed when importing big tables (e.g. 350G) using the Expand Table Import feature due to a… distribution: #737947 For more information, please see the following links: Downloads: Binary distributions, Percona Software Repositories Installation instructions Consulting, support, training…

Post: Percona XtraDB Cluster (PXC): what about GRA_*.log files ?

…. You can download one here :GRA-header We can verify it easily: file /tmp/GRA-header /tmp/GRA-header: MySQL replication log…_3.log: data [root@node2 mysql]# ls -l GRA_3_3.log -rw-rw—-. 1 mysql mysql 106 Nov 29 23:28 GRA…: 1 conn_id: 8 trx_id: 2582 seqnos (l: 9, g: 3, s: 2, d: 0, ts: 1354228134888418369) 121129 23:28…