… CHARACTER SET utf8; Does nothing except changes table/column encodings, but no actual content changes. So.. After this mysql thinks my table is utf8… SET column=CONVERT(CONVERT(column USING binary) USING utf8) WHERE id=123; And it.. Does nothing. £ sign stays the same, nothing changes. Server…
Post: Converting Character Sets
March 17, 2009 By 16 Comments
… database (or set of tables) to a target character set and collation. Approach #1: ALTER TABLE `t1` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; Take… the entire database and re-importing it with the appropriate server & client character sets. This is a three-step process, where one must…
Comment: Why MySQL could be slow with large tables ?
March 12, 2007 By 139 Comments
…query took longer the more rows were retrieved. Probably, the server is reaching I/O limits… I played with some buffer…auto_increment, `STRING` varchar(100) character set utf8 collate utf8_unicode_ci NOT NULL default ”, `URL` varchar(230) character set utf8 collate utf8_unicode_ci NOT NULL default…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
… wait_timeout=15 max_allowed_packet=64M default-collation=utf8_unicode_ci default-character-set=utf8 default-storage-engine=InnoDB bulk_insert_buffer_size…/mysqld.log pid-file=/var/run/mysqld/mysqld.pid The server (on amazon) has 7Go memory: [root@dom*************** log]# free -m…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 139 Comments
… thread_concurrency=4 myisam_sort_buffer_size=950M character-set-server=utf8 default-collation=utf8_unicode_ci set-variable=max_connections=1500 log_slow_queries=/var…
Comment: Fixing column encoding mess in MySQL
January 26, 2011 By 32 Comments
… is utf8, the original data we imported may have been utf-8, the tables were MyISAM – it came out of Sql Server…. Searching everywhere, I have found nothing that tells me what character set encoding that is, and I’ve tried many. When it… upside-down exclamation marks and “section” glyphs, etc. And some characters look like „« (double-comma, double-left-angle-brackets…
Post: MySQL Installation and upgrade scripts.
May 21, 2007 By 3 Comments
… you could screw your data, for example by specifying utf8 as default character set together not to mention infamous timestamp format change which… about the problems Upgrade Script fails to shut down MySQL Server. Obviously nothing can work without this one. Upgrade Script Removes…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 28 Comments
…fifo. Every million lines, the script prints an EOF character to the fifo, closes it and removes it, …utf8 Here’s the result of loading the entire 4GB file in one chunk: time mysql -e “set foreign_key_checks=0; set… to try this on an I/O-bound server and see what the performance impact is, especially …
