Ronald Bradford ronaldbradford

This is an adaption of the Northwind sample database that can operate with AWS RDS and the Linux sqlcmd command.

Usage:

sqlcmd -S ${INSTANCE_ENDPOINT} -U ${DB_USER} -P ${DB_PASSWORD} -l 2 -i instnwnd.sql

See wesql/wesql#48

These bash scripts do the smallest amount of work possible to collect simple MySQL metrics and running SQL queries of a running system for subsequent analysis. These scripts include:

collect-mysql-status Snapshot of Status, ProcessList and supporting information for 60 seconds
sample-mysql-queries SQL sampling (brute force approach) for approximately 20 seconds

These scripts are designed to be executed on a Linux host, and require the mysql client to be installed, and MySQL credentials to run SQL placed in the $HOME/.my.cnf file.

NOTE: The output of information of SQL statements may include PII information. It is important data is reviewed and masked.

An experiment to trigger the "Range optimization was not done for this query" Warning

Warning (Code 3170): Memory capacity of 8388608 bytes for 'range_optimizer_max_mem_size' exceeded. Range optimization was not done for this query.

This was produced with 1M rows of data.

> SELECT COUNT(*) FROM sysbench.filler2;   # Will match total number of events

Reported as https://bugs.mysql.com/bug.php?id=115085

Create Table
Load Table
Query with NULL
Query with an array with values
Query with empty array [] PROBLEM

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

	<!DOCTYPE html>
	<!--[if lt IE 7]> <html class="no-js ie6 oldie" lang="en-US"> <![endif]-->
	<!--[if IE 7]> <html class="no-js ie7 oldie" lang="en-US"> <![endif]-->
	<!--[if IE 8]> <html class="no-js ie8 oldie" lang="en-US"> <![endif]-->
	<!--[if gt IE 8]><!--> <html class="no-js" lang="en-US"> <!--<![endif]-->
	<head>


	<title>ios.chat.openai.com \| 522: Connection timed out</title>
	<meta charset="UTF-8" />

	Reverse Holofoil I Need from Obsidian Flames (OBS)

	#30 - Entei
	#138 - Malamar
	#154 - Varoom
	#180 - Lechonk
	#181 - Lechonk
	#184 - Oinkologne
	#185 - Flamigo
	#193 - Poppy

	import csv
	import sys

	# Function to check if a value is numeric
	def is_numeric(value):
	try:
	int(value)
	return True
	except ValueError:
	return False

	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();