… log event entry. The possible reasons are: the master’s binary log is corrupted (you can check this by running ‘mysqlbinlog… the master’s or slave’s MySQL code. If you want to check the master’s binary log or slave’s relay… to deal with). You can use mysqlbinlog (or you favorite hex editor if mysqlbinlog does not work) to find the next…
Comment: To UUID or not to UUID ?
April 15, 2008 By 28 Comments
…’s in MySQL when stored as text. Ideally, MySQL would have a UUID column type to store the values as binary rather than… ID in hex text and convert it to binary would be a must too. That’s the biggest problem with using binary fields… bytes vs. 16) and you are able to convert to binary and hex at any time. Later, as I thought more of…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
…16 InnoDB: Page dump in ascii and hex (16384 bytes): … A LOT OF HEX AND BINARY DATA… 080703 23:46:16 InnoDB: Page…table I am getting: mysql> check table test; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> check table test; +———–+——-+———-+———-+ | …
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 21 Comments
… work right in MySQL before 5.1. In MySQL 5.1 this… option with caution. Note disabling binary logs is not enough to trigger…0: len 30; hex 306338386465646233353863643936633930363962373361353736383261; asc 0c88dedb358cd96c9069b73a57682a;…(truncated); 1: len 4; hex 00000005; asc ;; ——————…
Post: Idea: Couple of more string types
April 18, 2008 By 12 Comments
… to see type HEXCHAR which would be able to store hex strings, such as those returned as MD5() and SHA1() efficiently… like that in MySQL. Either you store them as strings and waste space or you spend them as binary and deal with…. Though this is likely to require more significant changes in MySQL so I would not expect to happen quickly. The basic…
Comment: Fixing column encoding mess in MySQL
January 27, 2011 By 32 Comments
…’t find any binary functions that seem likely to help. the have bin2hex… what would I do with hex data? and some… a REPLACE on test data in MySQL: SET field = REPLACE(field, ‘•’, ‘•’); MySQL said it happily replaced the string in…
