… -p -i -e ‘s/ENGINE=InnoDB/ENGINE=MyISAM/g’ schema.sql root@domU:/mnt/tables# cat schema.sql | mysql -u root test The…_TABLENAME.ibd /var/lib/mysql/recover/ chown mysql.mysql /var/lib/mysql/recover/$CURRENT_TABLENAME.ibd sleep 1 echo “importing tablespace” mysql -u root -e… a hard time. I pulled in Aleksandr and he basically reversed engineer the table structure and found that the schema the customer…
Post: MySQL Error control changes
February 19, 2007 By 4 Comments
… one case however reverse change was done – in regards to storage engine initialization. Previously if you start MySQL and Innodb storage engine fails to initialize (ie you resized log file but forgot to delete old ones) MySQL Server simply would not start. In recent MySQL 5.0 series however it will continue loading and simply have Innodb storage engine…
Comment: Duplicate indexes and redundant indexes
August 17, 2006 By 38 Comments
… PEAR::MDB2 manager module which supports pre-information-schema mysql versions and supports reverse engineering indexes and constraints. So by simply calling a…
Post: Descending indexing and loose index scan
May 9, 2006 By 6 Comments
… – these are features MySQL should get for all storage engines at some point. Descending indexes – This is something MySQL does not have at… in reverse order and it will well be. This is how MySQL will optimize indexed ORDER BY col DESC queries for example. Reverse… down a bit. Or some storage engines, such as MyISAM (for packed indexes) may have reverse scan being much slower than forward…
Comment: Full text search for all MySQL Storage Engines
June 27, 2006 By 37 Comments
… for mysql (I assume this means that the sphinx index can be created directly from within mysql just as with mysql own fulltext engine… for my case (fulltext search engine for a forum). What I have done is to mix reversed index with vectorspace model which… reversed index and vectorspace model” ? 
Also, does the implementation of sphinx as plugin for mysql 5.1 mean that mysqls own fulltext engine…
Post: To pack or not to pack - MyISAM Key compression
May 13, 2006 By 3 Comments
… be treated differently. For uncompressed index blocks MySQL can do binary search inside the page -…NULL default ”, KEY `c` (`c`), KEY `id` (`id`) ) ENGINE=MyISAM Index size: PACK_KEYS=DEFAULT – 1550K… uncompression than to traverse large memory areas. Reverse index scan performance got some 8 times …
Comment: Full text search for all MySQL Storage Engines
June 28, 2006 By 37 Comments
… the mysql codes needed to store these bytes). If you have an average of 100 words per docid this means that reversed… process, group by, order by and so forth until the engine can spit out an answer to the client (unless you… avoid hitting the query cache during tests): Reversed index without cheating: 24.0 seconds Reversed index with cheating (limit each word internally…
Post: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 93 Comments
…) but MySQL can’t do it at this point. Workaround which can be currently used is separate column which holds reverse values, so you can do ORDER BY col1, col2_reverse instead. Beware of large LIMIT… not go further than 10 page in results, however Search Engine Bots may very well do so. I’ve seen bots…
Comment: Cache Performance Comparison
August 10, 2006 By 73 Comments
…might compensate for the overhead that storing in mysql otherwise might be… Something I would like …table with singlewords? In my case my search engine has extracted all unique searchwords into its … searchword LIKE ‘%abc%’” ? I tried to create a reversed table but that will just boost “LIKE ‘%abc’”…
