June 19, 2013

Post: Converting Character Sets

March 17, 2009 By 22 Comments

…-> ) ENGINE=MyISAM DEFAULT CHARSET=latin1; Query OK, 0 rows affected (0.02 sec) mysql> ALTER TABLE `t1` CONVERT TO CHARACTER SET utf8 COLLATE …#1: ALTER TABLE `t1` DEFAULT CHARSET=utf8, MODIFY COLUMN `c1` text CHARACTER SET utf8; This approach will both change the default character set for the table …

Filed Under: Insight for Developers Tagged With: , ,

Post: Ultimate MySQL variable and status reference list

January 8, 2011 By 4 Comments

…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…

Filed Under: Insight for DBAs, MySQL

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… must use the latin1 character set. mysql: CREATE TABLE innodb_ft_list2 ( value VARCHAR(18) NOT NULL DEFAULT ”) ENGINE=InnoDB DEFAULT CHARSET=latin1; Query OK… be; do our InnoDB results change? No, they are exactly the same, although the scores did change slightly. What about a Boolean…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: MySQL Upgrade Webinar Questions Followup

June 28, 2012 By 7 Comments

… Upgrading to MySQL 5.5 do we really need all tables changed to Innodb and character set set to utf8? No. MySQL 5…default. Regarding setting character set to utf8 – this is not needed as MySQL 5.5 continues to support various character sets same as previous MySQL versions. Moreover utf8 character set…

Filed Under: Insight for DBAs, MySQL

Post: MySQL 5.5 and MySQL 5.6 default variable values differences

February 21, 2013 By 8 Comments

…_10/data/mysq | | CHARACTER_SETS_DIR | /mnt/nfs/dist/mysql-5.5.30-linux2.6-x86_ | /mnt/nfs/dist/mysql-5.6.10-linux… default. Very welcome change ! thread_cache_size is enabled by default, though I wonder why default value is 9. In any case very welcome change…=on 1 row in set (0.00 sec) Summary: MySQL 5.6 comes with quite a few changes to default configurations which are mostly…

Filed Under: Insight for DBAs, MySQL Tagged With: , , ,

Post: MySQL Installation and upgrade scripts.

May 21, 2007 By 3 Comments

… MySQL 4.1 and later more caution is required because you could screw your data, for example by specifying 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…

Filed Under: Insight for DBAs Tagged With: ,

Post: MySQL Backup tools used by Percona Remote DBA for MySQL

March 13, 2013 By 8 Comments

…loop through each DB write out ALTER DATABASE DEFAULT CHARACTER SET to the schema file, putting in …, long term backups Decompressing Percona XtraBackup for MySQL  in parallel using all your resources available … by file, for files that don’t change they can be easily hardlinked to typically…

Filed Under: Cloud and NoSQL, Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , , , , ,

Post: Shard-Query EC2 images available

May 11, 2011 By 2 Comments

…SET character_set_client = @saved_cs_client */; CREATE TABLE `dim_flight` ( `UniqueCarrier` char(7) DEFAULT NULL, `AirlineID` int(11) DEFAULT NULL, `Carrier` char(2) DEFAULT… DEFAULT CHARSET=latin1 COMMENT=’Contains all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql…

Filed Under: MySQL

Comment: Why MySQL could be slow with large tables ?

December 17, 2012 By 141 Comments

…mysql/mysql.sock user=mysql init_connect=’SET collation_connection = utf8_general_ci; SET NAMES utf8;’ default-character-set=utf8 character-set-server=utf8 collation-server=utf8_general_ci [client] default-character-set…

Filed Under: Insight for DBAs Tagged With: ,

Post: MySQL Indexing Best Practices: Webinar Questions Followup

August 16, 2012 By 4 Comments

…bigint column containing the crc64, and change the indexing to be on that… because the first 10 or so characters usually are the same). Of …is string comparison in MySQL is case insensitive by default while hash comparison …frequently. The size of this “working set” can greatly depend on application …

Filed Under: Insight for DBAs, MySQL
« Older Posts