…:16 InnoDB: Page dump in ascii and hex (16384 bytes): … A LOT OF HEX AND BINARY DATA… 080703 23:46:16 InnoDB: Page… page data. The next comes trial and error approach: mysql> insert into test2 select * from test; ERROR 2013 (HY000): Lost connection to MySQL server… all data it could recover to MyISAM table. Using series of queries with LIMIT can be handly if you recover manually: mysql> insert…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
…: len 30; hex 306338386465646233353863643936633930363962373361353736383261; asc 0c88dedb358cd96c9069b73a57682a;…(truncated); 1: len 4; hex 00000005; asc ;; …MySQL thread id 1794751, query id 6994931 localhost root Sending data insert into test select * from sample ——– As you can see INSERT…
Post: On Character Sets and Disappearing Tables
June 21, 2012 By 1 Comment
…FK reference due to a mismatched data type (non-existent certainly qualifies as…unless you’re handy with a hex editor and have a good knowledge… TABLE recovery LIKE `#sql2-3c13-14`; INSERT INTO recovery SELECT * FROM `#sql2-3c13-…something of an inconsistency present when MySQL won’t allow us to change…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…, process no 3946, OS thread id 1151088992 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 3 lock… 368, undo log entries 1 MySQL thread id 9697561, query id 188161264 localhost root update insert into child values(2,2) Foreign… index `par_ind` tuple: DATA TUPLE: 2 fields; 0: len 4; hex 80000002; asc ;; 1: len 6; hex 000000000401; asc ;; But in parent…
Post: Idea: Couple of more string types
April 18, 2008 By 12 Comments
MySQL has a lot of string data types – CHAR, VARCHAR, BLOB, TEXT, ENUM and bunch…see type HEXCHAR which would be able to store hex strings, such as those returned as MD5() and SHA1… which would transparently compress the blobs when they are inserted and retrieved from the database – this would allow …
Post: Friday challenge: ibd recovery
May 15, 2009 By 8 Comments
… to train a bit in InnoDB data recovery techniques. I have .ibd … ) ENGINE=InnoDB … (SOME PARAMETERS SKIPPED) …; and I inserted one record into this table … applied to both fields so just HEX viewer may not help you there…- will receive our book “High Performance MySQL” 2nd edition, or if he …
