…with 1000 values in a batch. This was a big surprise for me as I’ve used batching …code ninja to take a look what it could be and here is what he tells me: This may be… (trx->isolation_level select_lock_type != LOCK_NONE && trx->mysql_query_str) { /* Scan the MySQL query string; check if SELECT is the…
Post: Using CHAR keys for joins, how much is the overhead ?
June 18, 2007 By 18 Comments
… my opinion without a big need. I told … row *************************** id: 1 select_type: SIMPLE table: t2 type: ref possible_keys: j…set (0.00 sec) So what about Innodb ? Innodb … shorten some internal buffers MySQL has to allocate for… check if using longer strings slows down things significantly…
Post: Lost innodb tables, xfs and binary grep
November 9, 2010 By 11 Comments
…system and how data was lost: MySQL had a dedicated partition on…types and sure enough InnoDB is not one of the supported files. What…what if tables don’t have any text columns at all? Then, you read further. GNU grep won’t match binary strings… 1. There was this rather big table with integer and enum …
