… seen those problems with UUID‘s in MySQL when stored as text. Ideally, MySQL would have a UUID column type to store the values… and come up with a case-sensitive 22-byte UUID representation (VTIW7xOgReOGrL3vMRjm4Q, for example). The performance increase was enormous, and the overhead…
Post: Using CHAR keys for joins, how much is the overhead ?
June 18, 2007 By 18 Comments
… 2. row *************************** id: 1 select_type: SIMPLE table: t2 type: ref possible_keys: j key:… expected as MyISAM uses key compression for varchar columns so random key lookups become…reason for this test was – latin1 encoding is enough for most character based keys – uuid…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID…# clustercheck HTTP/1.1 200 OK Content-Type: Content-Type: text/plain Node is running. We will … is running. If you look at Cur column under Session, you can see, that c1 …
Post: Thinking about running OPTIMIZE on your Innodb Table ? Stop!
December 9, 2010 By 18 Comments
…for large indexes which would get inserts in very random order, such as indexes on UUID column… | Table | Op | Msg_type | Msg_text | +——–+———-+———-+——————————————————————-+ | test.a…
