chris-huffman

cd /tmp
wget http://downloads3.ioncube.com/loader_downloads/ioncube_loaders_lin_x86-64.tar.gz
tar xfz ioncube_loaders_lin_x86-64.tar.gz

#Note: this install is specific to a specific version of PHP. Make sure to use the correct one for your system. The example below is using PHP 7.2.
php -v

Ioncube install:

copy ioncube_loader_lin_7.2.so to /usr/lib64/php/modules/

chris-huffman

for i in *.png; do mv "$i" "${i/.png}"_1.png; done   

chris-huffman

#Show indexes
curl 127.0.0.1:9200/_cat/indices

#Update max_result_window to avoid error about "Result window is too large"
curl -XPUT "http://localhost:9200/magento2_product_1_v2/_settings" -d '{ "index" : { "max_result_window" : 500000 } }' -H "Content-Type: application/json"

chris-huffman

SELECT
	s.increment_id,
	c.firstname,
	c.lastname,
	qa.city,
	qa.region,
	qa.postcode
FROM
	`paradoxlabs_subscription` AS s
	JOIN `customer_entity` AS c ON s.customer_id = c.entity_id

chris-huffman

From within vagrant:
* $ sudo vi /etc/httpd/conf.d/httpd.conf
   * SetEnv MAGE_IS_DEVELOPER_MODE 0
   * SetEnv MAGE_MODE production
* $ MAGE_MODE=production
* $ bin/magento deploy:mode:set production
* $ sudo systemctl restart httpd

chris-huffman

SELECT CONCAT(table_schema, '.', table_name),
       CONCAT(ROUND(table_rows / 1000000, 2), 'M')                                    rows,
       CONCAT(ROUND(data_length / ( 1024 * 1024 * 1024 ), 2), 'G')                    DATA,
       CONCAT(ROUND(index_length / ( 1024 * 1024 * 1024 ), 2), 'G')                   idx,
       CONCAT(ROUND(( data_length + index_length ) / ( 1024 * 1024 * 1024 ), 2), 'G') total_size,
       ROUND(index_length / data_length, 2)                                           idxfrac
FROM   information_schema.TABLES
ORDER  BY data_length + index_length DESC
LIMIT  10;