…TABLE CONVERT TO CHARACTER SET utf8; Does nothing except changes table/column encodings, but no actual content changes. So.. After this mysql thinks my table…SET column=CONVERT(CONVERT(column USING binary) USING utf8) WHERE id=123; And it.. Does nothing. £ sign stays the same, nothing changes. Server…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option ….commanual Com_change_dbblogpercona.commanual Com_change_masterblogpercona….server_idblogpercona.commanual shared_memoryblogpercona.commanual shared_memory_base_nameblogpercona.commanual show_slave_auth_infoblogpercona.commanual skip_character_set…
Post: Converting Character Sets
March 17, 2009 By 16 Comments
…re-importing it with the appropriate server & client character sets. This is a three-step … `c1` text CHARACTER SET utf8; This approach will both change the default character set for the table … Options: –askpass Prompt for a MySQL password –charset The target character set to convert to –collate…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…server-id in my.cnf. You change the server-id interactively, this is an action you should never perform on a slave. “SET GLOBAL server…character in my.cnf that was unvalidating the value and then it was set…server-id are performed on the two slaves (mysql 3 and mysql 4) and the new events (with server…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…the smallest data types you can, the simplest character sets you can, and watch out for NULLable …InnoDB Assuming that you will use the stock MySQL server, InnoDB is usually your best bet. (Actually,…, it can change the lifecycle of your application in advance. What about partitioning in MySQL 5….
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`…data 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
… utf8 as default character set together not to mention infamous timestamp format change which forced to change a lot of applications. MySQL 5.0 added… not 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: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
…set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /usr/local/mysql…in our manual) – # the syntax is: # # CHANGE MASTER TO MASTER_HOST=, MASTER_PORT=, #…_packet = 16M [mysql] no-auto-rehash # Remove the next comment character if you …
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 architecture… of bugs with repeated execution etc. Finally character sets required changes across all parts of the server and also are generally quite tricky in…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… to changes that really require table to be rebuilt – adding/dropping columns or indexes, changing data type, converting data to different character set – MySQL master… reach this point. 5. on monitor: switch masters Once standby servers (only db2 in our case) have caught-up, we are…
