- First, you need to open cmd in the admin mode, then run all commands below one by one.
- For x86 and x64
cd /d %ProgramFiles(x86)%\Microsoft Office\Office16
cd /d %ProgramFiles%\Microsoft Office\Office16
cd /d %ProgramFiles(x86)%\Microsoft Office\Office16
cd /d %ProgramFiles%\Microsoft Office\Office16
| #!/bin/bash | |
| MAGE_BASE_URL="$1" | |
| MAGE_SKU="$2" | |
| PAYMENT_KEY="$3" | |
| PAYMENT_METHOD="$4" | |
| STORE_VIEW="$5" | |
| CREDIT_CARD="$6" | |
| CREDIT_CARD_CVC="$7" |
| 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 |
| # === Optimized my.cnf configuration for MySQL/MariaSQL (on Ubuntu, CentOS etc. servers) === | |
| # | |
| # by Fotis Evangelou, developer of Engintron (engintron.com) | |
| # | |
| # ~ Updated October 2021 ~ | |
| # | |
| # | |
| # The settings provided below are a starting point for a 8-16 GB RAM server with 4-8 CPU cores. | |
| # If you have different resources available you should adjust accordingly to save CPU, RAM & disk I/O usage. | |
| # |
| #### by MageHost.pro #### | |
| # execute in Magento 2 root: | |
| find vendor app -regextype 'egrep' -type f -regex '.*/layout/.*\.xml' -not -regex '.*(vendor/magento/|/checkout_|/catalogsearch_result_|/dotmailer).*' | xargs grep --color -n -e 'cacheable="false"' |