Joseph Bolus josephbolus

How to use:

jbolus@sandbox:/tmp$ chmod +x mysql-conf-optimizer.sh
jbolus@sandbox:/tmp$ ./mysql-conf-optimizer.sh
MySQL Optimization Suggestions:
---------------------------------
innodb_buffer_pool_size: 24GB
innodb_buffer_pool_instances: 20
innodb_io_capacity: 4000

Troubleshooting High CPU in MySQL

tags: `linux` `dba` `mysql`

Overview

With MySQL 5.7, the PERFORMANCE_SCHEMA.THREADS table added THREAD_OS_ID. This column helps identify sessions consuming high CPU resources, especially when one query overloads a CPU core.

To troubleshoot, use pidstat from the sysstat package. The -t option shows thread-level usage, and -p with the MySQL process ID filters results to MySQL threads:

This is more in the "hack" category, but here is a solution for bookmarking directories[1] that I am quite fond of:

mkdir -p ~/.marks/
export CDPATH=.:~/.marks/
function mark { ln -sr "$(pwd)" ~/.marks/"$1"; }

Then:

	#!/bin/bash
	# https://docs.rockylinux.org/guides/interoperability/import_rocky_to_wsl/
	sudo dnf upgrade --refresh
	dnf upgrade --refresh
	sudo
	dnf install -y nano mc passwd sudo dnf-plugin-config-manager wget dnf-plugins-core tree dos2unix epel-release NetworkManager iproute
	su root
	sudo mc
	ls
	sudo dnf config-manager --set-enabled crb

	#!/bin/bash
	currentAttempt=0
	totalAttempts=10
	delay=15

	while [ $currentAttempt -lt $totalAttempts ]
	do
	currentAttempt=$(( $currentAttempt + 1 ))

	echo "Attempt $currentAttempt of $totalAttempts..."

	# This file contains pin mappings for the Creality "v4.2.7" board. To
	# use this config, during "make menuconfig" select the STM32F103 with
	# a "28KiB bootloader" and serial (on USART1 PA10/PA9) communication.

	# If you prefer a direct serial connection, in "make menuconfig"
	# select "Enable extra low-level configuration options" and select
	# serial (on USART3 PB11/PB10), which is broken out on the 10 pin IDC
	# cable used for the LCD module as follows:
	# 3: Tx, 4: Rx, 9: GND, 10: VCC

	#!/bin/sh

	# Help message
	show_help() {
	echo
	echo "Convert PDFs to make them look like they have been scanned"
	echo "Example: $0 file.pdf"
	}

	# Check if the provided argument is not empty

	/* Casual stab at modifying the Bookstack main theme using the Dracula color scheme. Download and use at your own risk. */
	/* https://github.com/domainzero/bookstack-dark-theme */
	/* optional */
	/* uppercase titles */
	.page-content h1{text-transform:uppercase}
	h1.break-text{text-transform:uppercase}


	/* Dracula stuff */
	/* background */

	#!/bin/bash

	# Exit immediately if a command exits with a non-zero status
	set -e

	# Variables
	zellij_version="0.40.1"
	btop_version="1.3.2"

	zellij_file="zellij-${zellij_version}.tar.gz"

	# Redis configuration file example.
	#
	# Note that in order to read the configuration file, Redis must be
	# started with the file path as first argument:
	#
	# ./redis-server /path/to/redis.conf

	# Note on units: when memory size is needed, it is possible to specify
	# it in the usual form of 1k 5GB 4M and so forth:
	#

Joseph Bolus josephbolus

Troubleshooting High CPU in MySQL

tags: linux dba mysql

Overview

tags: `linux` `dba` `mysql`