tony4d

#!/bin/bash

# No username or passwords in this script, you should use mysql_config_editor
# to store it securely. The login-path in this script is set to "local-backup" so when you create
# your .mylogin.cnf with the mysql-config-editor make sure it is set the same
# See http://dev.mysql.com/doc/refman/5.6/en/mysql-config-editor.html
# An example to create your config for a mysql user "backup":
# shell> sudo mysql_config_editor set --login-path=local-backup --host=localhost --user=backup --password
# The backup user in the mysql server needs these privileges: SELECT, RELOAD, SHOW DATABASES, REPLICATION CLIENT

colinmollenhour

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

set -e

mysql="mysql"
test="test"
bash="bash"

Vinai

<?php

/**
 * Drop this into the shell directory in the Magento root and run with -h to see all options.
 */

require_once 'abstract.php';

/**
 * Fix duplicate url keys for categories and products to work with the 1.8 alpha1 CE url key constraints.

kchodorow

<?php

function getReplicationInfo($m) {
  $db = $m->local;
  $result = array();

  $ol = $db->system->namespaces->findOne(array("name" => 'local.oplog.$main'));

  if ($ol && array_key_exists('options', $ol)) {
    $result['logSizeMB'] = $ol['options']['size'] / 1000 / 1000;