MySQL 8 Database character_set is different to default instance character_set

[Udara Ratnayake]

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