…Percona…innodb_change_bufferingblogpercona.commanual innodb_checksumsblogpercona.commanual innodb_commit_concurrencyblogpercona.commanual innodb_concurrency_ticketsblogpercona.commanual innodb_data_file_pathblogpercona.commanual Innodb_data_fsyncsblogpercona.commanual innodb…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
…_get_page(index)) InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you… – typically if page directory is corrupted you would need to skip at least whole page. If page is corrupted at higher… or dropped table. I should also mention at Percona we offer assistance in MySQL Recovery, including recovery from Innodb corruptions and deleted data.
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 3 Comments
… I’m going to explain three of them: A) INNODB_SYS_INDEXES Percona Server has some extra tables in INFORMATION_SCHEMA that… format in the following link: http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:generating_a_table_definition With… rows affected (0.01 sec) Records: 3 Deleted: 0 Skipped: 0 Warnings: 0 mysql (employees) > select * from salaries where emp_no=10008…
Post: How InnoDB handles REDO logging
February 3, 2011 By 18 Comments
…. Both the MySQL configuration and hardware will affect the speed at which InnoDB can log. You can request that InnoDB force its REDO… higher the record is skipped. This behavior can be seen by enabling the innodb_recovery_stats option in Percona Server, which allows you…, as seen in his post, Percona Server with XtraDB allows much larger logs beyond the InnoDB limit of 4G. As a side…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… 64-bit OS. Examining MySQL configuration Then I’ll look at my.cnf quickly for anything weird: [percona@db1 ~]$ grep -v ‘^#’ /etc… example, the absence of skip-name-resolve is easy to miss, as is the absence of innodb_log_file_size. I won… that has the Percona patches for microsecond logging and additional information in the slow query log output. The stock MySQL server’s…
Post: Copying InnoDB tables between servers
July 31, 2009 By 10 Comments
…percona.tv). Let’s take tpcc schema and running standard MySQL…innodb_data_home_dir = ./ xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… innodb_log_file_size=4G (innodb_log_files_in_group=2) for Percona Server. That gave 8GB in total size for log files (MySQL…: [client] socket=/var/lib/mysql/mysql.sock [mysqld] core basedir=/usr/local/mysql user=root socket=/var/lib/mysql/mysql.sock skip-grant-tables server_id=1 local_infile=1 datadir=/mnt/fio320 innodb_buffer_pool_size=24G innodb_data_file…
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 7 Comments
… to recover the data with the Innodb recovery tool of Aleksandr Kuzminsky a colleague on the Percona European team of consultants. In…_SPACEID” ] do echo “skipping spaceID $CURRENT_ID” mysql -u root -e “create table space_$CURRENT_ID (id int) engine=Innodb;” filler let CURRENT… echo “switching to Innodb ” mysql -u root -e “alter table recover.$CURRENT_TABLENAME engine=Innodb;” sleep 1 echo “discarding tablespace ” mysql -u root -e…
Post: Connecting orphaned .ibd files
May 13, 2011 By 12 Comments
…’s modify SPACE in InnoDB dictionary. MySQL must be stopped at this point. There is a tool ibdconnect in Percona InnoDB Recovery Tool. Make….ibd actor.ibd belongs to space #15 … Skipped output… SYS_TABLES is updated successfully … Skipped output… SYS_INDEXES is updated successfully It…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…-8eb648e7 shard-query-innodb-demo-64bit x86_64 Percona Server 5.5.11…mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file-per-table innodb…-rnd-buffer-size=1M skip-host-cache skip-name-resolve sort-buffer-…
