…In MySQL 5 number of Innodb performance counters were exported and now available in…Value is specified in microseconds. mysql tables in use 1, locked 0 is number of tables used by transaction in…in this case database pages will not be equal to total size of buffer pool, because buffer pool also stores…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
…HEX AND BINARY DATA… 080703 23:46:16 InnoDB: Page checksum 587461377, prior-to-4.0.14-form checksum 772331632 InnoDB: stored…in cases you’ve want to recover deleted rows or dropped table. I should also mention at Percona we offer assistance in MySQL…
Comment: To UUID or not to UUID ?
April 15, 2008 By 28 Comments
… problems with UUID’s in MySQL when stored as text. Ideally, MySQL would have a UUID column type to store the values as binary rather than strings but convert to string anytime the row is returned. The ability to insert an ID in hex… generating random UUID’s with an option to store them in Base64 rather than hex. Since the length of the UUID is always…
Post: Recover BLOB fields
July 1, 2010 By 4 Comments
… field are stored internally. The rest is stored in external pages. They have type FIL_PAGE_TYPE_BLOB. Page type is stored in a FIL… CHARSET=latin1 Here COMPACT format is used, which is default in MySQL >= 5.1. The record consists of four parts: Offsets. Effectively… table in tab-separated values format. BLOBs are printed in a hex form – 0ACD86… To upload the table back you should utilize UNHEX function: mysql…
