Steffen Wirth steffen-wirth

steffen-wirth / mysql_monitor.sh

Last active August 29, 2015 14:08 — forked from colinmollenhour/mysql_monitor.sh

	#!/bin/bash
	#
	# Monitor MySQL queries
	# @author Colin Mollenhour

	file=$(mysql -Be 'SHOW VARIABLES LIKE "general_log_file";' \| tail -n 1 \| awk '{print $2;}')
	echo "SET GLOBAL general_log = 'ON';" \| mysql
	if [ -w "$file" ]; then
	>$file
	tail -f $file

steffen-wirth / pricerules.php

Last active August 29, 2015 14:07 — forked from drewgillson/pricerules.php

	<?php
	require_once 'abstract.php';

	class Mage_Shell_Pricerules extends Mage_Shell_Abstract
	{

	public function run()
	{
	ini_set('memory_limit', '1024M');
	$this->db = Mage::getSingleton('core/resource')->getConnection('core_read');