Skip to content

Instantly share code, notes, and snippets.

View erikngigi's full-sized avatar

Eric Ngigi erikngigi

View GitHub Profile
@erikngigi
erikngigi / bash-colors.md
Created May 28, 2025 12:34 — forked from JBlond/bash-colors.md
The entire table of ANSI color codes.

Regular Colors

Value Color
\e[0;30m Black
\e[0;31m Red
\e[0;32m Green
\e[0;33m Yellow
\e[0;34m Blue
\e[0;35m Purple
@erikngigi
erikngigi / mysql-large-db-import
Created March 12, 2025 11:39 — forked from molotovbliss/mysql-large-db-import
Importing Large DB faster MySQL Settings
Source: https://dba.stackexchange.com/questions/83125/mysql-any-way-to-import-a-huge-32-gb-sql-dump-faster
innodb_buffer_pool_size = 4G
innodb_log_buffer_size = 256M
innodb_log_file_size = 1G
innodb_write_io_threads = 16
innodb_flush_log_at_trx_commit = 0
Why these settings ?
innodb_buffer_pool_size will cache frequently read data