New answers tagged

0 votes

List of characters managed by a collation

CHARACTER SET utf8mb4 in an "encoding". It handles all characters defined by Unicode 9.0.0. There are many COLLATIONs. For example, utf8mb4_icelandic_ci orders characters in a way specific ...
Rick James's user avatar
  • 77.6k
0 votes

List of characters managed by a collation

I'm not an expert in the internals, but looking through the MySQL source I believe the utf8mb4 collations are implemented as compiled code. These collations are derived from data in the MySQL source ...
Bill Karwin's user avatar
  • 14.3k
0 votes

Performance impact when querying without partition key on a partitioned table

(To many questions to fit in a Comment.) I assume that id is not AUTO_INCREMENT? Please provide the query; many details could make a difference. In particular, I cannot answer your "why" ...
Rick James's user avatar
  • 77.6k
0 votes

MySQL master-slave stopped replication no Error on relay log

after 12h brainstorming I fixed the issue Using command SHOW SLAVE STATUS\G I noted 2 values Source_Log_File: node2-bin.000083 and Read_Source_Log_Pos: 865547161 this values means where slave stopped....
awd's user avatar
  • 1
0 votes

Unexplained MySQL memory usage

O Genthe, Your SHOW GLOBAL STATUS report includes threads_connected with a value of just over 100. This query, SELECT 'SLEEPING Ram use', COUNT(*),SUM(time),SUM(memory_used),SUM(max_memory_used) FROM ...
Wilson Hauck's user avatar
  • 1,730
0 votes

Unexplained MySQL memory usage

Analysis of GLOBAL STATUS and VARIABLES: Observations: Version: 8.0.36 32 GB of RAM Uptime = 14:50:16; some GLOBAL STATUS values may not be meaningful yet. 370 QPS The More Important Issues: ...
Rick James's user avatar
  • 77.6k
1 vote
Accepted

Aurora RDS async replication to historical MySQL cluster

For Aurora MySQL or RDS MySQL refer to the official docs in AWS rather than the MySQL manual. Aurora/RDS MySQL doesn't support SUPER privileges hence the issue with FTWRL. Added to mark as answer
jerichorivera's user avatar
1 vote

MySQL Server 8.0 - Increase innodb_buffer_pool_size

There are 3 methods, Method 1: Permanent edit in the config file. Stop the service anyhow. For the Linux distribution is like sudo service mysql stop to stop the running service and prevent any ...
Shrm's user avatar
  • 111
0 votes

How should I troubleshoot a very slow MySQL server droplet?

Rate Per Second = RPS Suggestions to consider for your my.cnf [mysqld] section, innodb_buffer_pool_instances=3 # from 8 you only have 8 cores, leave some for other processes. innodb_lru_scan_depth=...
Wilson Hauck's user avatar
  • 1,730
0 votes
Accepted

MySQL replication status not reporting mysqld.cnf parameters

If anyone ever crosses such an issue, i have found the issues, it was ease to see in the error log and it was because i had these ' ' surrounding my DB names in the config file. Insteand of this ...
Andrei Hristov's user avatar

Top 50 recent answers are included