…data. Now, enough with the theory, here is the procedure I used: Locate…database: mysqladmin create orig_old Load the schema into the target database: mysql orig_old < /tmp/orig.schema.sql Ensure innodb…mysql/orig_old Make sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…databases but until recently this type of software was not available for MySQL. Change Data Capture can be used to: Monitor a database…file. FlexCDC is located in the flexviews/consumer/ subdirectory. Create the settings file…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
…file and import them into the database. The time between the deletion of rows and the database…of the tablespace to an output directory. We only need to specify the row format (-5) and where is our tablespace located….percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:generating_a_…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…data/mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb_flush_log_at_trx_commit = 2 innodb…of 8 threads running concurrently. Because the customer was running a database…
Post: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
…files. Usually system tablespace is located in ibdata1 file and every InnoDB table has two files…database taken from some MySQL server. 0. Create empty InnoDB tablespace. 1. Create the table: mysql…MySQL 5.1 on CentOS 5.6 x86_64. However it expected to work on all versions of MySQL/InnoDB…
Post: How long is recovery from 8G innodb_log_file
December 22, 2010 By 11 Comments
…mysql 1000W workload with 52GB and 144GB innodb_buffer_pool_size with data located on Virident tachIOn card and killed mysqld after 30 mins of…InnoDB: Rollback of non-prepared transactions completed that is 7min 51sec for 144GB innodb_buffer_pool_size: 101220 22:45:37 InnoDB: Database…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… a large spike in number of connections to MySQL, which often happens when several transactions kill the database performance resulting in very long… innodb-status-file option set in your my.cnf. This will make InnoDB to write the full status output into innodb_status.
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…of Innodb on Solaris? HT: Yes, if your ‘write working set’ fits in 16 GB. I mean, if the database…_log* files; I know that innodb writes files in the log file group in … always occur to the same memory location(s)? HT: Yes. Q33: Do… good way to get large data manageable. MySQL Master Master Manager can…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…Your InnoDB table was corrupt and mysql shuts down Your server or RAID controller crashes and all data … and some or all of your servers go down in that location Your entire datacenter loses … each DB write out ALTER DATABASE DEFAULT CHARACTER SET
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…INNODB_DATA_PENDING_READS | 0 | | INNODB_DATA_READ | 3140882432 | | INNODB_DATA_READS | 191581 | | INNODB_PAGES_READ | 191570 | | INNODB_ROWS_READ | 910844 | +—————————————+—————-+ 10 rows in set (0.01 sec) mysql…
