… i and j columns to varchar while sticking to utf8 character set which we had as default ? Joining on Char columns completes… this setting does not work any more. The next test I decided to do is to convert Innodb table to latin1 character set… for this test was – latin1 encoding is enough for most character based keys – uuid, sha1/md5 based etc. Latin1 encoding indeed…
Comment: Why MySQL could be slow with large tables ?
March 12, 2007 By 141 Comments
…_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…
Comment: Why MySQL could be slow with large tables ?
December 17, 2012 By 141 Comments
… records only very slow. so please guide me where to set parameters to overcome this issue. my.cnf file contains the…_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=utf8 set…
Comment: Best kept MySQLDump Secret
March 29, 2012 By 13 Comments
… SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `z` ( `n` char(1) DEFAULT ” ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set… (‘a’); /*!40000 ALTER TABLE `z` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; …
Post: Recovery after DROP & CREATE
August 22, 2012 By 1 Comment
… “CREATE TABLE”: DROP TABLE IF EXISTS `actor`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `actor` ( `actor_id…_name`) ) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; If there were no subsequent CREATE…
Post: Common MySQL traps webinar questions followup
January 17, 2013 By 1 Comment
… will take 6 to 8 bytes for a single-byte character set (5 to 7 bytes for the value plus 1 byte… id of the status in the order table. For one character values, the situation is a bit different as both CHAR… value (again as long as you use a 1-byte character set for CHAR). Here CHARs will be more flexible and can…
Post: Innodb row size limitation
April 7, 2011 By 12 Comments
… trailer)/2. For the default page size of 16kb. this sets an ~8000 bytes limit on row size (8126 as reported… values, not the character-size. This means if you insert a 500 character string with all multi-byte characters into a VARCHAR(500… you hit this error after converting from a native language character set to utf8, as it can increase the size dramatically. If…
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… their good share of bugs with repeated execution etc. Finally character sets required changes across all parts of the server and also… in the cases when you mix collations and use different character sets in the application. It took a good time before 4…
Comment: Multiple column index vs multiple indexes
September 8, 2008 By 13 Comments
…_increment, `bname` varchar(100) character set utf8 NOT NULL, `address` varchar(50) character set utf8 default NULL, `city` varchar(30) character set utf8 default NULL, `state…
Post: JOIN Performance & Charsets
October 21, 2008 By 2 Comments
… types as keys for a specific reason. Either way, the character sets used on joined columns can have a significant impact on… rows: 1 Extra: Using where; Using index 2 rows in set, 1 warning (0.00 sec) mysql> SHOW WARNINGS\G *************************** 1. row… is a result of the joined columns being of different character sets. The above query took an average of 4.33 seconds…
