… Repositories). Based on MySQL 5.1.62, including all the bug fixes in it, Percona Server …the mysqlbinlog utility that allows the changing names of the used databases in both Row-Based and …encoded within the BINLOG ‘….’ statement. Release notes for Percona Server 5.1.62-13.3 are available in…
Comment: Fixing column encoding mess in MySQL
March 14, 2012 By 32 Comments
… encoding. Tried: ALTER TABLE CONVERT TO CHARACTER SET utf8; Does nothing except changes table/column encodings, but no actual content changes. So.. After this mysql thinks my table is utf8, I try the nr2 way mentioned in…
Comment: Using CHAR keys for joins, how much is the overhead ?
June 19, 2007 By 18 Comments
… you for ideas. In fact results are very interesting. First about VARBINARY. I compared VARBINARY to using LATIN1 encoding for “normal” join… was complete surprise for me and someone in MySQL may want to profile it in more details. Changing column types from INT to BIGINT…’ve done is changing varchar(10) to varchar(255) in my “short” varchar join tests for Innodb table with utf8 encoding. This caused…
Comment: To UUID or not to UUID ?
April 15, 2008 By 28 Comments
… those problems with UUID’s in MySQL when stored as text. Ideally, MySQL would have a UUID column…change would provide better performance in terms of storage and indexing (a 16-byte column instead of 36). In… I realized the Base64 encoding was inefficient for a 128-bit number. In order to get maximum …
Post: Using CHAR keys for joins, how much is the overhead ?
June 18, 2007 By 18 Comments
… row in set (1.70 sec) Here is explain if someone curious, it did not really change beside key lengths: mysql> explain select… function significantly faster. The reason for this test was – latin1 encoding is enough for most character based keys – uuid, sha1/md5… (I guess any simple encoding) is significantly faster for joins compared to UTF8 These tests were preformed for in memory tables, for…
Comment: Fixing column encoding mess in MySQL
January 26, 2011 By 32 Comments
…MySQL, and may have been converted to utf-8 during that first import. I tried (with a backup, of course) changing…followed by, respectively, the “section” glyph and an umlaut. In the db, I see ¡§ … have found nothing that tells me what character set encoding that is, and I’ve tried many. When it…
Post: To pack or not to pack - MyISAM Key compression
May 13, 2006 By 3 Comments
… index values “aaaaaa” and “aaaaab”. They will be encoded as “aaaaaa”, “b”. The similar compression applies to …For uncompressed index blocks MySQL can do binary search inside the page – kind of jumping in the middle and … 1 values for such key. However it I change it to “key” the size reduces if PACK…
