Jonatan Santos jonatanrdsantos

Show MySQL process list without sleeping connections

Usually you don't need to, but when you want to see which queries your MySQL server currently needs to handle (and if there are locks, etc), you could say SHOW PROCESSLIST in a MySQL shell.

Unfortunately, SHOW PROCESSLIST does not allow filtering. When you are on MySQL ≥ 5.1.7, do this instead:

SELECT * FROM information_schema.processlist WHERE command != 'Sleep' ORDER BY id;

That also allows you to only show some values or order differently, like so:

PHP

    public function stateSearchAction()
    {
        $country = $this->getRequest()->getParam('code');
        $collection = Mage::getModel('directory/region')->getCollection()
            ->addFieldToFilter('country_id', $country)->getData();
        $this->getResponse()->clearHeaders()->setHeader('Content-type', 'application/json');
        $this->getResponse()->setBody(Zend_Json::encode($collection));
    }

Magento when you use GROUP BY clause in any Grid.php file in admin, the count always display wrong. Many times it displays 1 even if there are hundreds of records. Due to this your pagination also doesn’t work. This is a bug in Magento. Your getSize() always returns wrong count whereas total records in grid are proper.

To fix this, you need to edit one of your core file. As it’s not a good practice to edit core file, we will here override the core file. Overriding LIB module

Create a rewrite to yout collection main.table:

Mage_[MODULE]Model_Resource[RESOURCENAME]_Grid_Collection

And rewrite getSelectCountSql function with below one:

	<?php

	/::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::/
	/:: :/
	/:: This routine calculates the distance between two points (given the :/
	/:: latitude/longitude of those points). :/
	/:: :/
	/:: Definitions: :/
	/:: South latitudes are negative, east longitudes are positive :/
	/:: :/

-<?php
-// Avoid any time limit
-set_time_limit(0);
-// Avoid any memory limit
-ini_set('memory_limit', -1);
-// Include bootstrap code and Mage class
-require_once 'app/Mage.php';

	<?php
	error_reporting(E_ALL);
	ini_set('display_errors', 1);
	require_once 'app/Mage.php';
	Mage::app();
	//echo "Testando<br>";
	$fromDate = date('Y-m-d H:i:s', strtotime('2016-05-28 00:00:01'));
	$toDate = date('Y-m-d H:i:s', strtotime('2016-07-28 23:59:59'));
	$orders = Mage::getModel('sales/order')->getCollection()
	->addFieldToSelect('increment_id')

	<?php



	switch($_SERVER['HTTP_HOST']) {
	case 'shoes.com':
	case 'www.shoes.com':
	$mageRunCode = 'shoes';
	$mageRunType = 'website';
	break;

	<?php

	/**
	* Error reporting
	*/
	error_reporting(E_ALL \| E_STRICT);

	/**
	* Compilation includes configuration file
	*/

	$ sudo mkdir /var/mysql
	$ cd /var/mysql
	$ sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock