View gist:c16d66ce9aeb4d1482a9
truncate catalog_product_flat_cl; | |
truncate catalog_category_product_index_cl; | |
truncate catalog_category_product_cat_cl; | |
truncate catalog_category_flat_cl; | |
truncate catalogsearch_fulltext_cl; | |
truncate cataloginventory_stock_status_cl; | |
truncate catalog_product_flat_cl; | |
truncate catalog_product_index_price_cl; | |
truncate enterprise_url_rewrite_category_cl; | |
truncate enterprise_url_rewrite_product_cl; |
View clean-magento_ce-db-extended.sql
-- | |
-- Magento CE database clean-up extended | |
-- | |
-- This is an extended clean-up which will clean search, import/export, reports, etc. | |
-- | |
-- @author Constantin Bejenaru <boby@frozenminds.com> | |
-- @copyright Copyright (c) Constantin Bejenaru (http://frozenminds.com/) | |
-- @license http://www.opensource.org/licenses/mit-license.html MIT License | |
-- |
View gist:e9cba84bc739158de155
truncate catalog_product_flat_cl; | |
truncate catalog_category_product_index_cl; | |
truncate catalog_category_product_cat_cl; | |
truncate catalog_category_flat_cl; | |
truncate catalogsearch_fulltext_cl; | |
truncate cataloginventory_stock_status_cl; | |
truncate catalog_product_flat_cl; | |
truncate catalog_product_index_price_cl; | |
truncate enterprise_url_rewrite_category_cl; | |
truncate enterprise_url_rewrite_product_cl; |
View run-innobackupex.sh
#!/bin/sh | |
TMPFILE="/tmp/innobackupex-runner.$$.tmp" | |
USEROPTIONS="--user=XXX --password=XXX" | |
FILTERTABLES="--include=.*[.].*" | |
BACKDIR=/var/mysql-bak | |
BASEBACKDIR=$BACKDIR/base | |
INCRBACKDIR=$BACKDIR/incr | |
FULLBACKUPLIFE=3600 #604800 # How long to keep incrementing a backup for, minimum 60 | |
KEEP=1 # Keep this number of backups, appart form the one currently being incremented |
View default-cached.conf
server { | |
listen 80; | |
server_name XX.XX.XX.XX; | |
root /var/www/html/default; | |
location /index.php { | |
alias /var/www/html/default/wp-index-redis.php; | |
} | |
location / { |
View predis.php
<?php | |
namespace Predis; | |
class PredisException extends \Exception { } | |
class ClientException extends PredisException { } // Client-side errors | |
class AbortedMultiExec extends PredisException { } // Aborted multi/exec | |
class ServerException extends PredisException { // Server-side errors | |
public function toResponseError() { | |
return new ResponseError($this->getMessage()); |