…schemas. One of the downsides to mysqldump is the need to scan the full tables and in turn, load that data into and…InnoDB’; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT CONCAT(‘ALTER TABLE `’, table_name, ‘` IMPORT TABLESPACE;’) AS _ddl FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
…MySQL has traditionally been challenging. Most data can be obtained from the slow or general log, but this involves a lot of data… MySQL internals can enlighten me here. – audit_record_objs : List of database objects (tables,… one for me, since I think proper audit trail support has been an important…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… Peter blogged about the importance of performance at low concurrency…pages from the buffer pool should be faster than getting them from…SSB Flight #4 There is one query in this flight, Q4…TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…imported by ALTER TABLE IMPORT TABLESPACE on MySQL and Percona Server 5.6 as described in Exporting and Importing Tables…data in the log copying thread which could cause XtraBackup to crash. Bug fixed #1166888. Package dependency has been changed from abstract mysql…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… are available from our download …imported by ALTER TABLE IMPORT TABLESPACE on MySQL and Percona Server 5.6 as described in Exporting and Importing Tables…tables. Bug fixed #1169169. Tables that were dropped between taking a full backup and an incremental one… handling the innodb_data_file_path…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
…important use case for PARTITIONing (“uneven reads”, Re: #1); let me rephrase the use case — * The entire table…one partition. In one instance, I take advantage of that — I have 10 years of data…MySQL. PARTITIONs are scanned one…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
…data from one table. In this case we’re going to delete the salary information from the user 10008: mysql> SELECT * FROM…
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 8 Comments
…a transfer from one SAN to another, something went wrong and they lost the ibdata1 file, where all the table meta-data is …mysql/recover/ chown mysql.mysql /var/lib/mysql/recover/$CURRENT_TABLENAME.ibd sleep 1 echo “importing tablespace” mysql -u root -e “alter table recover.$CURRENT_TABLENAME import…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
…table row format from the Information Schema: mysql (information_schema) > SELECT ROW_FORMAT from TABLES WHERE TABLE_SCHEMA=’employees’ AND TABLE…import it in our database: mysql (employees) > LOAD DATA INFILE ‘/root/recovery-tool/data/salaries.recovery’ REPLACE INTO TABLE…
Post: Data mart or data warehouse?
July 15, 2010 By 14 Comments
…one or more data transformations is usually called a “flow”. An example ETL flow might combine data from…data to the source tables. The goal of this methodology is the 100% accurate description of historical data from…
