Discover gists

MySQL

Getting started

Update!

This gist is out of date and I can no longer help much, as I got rid of my Mac.

Please visit T2 Linux website for more and better information:

Acknowledgements

This gist is just a compilation of the hard work that others have put in. I'm not a software developer, so if there are any mistakes or better ways of doing things, I'd appreciate any suggestions. Here's a list of the real heroes who made this possible:

Chat GPT "DAN" (and other "Jailbreaks")

	#!/usr/bin/env python3

	"""
	Calculates various parameters for the InnoDB buffer pool based on a simple input.

	The InnoDB engine is extremely strict about how its buffer pool can be sized.
	Ref: https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_buffer_pool_chunk_size
	Other than size restrictions (which are unlikely to be violated in normal practice), there are
	complicated relationships between the three main variables that must be met, plus some
	best practices to be observed. Getting these three correct can be challenging, hence this calculator.

	server {
	listen 80 default_server;
	listen [::]:80 default_server;
	server_name _;
	root /var/www;
	location /api/endpoint {
	default_type application/json;
	index apiResponse.json;
	alias /var/www/;
	}


	" _ _ "
	" _ /\|\| . . \|\|\ _ "
	" ( } \\|\|D ' ' ' C\|\|/ { % "
	" \| /\__,=_[_] ' . . ' [_]_=,__/\ \|"
	" \|_\_ \|----\| \|----\| _/_\|"
	" \| \|/ \| \| \| \| \\| \|"
	" \| /_ \| \| \| \| _\ \|"

	It is all fun and games until someone gets hacked!

	{
	"estados": [
	{
	"sigla": "AC",
	"nome": "Acre",
	"cidades": [
	"Acrelândia",
	"Assis Brasil",
	"Brasiléia",
	"Bujari",

	# Compiled source #
	###################
	*.com
	*.class
	*.dll
	*.exe
	*.o
	*.so

	# Packages #