…Com_show_charsetsblogpercona.commanual Com_show_collationsblogpercona.commanual Com_show_column_typesblogpercona.commanual Com_show_contributorsblogpercona.commanual Com_show_create_dbblogpercona.commanual Com_show_create_eventblogpercona.commanual Com_show_create_funcblogpercona.commanual Com_show…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…’ ‘Com_show_binlogs’, ’0′ ‘Com_show_charsets’, ’2′ ‘Com_show_collations‘, ’176788′ ‘Com_show_column_types’, ’0′ ‘Com_show_create_db’, ’8′ ‘Com_show_create_table’, ’2661′ ‘Com_show_databases’, ’93′ ‘Com_show_errors’, ’0′ ‘Com_show_fields’, ’4260′ ‘Com_show_grants’, ’0′ ‘Com_show…
Comment: Fixing column encoding mess in MySQL
January 29, 2008 By 32 Comments
… latin1 with collation as latin1_swedish_ci.. But as I had to add new field to the system to show Chinese info… latin1_swedish_ci and chinese colums as as UTF-8, collation UTF9_general_ci Database is stored on local server (intra….. they are welcome.. Thanks in advance.. Mohnkhan http://www.mohitech.com
Post: When EXPLAIN estimates can go wrong!
October 13, 2011 By 7 Comments
… that I used for the test: mysql [localhost] {msandbox} (foo2) > show create table test_estimate \G *************************** 1. row *************************** Table: test_estimate…`), KEY `type_created` (`type`,`created`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci First I did a test for a… http://bugs.mysql.com/bug.php?id=53761 and was indeed fixed in 5.5 as my tests show. Vasil Dimov goes…
