…. MyISAM tables with latin1 encoding. Tried: ALTER TABLE CONVERT TO CHARACTER SET utf8; Does nothing except changes table/column encodings, but no… try the nr2 way mentioned in this blog: UPDATE table SET column=CONVERT(CONVERT(column USING binary) USING utf8) WHERE id…; And it.. Does nothing. £ sign stays the same, nothing changes. Server version: 5.1.61-0ubuntu0.11.10.1
Post: Converting Character Sets
March 17, 2009 By 16 Comments
… a database (or set of tables) to a target character set and collation. Approach #1: ALTER TABLE `t1` CONVERT TO CHARACTER SET utf8 COLLATE utf8… the entire database and re-importing it with the appropriate server & client character sets. This is a three-step process, where one must… CHARSET=utf8, MODIFY COLUMN `c1` text CHARACTER SET utf8; This approach will both change the default character set for the table and target column…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
….commanual character_set_clientblogpercona.commanual character_set_client_handshakeblogpercona.commanual character_set_connectionblogpercona.commanual character_set_databaseblogpercona.commanual character_set_filesystemblogpercona.commanual character_set_resultsblogpercona.commanual character_set…_scanblogpercona.commanual server_idblogpercona.commanual shared_memoryblogpercona.commanual shared_memory_base_nameblogpercona.commanual show_slave_auth_infoblogpercona.commanual skip_character_set_client_handshakeblogpercona…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 139 Comments
…_concurrency=4 myisam_sort_buffer_size=950M character-set-server=utf8 default-collation=utf8_unicode_ci set-variable=max_connections=1500 log_slow_queries…
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…_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, `TITLE` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default ”, `DESCRIPTION` text character set utf8 collate utf8_unicode_ci…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… columns to support these queries. But beware of denormalizing with character data; try to make your rows fixed-length. One reason…. Use the smallest data types you can, the simplest character sets you can, and watch out for NULLable columns. Use… with much less memory, or even with 10-15x fewer servers. Clever application design, and a holistic approach, are absolutely necessary…
Comment: 7 Reasons why MySQL Quality will never be the same
December 11, 2008 By 15 Comments
… features in MySQL 4.1 were Subselects, Prepared Statements and Character Sets. All they were not done by Monty and these were… bugs with repeated execution etc. Finally character sets required changes across all parts of the server and also are generally quite tricky in the cases when you mix collations and use different character sets in the…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
…] default-character-set=latin1 [mysqld] port=3306 basedir=”C:/Program Files/MySQL/MySQL Server 5.0/” datadir=”C:/Program Files/MySQL/MySQL Server 5.0/Data/” default-character-set=latin1 default-storage-engine…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
… file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /usr/local/mysql/data) or # ~/.my.cnf to set user-specific…_packet = 16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
… when I activate some others functionality of my application the server start to respond slowly and the first task which was… max_allowed_packet=64M default-collation=utf8_unicode_ci default-character-set=utf8 default-storage-engine=InnoDB bulk_insert_buffer_size=8M…/mysqld.log pid-file=/var/run/mysqld/mysqld.pid The server (on amazon) has 7Go memory: [root@dom*************** log]# free -m…
