Mercurial > p > roundup > code
diff .github/workflows/ci-test.yml @ 7489:f0ff7f790c5c
Fix mysql db speedup
Use sudo and sed to append config files lines.
[skip travis]
| author | John Rouillard <rouilj@ieee.org> |
|---|---|
| date | Thu, 15 Jun 2023 14:55:47 -0400 |
| parents | 76d4c3d43258 |
| children | 46248c3ca7af |
line wrap: on
line diff
--- a/.github/workflows/ci-test.yml Thu Jun 15 14:30:35 2023 -0400 +++ b/.github/workflows/ci-test.yml Thu Jun 15 14:55:47 2023 -0400 @@ -124,15 +124,14 @@ #sleep 5 # try to improve performance speed by disabling some ACID # settings and change some layout defaults. - - echo "innodb_flush_log_at_trx_commit = 2" >> /etc/mysql/mysql.conf.d/mysqld.cnf - echo "innodb_file_per_table = OFF" >> /etc/mysql/mysql.conf.d/mysqld.cnf - echo "innodb_doublewrite=OFF" >> /etc/mysql/mysql.conf.d/mysqld.cnf - echo "innodb_fast_shutdown=2" >> /etc/mysql/mysql.conf.d/mysqld.cnf - echo "innodb_log_file_size=1048576" >> /etc/mysql/mysql.conf.d/mysqld.cnf - echo "innodb_flush_method=O_DIRECT" >> /etc/mysql/mysql.conf.d/mysqld.cnf - echo "innodb_log_buffer_size=3M" >> /etc/mysql/mysql.conf.d/mysqld.cnf - echo "innodb_buffer_pool_size=180M" >> /etc/mysql/mysql.conf.d/mysqld.cnf + sudo sed -i -e '$a\innodb_flush_log_at_trx_commit = 2' /etc/mysql/mysql.conf.d/mysqld.cnf + sudo sed -i -e '$a\innodb_file_per_table = OFF' /etc/mysql/mysql.conf.d/mysqld.cnf + sudo sed -i -e '$a\innodb_doublewrite=OFF' /etc/mysql/mysql.conf.d/mysqld.cnf + sudo sed -i -e '$a\innodb_fast_shutdown=2' /etc/mysql/mysql.conf.d/mysqld.cnf + sudo sed -i -e '$a\innodb_log_file_size=1048576' /etc/mysql/mysql.conf.d/mysqld.cnf + sudo sed -i -e '$a\innodb_flush_method=O_DIRECT' /etc/mysql/mysql.conf.d/mysqld.cnf + sudo sed -i -e '$a\innodb_log_buffer_size=3M' /etc/mysql/mysql.conf.d/mysqld.cnf + sudo sed -i -e '$a\innodb_buffer_pool_size=180M' /etc/mysql/mysql.conf.d/mysqld.cnf sleep 3 sudo service mysql restart #sleep 10