Ronald Bradford ronaldbradford

	Abbreviation	Set Name
	MEE	Mega Evolution Energy
	MEG	Mega Evolution
	MEP	Mega Evolution Promos
	WHT	White Flare
	BLK	Black Bolt
	DRI	Destined Rivals
	JTG	Journey Together
	PRE	Prismatic Evolutions
	SSP	Surging Sparks

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

	Conkeldurr BLK Black Bolt https://limitlesstcg.com/cards/BLK/127
	Conkeldurr BLK Black Bolt https://limitlesstcg.com/cards/BLK/49
	Escavalier BLK Black Bolt https://limitlesstcg.com/cards/BLK/138
	Escavalier BLK Black Bolt https://limitlesstcg.com/cards/BLK/60
	Golurk BLK Black Bolt https://limitlesstcg.com/cards/BLK/123
	Golurk BLK Black Bolt https://limitlesstcg.com/cards/BLK/43
	Munna BLK Black Bolt https://limitlesstcg.com/cards/BLK/116
	Munna BLK Black Bolt https://limitlesstcg.com/cards/BLK/35
	Serperior BLK Black Bolt https://limitlesstcg.com/cards/BLK/156
	Serperior BLK Black Bolt https://limitlesstcg.com/cards/BLK/164

	Pokémon: 19
	3 Budew PRE 4
	4 Duskull SFA 18
	3 Dusclops SFA 19
	4 Dusknoir SFA 20
	2 Bloodmoon Ursaluna ex PRE 168
	2 Latias ex SSP 76
	1 Fezandipiti ex SFA 38

	Trainer: 39

	<!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
	#154 - Varoom
	#180 - Lechonk
	#181 - Lechonk
	#184 - Oinkologne
	#193 - Poppy
	#195 - Team Star Grunt

	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