Warning (Code 3170): Memory capacity of 8388608 bytes for 'range_optimizer_max_mem_size' exceeded. Range optimization was not done for this query.
> SELECT COUNT(*) FROM sysbench.filler2; # Will match total number of events
Warning (Code 3170): Memory capacity of 8388608 bytes for 'range_optimizer_max_mem_size' exceeded. Range optimization was not done for this query.
> SELECT COUNT(*) FROM sysbench.filler2; # Will match total number of events
SELECT 'Start' AS msg, NOW(); | |
SHOW GLOBAL STATUS LIKE 'com_select'; | |
SELECT SLEEP(60 * 1); | |
SELECT '1m' AS msg, NOW(); | |
SHOW GLOBAL STATUS LIKE 'com_select'; | |
SELECT SLEEP(60 * 4); | |
SELECT '5m' AS msg, NOW(); | |
SHOW GLOBAL STATUS LIKE 'com_select'; | |
SELECT SLEEP(60 * 10); | |
SELECT '15m' AS msg, NOW(); |
Reported as https://bugs.mysql.com/bug.php?id=115085
Reproducible using 8.0.34 Docker Container
# https://github.com/openai/whisper
pip install -U openai-whisper
brew install ffmpeg
# https://formulae.brew.sh/formula/youtube-dl. (Deprecated, owner shutdown but still works)
brew install youtube-dl
youtube-dl -x https://youtu.be/Nx-X4hVQGyQ
{ | |
"steps": [ | |
{ | |
"join_preparation": { | |
"select#": 1, | |
"steps": [ | |
{ | |
"expanded_query": "/* select#1 */ select `a`.`country_code` AS `country_code`,`c`.`name` AS `name`,count(0) AS `cnt` from (`airport` `a` join `country` `c` on((`a`.`country_code` = `c`.`country_code`))) group by `a`.`country_code`,`c`.`name` order by count(0) desc limit 10" | |
}, | |
{ |
Use this script to monitor an RDS instance endpoint, RDS proxy endpoint, Route 53 endpoint during any testing or failover operations.
$ watch --differences -n 1 -t "./monitor-mysql-connection.sh"
# Set Computer Name
name | setting | |
-------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
Option | Benefits | Limitions | |
---|---|---|---|
Processlist | Enabled by default. Only captures executing SQL. | Required elevated privileges to view all statements for all users. | |
Performance Schema | Captures executed statements. | Provides additional metrics and aggregrations. Not enabled by default. Very tehnical information. | |
Sys Schema | Extends Performance Schema with highly usable views and objects. | Not enabled by default | |
Slow Query Log | Provides historical log of slow queries. Useful for long term analysis. | Only logs queries that run longer than configured long_query_time. Does not capture additional information at time of query. | |
General Log | Provides historical log of all queries. Very useful for viewing a full statement of sequential SQL statements. | Can impact system performance. Essential for any detailed testing framework. | |
Binary Log | Provides historical log of all write queries. Very useful for per table metrics of write load. | Does not capture SELECT statements. Not always enabled. |