Issue Bug Closed

#77452Database analyzer and collation utf8mb4_unicode_ci DROP KEY / ADD KEY

Dominik Steinborn 08/09/16, 11:59 updated 09/02/16, 10:05

Description

The database analyzer wants to drop and readd table keys if the database collation is set to utf8mb4_unicode_ci.

Configuration in my.cnf of MySQL:

[client]
default-character-set = utf8mb4

[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

[mysql]
default-character-set = utf8mb4

Messages from database analyzer:

ALTER TABLE sys_file_processedfile DROP KEY combined_1;
ALTER TABLE sys_file_processedfile ADD KEY combined_1 (original,task_type,configurationsha1);
ALTER TABLE sys_file_processedfile DROP KEY identifier;
ALTER TABLE sys_file_processedfile ADD KEY identifier (storage,identifier(199));
ALTER TABLE sys_history DROP KEY recordident_1;
ALTER TABLE sys_history ADD KEY recordident_1 (tablename,recuid);
ALTER TABLE sys_history DROP KEY recordident_2;
ALTER TABLE sys_history ADD KEY recordident_2 (tablename,tstamp);
ALTER TABLE sys_refindex DROP KEY lookup_rec;
ALTER TABLE sys_refindex ADD KEY lookup_rec (tablename,recuid);
ALTER TABLE sys_refindex DROP KEY lookup_uid;
ALTER TABLE sys_refindex ADD KEY lookup_uid (ref_table,ref_uid);
ALTER TABLE sys_refindex DROP KEY lookup_string;
ALTER TABLE sys_refindex ADD KEY lookup_string (ref_string);
ALTER TABLE fe_users DROP KEY parent;
ALTER TABLE fe_users ADD KEY parent (pid,username);
ALTER TABLE fe_users DROP KEY username;
ALTER TABLE fe_users ADD KEY username (username);
ALTER TABLE sys_domain DROP KEY getSysDomain;
ALTER TABLE sys_domain ADD KEY getSysDomain (redirectTo,hidden);
ALTER TABLE tx_realurl_uniqalias DROP KEY tablename;
ALTER TABLE tx_realurl_uniqalias ADD KEY tablename (tablename);
ALTER TABLE cf_cache_hash DROP KEY cache_id;
ALTER TABLE cf_cache_hash ADD KEY cache_id (identifier,expires);
ALTER TABLE cf_cache_hash_tags DROP KEY cache_id;
ALTER TABLE cf_cache_hash_tags ADD KEY cache_id (identifier);
ALTER TABLE cf_cache_hash_tags DROP KEY cache_tag;
ALTER TABLE cf_cache_hash_tags ADD KEY cache_tag (tag);
ALTER TABLE cf_cache_pages DROP KEY cache_id;
ALTER TABLE cf_cache_pages ADD KEY cache_id (identifier,expires);
ALTER TABLE cf_cache_pages_tags DROP KEY cache_id;
ALTER TABLE cf_cache_pages_tags ADD KEY cache_id (identifier);
ALTER TABLE cf_cache_pages_tags DROP KEY cache_tag;
ALTER TABLE cf_cache_pages_tags ADD KEY cache_tag (tag);
ALTER TABLE cf_cache_pagesection DROP KEY cache_id;
ALTER TABLE cf_cache_pagesection ADD KEY cache_id (identifier,expires);
ALTER TABLE cf_cache_pagesection_tags DROP KEY cache_id;
ALTER TABLE cf_cache_pagesection_tags ADD KEY cache_id (identifier);
ALTER TABLE cf_cache_pagesection_tags DROP KEY cache_tag;
ALTER TABLE cf_cache_pagesection_tags ADD KEY cache_tag (tag);
ALTER TABLE cf_cache_rootline DROP KEY cache_id;
ALTER TABLE cf_cache_rootline ADD KEY cache_id (identifier,expires);
ALTER TABLE cf_cache_rootline_tags DROP KEY cache_id;
ALTER TABLE cf_cache_rootline_tags ADD KEY cache_id (identifier);
ALTER TABLE cf_cache_rootline_tags DROP KEY cache_tag;
ALTER TABLE cf_cache_rootline_tags ADD KEY cache_tag (tag);
ALTER TABLE cf_cache_imagesizes DROP KEY cache_id;
ALTER TABLE cf_cache_imagesizes ADD KEY cache_id (identifier,expires);
ALTER TABLE cf_cache_imagesizes_tags DROP KEY cache_id;
ALTER TABLE cf_cache_imagesizes_tags ADD KEY cache_id (identifier);
ALTER TABLE cf_cache_imagesizes_tags DROP KEY cache_tag;
ALTER TABLE cf_cache_imagesizes_tags ADD KEY cache_tag (tag);
ALTER TABLE cf_extbase_object DROP KEY cache_id;
ALTER TABLE cf_extbase_object ADD KEY cache_id (identifier,expires);
ALTER TABLE cf_extbase_object_tags DROP KEY cache_id;
ALTER TABLE cf_extbase_object_tags ADD KEY cache_id (identifier);
ALTER TABLE cf_extbase_object_tags DROP KEY cache_tag;
ALTER TABLE cf_extbase_object_tags ADD KEY cache_tag (tag);
ALTER TABLE cf_extbase_reflection DROP KEY cache_id;
ALTER TABLE cf_extbase_reflection ADD KEY cache_id (identifier,expires);
ALTER TABLE cf_extbase_reflection_tags DROP KEY cache_id;
ALTER TABLE cf_extbase_reflection_tags ADD KEY cache_id (identifier);
ALTER TABLE cf_extbase_reflection_tags DROP KEY cache_tag;
ALTER TABLE cf_extbase_reflection_tags ADD KEY cache_tag (tag);
ALTER TABLE cf_extbase_typo3dbbackend_tablecolumns DROP KEY cache_id;
ALTER TABLE cf_extbase_typo3dbbackend_tablecolumns ADD KEY cache_id (identifier,expires);
ALTER TABLE cf_extbase_typo3dbbackend_tablecolumns_tags DROP KEY cache_id;
ALTER TABLE cf_extbase_typo3dbbackend_tablecolumns_tags ADD KEY cache_id (identifier);
ALTER TABLE cf_extbase_typo3dbbackend_tablecolumns_tags DROP KEY cache_tag;
ALTER TABLE cf_extbase_typo3dbbackend_tablecolumns_tags ADD KEY cache_tag (tag);
ALTER TABLE cf_extbase_typo3dbbackend_queries DROP KEY cache_id;
ALTER TABLE cf_extbase_typo3dbbackend_queries ADD KEY cache_id (identifier,expires);
ALTER TABLE cf_extbase_typo3dbbackend_queries_tags DROP KEY cache_id;
ALTER TABLE cf_extbase_typo3dbbackend_queries_tags ADD KEY cache_id (identifier);
ALTER TABLE cf_extbase_typo3dbbackend_queries_tags DROP KEY cache_tag;
ALTER TABLE cf_extbase_typo3dbbackend_queries_tags ADD KEY cache_tag (tag);
ALTER TABLE cf_extbase_datamapfactory_datamap DROP KEY cache_id;
ALTER TABLE cf_extbase_datamapfactory_datamap ADD KEY cache_id (identifier,expires);
ALTER TABLE cf_extbase_datamapfactory_datamap_tags DROP KEY cache_id;
ALTER TABLE cf_extbase_datamapfactory_datamap_tags ADD KEY cache_id (identifier);
ALTER TABLE cf_extbase_datamapfactory_datamap_tags DROP KEY cache_tag;
ALTER TABLE cf_extbase_datamapfactory_datamap_tags ADD KEY cache_tag (tag);

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.