Showing entries 22233 to 22242 of 44056
« 10 Newer Entries | 10 Older Entries »
Easy Python: display LVM details in XML

If you need to work with LVM in your scripts but haven’t found a good method to access details about Logical Volume Groups, here’s a simple Python script that will print the details about any volumes on your system. This could be useful for writing a partition check script for your MySQL data directory (if you’re not using a standard monitoring system like Nagios).

import sys
import os
import commands
import subprocess
import select

def lvm():
    print ""
    LVM_PATH = "/sbin"
    LVM_BIN = os.path.join(LVM_PATH, 'lvm')
    argv = list()
    argv.append(LVM_BIN)
    argv.append("lvs")
    argv.append("--nosuffix")
    argv.append("--noheadings")
    argv.append("--units")
    argv.append("b")
    argv.append("--separator")
    argv.append(";")
    argv.append("-o")
    argv.append("lv_name,vg_name,lv_size")

    process = subprocess.Popen(argv, stdout=subprocess.PIPE)
    output = ""
    out = process.stdout.readline()
    output += out
    lines = …
[Read more]
Announcing TokuDB v4.1

Tokutek is pleased to announce immediate availability of TokuDB for MySQL, version 4.1. It is designed for continuous querying and analysis of large volumes of rapidly arriving and changing data, while maintaining full ACID properties.

New in TokuDB v4.1 includes important improvements, most notably support for SAVEPOINT and improved Fast Loader performance (introduced in v4.0).

This new release builds on TokuDB’s unique combination of capabilities:

  • 10x-50x faster indexing for faster querying
  • Full support for ACID transactions
  • Short recovery time (seconds or minutes, not hours or days)
  • Immunity to database aging to eliminate performance degradation and maintenance headaches
  • 5x-15x data compression for reduced disk use and lower storage costs

Because of its high …

[Read more]
MySQL query to find all views in a database

You might find it useful to list all the views/tables in a particular database.

I am going to show you three different methods to get the lists using GUI and command line tools.

How to find all tables of a particular storage engine in MySQL?

MySQL supports several storage engines with different features and functions.

If you want to find out what tables are using a particular storage engine in MySQL then can run these simple queries in a MySQL command line interface.

MySQL: Query caused different errors on master and slave

We ran across the following error on a MySQL slave server recent: mysql> SHOW SLAVE STATUS \G <snip> Last_Error: Query caused different errors on master and slave. Error on master: 'Deadlock found when trying to get lock; try restarting transaction' (1213), Error on slave: 'no error' (0). Default database: '<database_name>'. Query: '<query>' <snip> In this […]

Blank MySQL Graphs in Munin

From the Munin FAQ

Q: Why are the graphs for the MySQL plugin blank?

This is due to a bug in a Perl library Munin uses which causes $PATH to be lost. This again causes the plugin to not find the mysqladmin program which it needs to retrive the numbers the needed in the graphs. The solution is to hardcode the path of the program.

First locate the mysqladmin program. On most systems, the command which mysqladmin, type mysqladmin or locate mysqladmin will help you. When you find the path, enter that path in /etc/munin/plugin-conf.d/munin-node.

This is how it might look:

darkstar:~# which mysqladmin
/usr/bin/mysqladmin
Then, under the [mysql*] section identifier in /etc/munin/plugin-conf.d/munin-node, add the following line:

env.mysqladmin /usr/bin/mysqladmin

Found in the …

[Read more]
Easy MySQL: how to backup databases to a remote machine

Here’s a simple answer to a simple question. “How do I run a backup of MySQL to another machine without writing to the local server’s filesystem?” – this is especially useful if you are running out of space on the local server and cannot write a temporary file to the filesystem during backups.

Method one – this writes a remote file.
mysqldump [options] [db_name|--all-databases]| gzip -c | ssh user@host.com "cat > /path/to/new/file.sql.gz"

Method two – this writes directly into a remote mysql server
mysqldump [options] [db_name|--all-databases]| mysql --host=[remote host] –user=root –password=[pass] [db_name]

Log Buffer #199, A Carnival of the Vanities for DBAs

Welcome to Log Buffer. The weekly review of DBA industry news. Enjoy Log Buffer #199.

Remember if you find a link or interesting blog post that you think Log Buffer should mention, send a note to the editor at Log Buffer and be sure to include the link, and a short note outlining why you think that particular post would be of value to other DBAs, or what you learned from reading it.

And, for inquiries about hosting or editing a future edition of Log Buffer on your own blog, send your query to the Log Buffer coordinator. (Please include the words “Log …

[Read more]
Speaking up on Froscon

Hi MMM users.

On this post I just want to let you know that I will speak up at Froscon in Cologne, Germany next week (21st, August).

My speech will cover an architecture what I have used to "keep your mysql backend online, no matter what", what is the title of the presentation too.

This architecture includes MMM as a very important part of it.

Please visit the conference's website and join us there if you can.

www.froscon.de

Oracle needs to get hurt .. badly!

There are plenty of bad things in the world. But I guess there is nothing that has such a drastic and dangerous impact on my life that software patents. If patents are good thing in other industries can be discussed, but in the software industry its a clear cut thing: they hurt innovation, they hurt small businesses and they scare the shit out of me. And if you are a software developer, they should scare the shit out of you too! Now Oracle decided as the first big company that is not just a patent troll to actually sue a company over software patents. heck maybe others have sued before, but lets stop this behavior right here right now. We must send a clear message. We must send a clear message to Oracle that they better stop. And we must send a clear message to any other company holding software patents that they better not think of suing. I …

[Read more]
Showing entries 22233 to 22242 of 44056
« 10 Newer Entries | 10 Older Entries »