… 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 this blog: UPDATE table SET column=CONVERT…; And it.. Does nothing. £ sign stays the same, nothing changes. Server version: 5.1.61-0ubuntu0.11.10.1
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But ….commanual server_idblogpercona.commanual shared_memoryblogpercona.commanual shared_memory_base_nameblogpercona.commanual show_slave_auth_infoblogpercona.commanual skip_character_set_client_…
Post: Converting Character Sets
March 17, 2009 By 16 Comments
… the entire database and re-importing it with the appropriate server & client character sets. This is a three-step process, where one must… –database=database [options] Options: –askpass Prompt for a MySQL password –charset The target character set to convert to –collate The target collation to…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… is that nested-loop joins on large data sets are very expensive. If MySQL supported sort-merge or hash joins, you…. Use the smallest data types you can, the simplest character sets you can, and watch out for NULLable columns. Use… point: Use InnoDB Assuming that you will use the stock MySQL server, InnoDB is usually your best bet. (Actually, XtraDB might be…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…not be in date_id order’; /*!40101 SET character_set_client = @saved_cs_client */; CREATE TABLE `dim_flight` … from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime… shard1 called “/tmp/servers.txt” and run the following commands: $ cat servers.txt | grep “10…
Post: MySQL Installation and upgrade scripts.
May 21, 2007 By 3 Comments
… as default character set together not to mention infamous timestamp format change which forced to change a lot of applications. MySQL 5.0… even get server logs created because SELinux restricts console output as MySQL changes name to “mysql“. Come On, as I remember MySQL And Redhat…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 139 Comments
…_buffer_size=950M character-set-server=utf8 default-collation=utf8_unicode_ci set-variable=max_connections=1500 log_slow_queries=/var/log/mysql-slow.log… over 30 tables and we needed referential integrity and such, MySQL was a pathetic “option”. Yes 5.x has included triggers…. Just my experience. I know some big websites are using MySQL, but we had neither the budget to throw all that…
Comment: Why MySQL could be slow with large tables ?
March 12, 2007 By 139 Comments
…the more rows were retrieved. Probably, the server is reaching I/O limits… I … experience with table size this large ? Is MySQL able to handle tables (MyIsam) this large ?…`TITLE` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default ”, `DESCRIPTION` text character set utf8 …
Comment: 7 Reasons why MySQL Quality will never be the same
December 11, 2008 By 15 Comments
… in MySQL 4.1 were Subselects, Prepared Statements and Character Sets. All they were not done by Monty and these were changes which MySQL… bugs with repeated execution etc. Finally character sets required changes across all parts of the server and also are generally quite tricky in…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
I am a newbie to MySQL and am not getting the high insert throughput as in … [mysql] 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…
