June 19, 2013

Post: How to recover table structure from InnoDB dictionary

April 22, 2013 By 4 Comments

… 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…

Filed Under: Insight for DBAs, MySQL Tagged With: , , , , , ,

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

February 25, 2013 By 10 Comments

… 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…

Filed Under: Hardware and Storage, Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , ,

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

January 9, 2013 By Leave a Comment

… 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…

Filed Under: MySQL, Percona Software, Percona Toolkit Tagged With: , , , ,

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

December 29, 2011 By 3 Comments

… 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 …

Filed Under: Insight for DBAs, MySQL

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

March 4, 2013 By 7 Comments

… 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…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

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

June 3, 2011 By 8 Comments

… ‘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…

Filed Under: MySQL

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

March 13, 2013 By 8 Comments

… 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…

Filed Under: Cloud and NoSQL, Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , , , , ,

Post: Announcing Percona XtraBackup 2.0.0 GA

April 4, 2012 By 11 Comments

… 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…

Filed Under: MySQL

Post: Percona Server 5.5.13-20.4 Stable Release

July 1, 2011 By 3 Comments

… 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…

Filed Under: MySQL

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

December 19, 2012 By Leave a Comment

…. 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…

Filed Under: MySQL, Percona Software, XtraDB Cluster
« Older Posts