MySQL Forums
Forum List  »  Replication

MySQL 8 Database character_set is different to default instance character_set
Posted by: Udara Ratnayake
Date: December 12, 2019 07:20PM

Hi my MYSQL 8 default character_set is "utf8mb4" and collation is utf8mb4_0900_ai_ci.


mysql> SHOW VARIABLES LIKE 'character_set_server'
-> ;
+----------------------+---------+
| Variable_name | Value |
+----------------------+---------+
| character_set_server | utf8mb4 |
+----------------------+---------+
1 row in set (0.00 sec)

mysql> SHOW VARIABLES LIKE 'collation%';
+----------------------+--------------------+
| Variable_name | Value |
+----------------------+--------------------+
| collation_connection | utf8mb4_0900_ai_ci |
| collation_database | utf8mb4_0900_ai_ci |
| collation_server | utf8mb4_0900_ai_ci |
+----------------------+--------------------+






My question is if we have a database with different character set, then , what would be impacted as performance point of view. is that good to have the different DBs on single MySQL instacne. What is best practice . many thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL 8 Database character_set is different to default instance character_set
540
December 12, 2019 07:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.