…Percona Live asked about the profile results when using prepared statements and I’m just getting …cur_search_to_nth_level 167012.0568row_sel_convert_mysql_key_to_innobase – Most CPU time …::optimize() 101402.3261my_wc_mb_latin1 71521.6407my_utf8_uni 70921.6269Protocol::send_fields(List*, unsigned int…
Comment: Converting Character Sets
March 18, 2009 By 22 Comments
… simple MODIFY can convert everything. 2. If the columns are declared as latin1 but the data are stored in utf8. This is quite common for applications created with MySQL < 4.1 or for applications which does not use SET CHARACTER SET or SET NAMES. A simple MODIFY would mangle the data and conversion to binary and then to utf8…
Comment: Converting Character Sets
March 17, 2009 By 22 Comments
… it, so you can still tailor it using your favorite PERL/awk/python script. Converting an entire table is undesired, in my opinion, since, in addition to said issue, it converts all columns in that table. What if I have a… md5 shcecksum? I wouldn’t that to grow to 96 UTF8 bytes.
Post: Innodb row size limitation
April 7, 2011 By 12 Comments
… possible that you hit this error after converting from a native language character set to utf8, as it can increase the size…, does have other negative impact, as it prevents you from using SQL operators/functions directly on the individual fields you want… all. Of course, these approaches can be combined. For example, using the single BLOB field with COMPRESS/UNCOMPRESS can yield great…
Post: What exactly is read_rnd_buffer_size
July 24, 2007 By 4 Comments
… a sort, when reading rows in sorted order. If you use many queries with ORDER BY, upping this can improve performance… is used and the fields which are being length can be converted to fixed size (basically everything but BLOB/TEXT) MySQL can use… of columns or there are long VARCHAR columns used – it takes only couple of UTF8 VARCHAR(255) to create a row which…
Comment: Converting Character Sets
December 30, 2009 By 22 Comments
While the general information in the article is useful, there’s 2 issues I’m spotting (since I recently … text into the latin1 column, part of legacy MySQL 4 using latin1 as the default. While the text stores and can… would assume MySQL is going to literally try to convert from latin1 to utf8, and in this case since the text isn…
