juniorplenty

// This implementation eliminates the plugin, and breaks out the conversion-to-javascript (6 lines) and
// concat-into-template.js (3 lines)
// This way, the file is parsed by jade, converted to javascript, and then cached. The concat/header/footer
// workflow then takes all cached content and creates the final file.
// Enjoy.

var htmlJsStr = require('js-string-escape'); // used by templatecache internally
var cache     = require('gulp-cached');

function buildTemplates(){

juniorplenty

#!/bin/bash

SRCDB=honeydew_production
SRCTABLE=impressions
DSTDB=honeydew_archive_2012
DSTTABLE=impressions

SQL="alter table $DSTDB.$DSTTABLE disable keys"
echo "$SQL"
echo "$SQL" | mysql

juniorplenty

SELECT CONCAT(FORMAT(DataPages*100.0/TotalPages,2),' %') BufferPoolDataPercentage FROM
(SELECT variable_value DataPages FROM information_schema.global_status
WHERE variable_name = 'Innodb_buffer_pool_pages_data') A,
(SELECT variable_value TotalPages FROM information_schema.global_status
WHERE variable_name = 'Innodb_buffer_pool_pages_total') B;