Skip to content

Instantly share code, notes, and snippets.

@TheRatG

TheRatG/dev_mysql.md

Created August 12, 2021 06:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save TheRatG/7167700d2b3ab0ef5d08c8f9eaeac4ef to your computer and use it in GitHub Desktop.
Save TheRatG/7167700d2b3ab0ef5d08c8f9eaeac4ef to your computer and use it in GitHub Desktop.
Download ZIP
Dev mysql
Raw
dev_mysql.md

Mysqld config

/etc/mysql/mysql.conf.d/mysqld.cnf

skip_log_bin = 1

innodb_buffer_pool_size = 6G
innodb_log_buffer_size = 1G
innodb_log_file_size = 2G
innodb_write_io_threads = 28
innodb_flush_log_at_trx_commit = 0
innodb_fast_shutdown = 0
innodb_file_per_table = 1

How to shrink/purge ibdata

https://dba.stackexchange.com/questions/87692/flush-clean-mysql-ib-logfile0-ib-logfile1

mysqladmin shutdown
cd /var/lib/mysql
rm -f ib_logfile*
service mysql start
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment