…DEFAULT NULL, `MTYPE` int(10) unsigned DEFAULT NULL, `PRTYPE` int(10) unsigned DEFAULT NULL, `LEN` int(10) unsigned DEFAULT NULL, `PREC` int(10) unsigned DEFAULT…(45) CHARACTER SET ‘utf8‘ COLLATE ‘utf8_general_ci’ NOT NULL, `last_name` VARCHAR(45) CHARACTER SET ‘utf8‘ COLLATE ‘utf8_general_ci’ NOT …
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
…=30 wait_timeout=15 max_allowed_packet=64M default-collation=utf8_unicode_ci default-character-set=utf8 default-storage-engine=InnoDB bulk_insert_buffer_size=8M…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 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…
Post: Converting Character Sets
March 17, 2009 By 22 Comments
…) to a target character set and collation. Approach #1: ALTER TABLE `t1` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; Take the following…=MyISAM DEFAULT CHARSET=latin1; Query OK, 0 rows affected (0.02 sec) mysql> ALTER TABLE `t1` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general…
Comment: Why MySQL could be slow with large tables ?
March 12, 2007 By 141 Comments
… set utf8 collate utf8_unicode_ci NOT NULL default ”, `URL` varchar(230) character set utf8 collate utf8_unicode_ci NOT NULL default ”, `LANGUAGE` char(2) NOT NULL default ‘EN…) character set utf8 collate utf8_unicode_ci NOT NULL default ”, `DESCRIPTION` text character set utf8 collate utf8_unicode_ci, `POINTS` decimal(10,2) NOT NULL default ’0.00…
Post: How much space does empty Innodb table take ?
December 16, 2008 By 7 Comments
…` char(100) default NULL, PRIMARY KEY (`i`), KEY `c` (`c`), KEY `c_2` (`c`,`i`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 mysql> show table…-16 20:43:31 Update_time: NULL Check_time: NULL Collation: utf8_general_ci Checksum: NULL Create_options: Comment: InnoDB free: 0…-16 20:58:49 Update_time: NULL Check_time: NULL Collation: utf8_general_ci Checksum: NULL Create_options: Comment: InnoDB free: 4096…
Post: When EXPLAIN estimates can go wrong!
October 13, 2011 By 7 Comments
…) NOT NULL DEFAULT ’0′, `created` timestamp NOT NULL DEFAULT ’0000-00-00 00:00:00′, `type` tinyint(4) NOT NULL DEFAULT ’0′, KEY `id` (`id`), KEY `type_created` (`type`,`created`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci First I…
Post: How much memory Innodb locks really take ?
July 13, 2006 By 11 Comments
… auto_increment, `j` varchar(255) default NULL, PRIMARY KEY (`i`), KEY `j` (`j`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 mysql> show table status like…-12 07:31:51 Update_time: NULL Check_time: NULL Collation: utf8_general_ci Checksum: NULL Create_options: Comment: InnoDB free: 1591296…
Comment: Why MySQL could be slow with large tables ?
November 14, 2008 By 141 Comments
…/day) — I have used a table MyISAM, info from phpmyadmin: Collation utf8_general_ci lenght row 122 row dimension avg 194 byte…/lib/mysql socket = /var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3…
Comment: Using CHAR keys for joins, how much is the overhead ?
June 19, 2007 By 18 Comments
…. Better than 11 seconds but still very slow. I used default collation for latin1 and utf8 character sets.
