…Now you insert some test data into it: mysql> INSERT INTO example -> VALUES ( ->Â Â NULL,…all multi-byte characters into a VARCHAR(500) column, that value will …this error after converting from a native language character set to utf8, as …pages are allocated 1 page at a time until you reach 32 pages. …
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
March 29, 2012 By 29 Comments
… helpful article! It is just what I needed to convert a 330GB MyISAM database to InnoDB with reasonable effort. I have tested your… seems it doesn’t handle binary data correctly, you need to add these lines: if (length($line) > 1) { while (substr($line… have (160GB , varchar columns). Also, rather then time‘ing the mysql commands in the loop (second shell), I added –show-warnings to the command…
Comment: Long PRIMARY KEY for Innodb tables
April 10, 2009 By 8 Comments
…InnoDB table with a long varchar primary key, and when I do a “select …1) this table has previously been converted to MyISAM and back to InnoDB, but has been modified much…pull about 300,000 ids at a time. If they’re not in order, I… find any way to assert an index’s prefix length on MySQL 5.1. It does…
Post: Beware of MyISAM Key Cache mutex contention
August 12, 2008 By 10 Comments
…time of key_block being copied from key_cache to the thread local space. Happily MyISAM allows you to…converted with this option. This is of course because some of indexes on the tables were on CHAR/VARCHAR… such changes we got insert rate to MySQL close to 200K rows/sec using standard multi value…
