Skip to content

Instantly share code, notes, and snippets.

@GiaCatKhongVinh
GiaCatKhongVinh / my.cnf
Created March 27, 2023 03:51 — forked from kanibaspinar/my.cnf
Mysql My.cnf Optimization - Best Performance For 1000 + Sites Web Server
# Optimized MySQL configuration for cPanel servers by Kani Baspinar - Updated June 2016
#
# The settings provided below are a starting point for a 24GB RAM server with 8 CPU cores.
# If you have less or more resources available you MUST adjust accordingly to save CPU, RAM and disk I/O usage.
# To fine tune these settings for your system, use MySQL DB diagnostics tools like:
# Test your configuration ; https://launchpad.net/mysql-tuning-primer
# or
# http://blog.mysqltuner.com/download/
# Note that if there is NO comment beside a setting, then you don't need to adjust it.
#
@GiaCatKhongVinh
GiaCatKhongVinh / my.cnf
Created March 17, 2021 03:15 — forked from yadvr/my.cnf
Example MySQL my.cnf optimized
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
syslog
@GiaCatKhongVinh
GiaCatKhongVinh / my.cnf
Created March 17, 2021 03:15 — forked from oinume/my.cnf
my.cnf
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
@GiaCatKhongVinh
GiaCatKhongVinh / .env
Created March 17, 2021 03:15 — forked from nicosingh/.env
MySQL cluster using docker
MYSQL_ROOT_PASSWORD=rootpass
Short name Full name
csr       certificatesigningrequests
cs componentstatuses
cm configmaps
ds daemonsets
deploy deployments
ep endpoints
ev events
hpa       horizontalpodautoscalers