… revision of the recovery tool bzr branch lp:percona-data-recovery-tool-for-innodb 1. Compile the dictionary parsers make dict_parsers…/
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 9, 2013 By 32 Comments
Thanks Vadim, I did the test on 5.6 and load data infile concurrently results for two threads is 20 times slower then… compression as we are facing more and more big data challenges where innoDB and TokuDB will have to be compare with LevelDB…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
… a customer ask me about loading two huge files into InnoDB with LOAD DATA INFILE. The goal was to load this data on many servers without putting… name a few: the big LOAD DATA INFILE clogs the binary log and slows replication down. If the load takes 4 hours on the… 1; done Note that the file mentioned in LOAD DATA INFILE is /tmp/my-fifo, not infile.txt! After I was done, I ran…
Post: Predicting how long data load would take
May 24, 2007 By 14 Comments
…load data in MySQL you can use Multiple value insert (standard mysqldump output) or LOAD DATA INFILE (–tab mysqldump output). Generally LOAD DATA…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
… following link: http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:generating_a_table_definition With the table definition… the data in our hands the last step is to import it in our database: mysql (employees) > LOAD DATA INFILE ‘/root/recovery-tool/data/salaries…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
… not used you can enable innodb_locks_unsafe_for_binlog option, which will relax locks which Innodb sets on statement execution, which… unsafe fore replication and point in time recovery, so use innodb_locks_unsafe_for_binlog option with caution. Note disabling binary… to use: SELECT * FROM tbl1 INFO OUTFILE ‘/tmp/tbl1.txt’; LOAD DATA INFILE ‘/tmp/tbl1.txt’ INTO TABLE tbl2; instead of: INSERT INTO…
Post: High Rate insertion with MySQL and Innodb
January 7, 2011 By 17 Comments
… over 200K of inserts/sec. This time I worked with Innodb tables… it was a different system with different table structure… what I used for start. Using multiple buffer pools with innodb_buffer_pool_instances=8 was very important. Second thing – Partitioning… you would get much lower numbers. In fact we used load data infile which is one of the ways to get a great…
Post: Interested to learn about New Innodb Plugin Performance ?
April 15, 2008 By 2 Comments
… Innodb for) – for example neither of standard data load tools (mysqldump import, using LOAD DATA INFILE or ALTER TABLE from other storage engine) would use Fast Innodb… and Ken which will be followed by my presentation on Innodb Scalability Limits. I will not go a lot into this… cool. P.S I’m also very happy to see Innodb continues to provide full Server functionality under GPL License.
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… me start with most popular transactional storage engine for MySQL – Innodb. Innodb Storage Engine was covered in a lot of talks, many… size for Innodb table, while data pages and pages for different indexes may well have very different compression ratio. As Innodb indexes are… I do not yet know answer for – for example will LOAD DATA INFILE be optimized same way as for MyISAM tables by separate…
Post: Recovery after DROP & CREATE
August 22, 2012 By 1 Comment
….SYS_TABLES -4Df pages-1345219305/FIL_PAGE_INDEX/0-1 LOAD DATA INFILE ‘/root/src/recovery-tool/s_tools/dumps/default/SYS_INDEXES…-1345219305/FIL_PAGE_INDEX/0-3| grep 15 | grep PRIMARY LOAD DATA INFILE ‘/root/src/recovery-tool/s_tools/dumps/default/SYS_INDEXES… bytes is index_id. In revision 69 of Percona Data Recovery Tool for InnoDB two tools are added: s_tables and s…
