status on SWiK

Firefox3.1/StatusMeetings - MozillaWiki

Thu, 09 Oct 2008 21:57:06 -0700

Audit a MySQL Instance with MySQLTuner

Thu, 09 Oct 2008 18:13:26 -0700

Quite often we need to perform a so-called “MySQL instance audit”. This common DBA procedure should give you a general view of the MySQL environment. You may be interested in a basic understanding of what kind of operation MySQL performs, how much memory does it use, or how well does it look from the performance point of view. There is no easy out-of-the-box way to do such an audit on a MySQL server. You can use SHOW STATUS and check the list of system variables, but this way can hardly be called DBA-friendly.

Fortunately there are several tools to make this process easier. Among most popular are mysqlreport and MySQLTuner. In this post I’d like to give a brief overview of MySQLTuner.

So, what can MySQLTuner do? Quoting the documentation: “MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. Within seconds, it will display statistics about your MySQL installation and the areas where it can be improved.”

It’s not magic — they don’t use any “hidden” or unknown MySQL features to provide the report. What they do is use SHOW STATUS metrics and provide a user-friendly report, interpreting data this or that way. What makes such tools really valuable is the way they interpret that data.

(more…)

The State of Location-Based Social Networking On The iPhone

Fri, 03 Oct 2008 20:18:05 -0700

Hive Five: Five Best Download Managers

Tue, 30 Sep 2008 14:16:26 -0700

SIP Status Codes

Mon, 29 Sep 2008 06:17:33 -0700

HTTP/1.1: Status Code Definitions

Wed, 24 Sep 2008 12:14:11 -0700

[Trac] Custom status values.

Wed, 24 Sep 2008 03:17:33 -0700

Firefox - Cache Status extension

Wed, 24 Sep 2008 01:13:38 -0700

Firefox - Cache Status extension that will tell you how much ram cache and local cache space has been used up

Managing Samba Servers

Tue, 23 Sep 2008 02:09:37 -0700

Hypertext Transfer Protocol -- HTTP/1.1

Sat, 20 Sep 2008 03:58:46 -0700

HTTP/1.1: Status Code Definitions

Wed, 17 Sep 2008 14:46:01 -0700

403 Forbidden

SHOW STATUS WHERE.

Mon, 15 Sep 2008 15:03:21 -0700

Note: This article is about the WHERE extension to SHOW. I specifically use SHOW STATUS as an example, but WHERE is an extension to many SHOW statements.

Often DBAs will assess the health of a system by looking at some of the status variables returned by SHOW GLOBAL STATUS (specifying GLOBAL is important; remember that SHOW STATUS is the same as SHOW SESSION STATUS).

There are many status variables that SHOW GLOBAL STATUS returns. (SHOW GLOBAL STATUS on a Windows machine, MySQL version 5.0.67 returned 249, 5.1.22 returned 256 and 6.0.6-alpha returned 295 status variables!). I have used the SHOW STATUS LIKE syntax to help give me the output I really want, particularly when I forget the exact names of the status variables I am looking for.

But I did not know of a way to perform SHOW STATUS NOT LIKE or have any other means of filtering the information. Until today, when I was reading up on SHOW STATUS.
(more…)

SHOW STATUS WHERE?.

Sat, 13 Sep 2008 09:04:38 -0700

Note: This article is about the WHERE extension to SHOW. I specifically use SHOW STATUS as an example, but WHERE is an extension to many SHOW statements.

But I did not know of a way to perform SHOW STATUS NOT LIKE or have any other means of filtering the information. Until today, when I was reading up on SHOW STATUS.
(more…)

HTTP/1.1: Status Code Definitions

Thu, 04 Sep 2008 12:58:26 -0700

List of HTTP response status codes

HTTP/1.1: Status Code Definitions

Mon, 01 Sep 2008 04:57:57 -0700

10 Status Code Definitions Each Status-Code is described below, including a description of which method(s) it can follow and any metainformation required in the response.

Flock 1.2.5: Facebook and Twitter Fixes

Fri, 29 Aug 2008 13:54:26 -0700

While we're still hard at work pushing Flock 2 from beta towards release, we are taking a moment to provide you with Flock 1.2.5.

Flock puts you at the center of the action, with all your tools and services orbiting around you. It's a lot of work to string all these things together, and occasionally things break. This has been the case with Twitter and Facebook in recent days, as they have both changed elements of their back-end (Facebook with a new design, Twitter with their feeds). You may have noticed issues posting your status to Facebook from the People Sidebar or getting recent friend updates from Twitter in the sidebar. These have been fixed in Flock 1.2.5, which is available now from http://www.flock.com. Auto-updates will go out next week.

Enjoy, and please continue to provide the great and timely feedback that allows us to keep Flock in tip top shape!

Evan Hamilton
Community Ambassador
evan at flock dot com

Blogged with the Flock Browser

Tags: flock, browser, 1.2.5, twitter, facebook, newfacebook, bugs, fixes

HTTP/1.1: Status Code Definitions

Tue, 19 Aug 2008 05:52:16 -0700

HTTP/1.1: Status Code Definitions

Sat, 16 Aug 2008 16:10:19 -0700

HTTP Status / Error Codes

Using Cluster Disk Data in MySQL? 5.1

Wed, 13 Aug 2008 19:13:00 -0700

[HoneyMonitor is a MySQL? GUI Tool for Windows? Systems. Server Administration, Database and Database Objects Administration, Code Development, Server Monitoring, Performance Monitoring, Performance Auditing. Read more on http://www.honeysoftware.com/]

Introduction
Log File Group & UndoFiles
TableSpaces & DataFiles
Cluster Disk Objects Metadata
Creating Cluster Disk Tables
Dropping Cluster Disk Data Objects
The Cluster Monitor
Cluster Disk Data Limitations
Cluster Disk Data Quiz
Other Resources

1. Introduction

Cluster Disk Data is a new feature of MySQL? 5.1. Beginning with MySQL? 5.1.6, in fact, it is possible to store the non-indexed columns of NDBCLUSTER tables on disk, rather than in RAM this allowing MySQL? Cluster to scale upward with fewer RAM requirements than previously.

This is a short tutorial on the features implemented in HoneyMonitor for the use and administration of Cluster Disk Data Objects . It could be useful for Users who are new to the product and want to get start with it or to whom want to learn the basis of Cluster Disk Data in MySQL? 5.1.

For more information about Cluster Disk Data, please visit http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-disk-data.html, while, if you want to learn more on HoneyMonitor, please visit its Project Home Page at http://www.honeysoftware.com/honeymonitor.

For this tutorial we will suppose you have a MySQL? Cluster up and running and we will connect to the Linux machine, from HoneyMonitor, through a SSH Tunneling connection.

If you are new to MySQL? Cluster and want to set up a testbed (all nodes on localhost), you can use this very useful configuration tool (created by Johan Andersson) or, if you want to do a more complicated (but nice) exercise, you can set up the Cluster in 4 Solaris? Zones (a tutorial can be found here).

For our Tutorial, we will follow the following steps:

Create a LogFile Group
Add one more UndoFile to the LogFile Group
Create a TableSpace that uses the LogFile Group just created
Add one more DataFile to the TableSpace
Create a Cluster Disk Table

You can skip steps no. 2 and 4 as they are just to practise.

2. Log File Group & UndoFiles

The LogFile Group Editor (Fig. 1) allows you create / edit / drop a LogFile Group.

Fig. 1: Creating a LogFile Group

It implements the following Data Definitions Statements:

1) [http://dev.mysql.com/doc/refman/5.1/en/create-logfile-group.html]

CREATE LOGFILE GROUP logfile_group
    ADD UNDOFILE ‘undo_file’
    [INITIAL_SIZE [=] initial_size]
    [UNDO_BUFFER_SIZE [=] undo_buffer_size]
    [REDO_BUFFER_SIZE [=] redo_buffer_size]
    [NODEGROUP [=] nodegroup_id]
    [WAIT]
    [COMMENT [=] comment_text]
    ENGINE [=] engine_name

2) [http://dev.mysql.com/doc/refman/5.1/en/alter-logfile-group.html]

ALTER LOGFILE GROUP logfile_group
    ADD UNDOFILE ‘file_name’
    [INITIAL_SIZE [=] size]
    [WAIT]
    ENGINE [=] engine_name

3) [http://dev.mysql.com/doc/refman/5.1/en/drop-logfile-group.html]

DROP LOGFILE GROUP logfile_group
ENGINE [=] engine_name

As you can see from Fig. 1, some options are disabled as they are parsed but not yet implemented by the MySQL? Server.

An UndoFile is required for the LogFile Group creation. In our example we will use an UndoFile named ‘undofile1′.

After the creation of the LogFile Group the Tabs ‘UndoFiles’ and SQL will be enabled (Fig. 2, 3, 4).

Fig. 2: LogFile Group Editor - Advanced Tab

Fig. 3: LogFile Group Editor - UndoFiles Tab

Fig. 4: LogFile Group Editor - SQL Tab

In the UndoFiles Tab you can see UndoFiles’ details or you can create one more UndoFile, using the Add UndoFile Dialog (Fig. 5).

Fig. 5: Add UndoFile Dialog

The SQL Tab contains the SQL statements to be executed for re-creating the LogFile Group (and all its UndoFiles!).

Note: you can’t delete UndoFiles.

Note 2: beginning with MySQL? 5.1.8, you can have only one LogFile Group per Cluster at any given time (see Bug#16386).

Let’s now create a TableSpace that uses the LogFile Group just created.

3. TableSpaces & DataFiles

The TableSpace Editor (Fig. 6) allows you create / edit / drop TableSpaces.

Fig. 6: Creating a TableSpace

It implements the following Data Definitions Statements:

1) [http://dev.mysql.com/doc/refman/5.1/en/create-tablespace.html]

CREATE TABLESPACE tablespace_name
    ADD DATAFILE ‘file_name’
    USE LOGFILE GROUP logfile_group
    [EXTENT_SIZE [=] extent_size]
    [INITIAL_SIZE [=] initial_size]
    [AUTOEXTEND_SIZE [=] autoextend_size]
    [MAX_SIZE [=] max_size]
    [NODEGROUP [=] nodegroup_id]
    [WAIT]
    [COMMENT [=] comment_text]
    ENGINE [=] engine_name

2) [http://dev.mysql.com/doc/refman/5.1/en/alter-tablespace.html]

ALTER TABLESPACE tablespace_name
    {ADD|DROP} DATAFILE ‘file_name’
    [INITIAL_SIZE [=] size]
    [WAIT]
    ENGINE [=] engine_name

3) [http://dev.mysql.com/doc/refman/5.1/en/drop-tablespace.html]

DROP TABLESPACE tablespace_name
ENGINE [=] engine_name

Note: The Editor can be used to create both NDBCLUSTER and FALCON TableSpaces. When creating FALCON TableSpaces, the ‘LogFile Group’ option isn’t visible.

As you can see from Fig. 6, some options are disabled as they are parsed but not yet implemented by the MySQL? Server.

A DataFile is required for the TableSpace creation. In our example we will use a DataFile named ‘datafile-11′.

After the creation of the TableSpace the Tabs ‘DataFiles’ and SQL will be enabled (Fig. 7, 8, 9).

Fig. 7: TableSpace Editor - Advanced Tab

Fig. 8: TableSpace Editor - DataFiles Tab

Fig. 9: TableSpace Editor - SQL Tab

In the DataFiles Tab you can see DataFiles’ details or you can create one more DataFile, using the Add DataFile Dialog (Fig. 10). You can also drop a DataFile.

Fig. 10: Add DataFile Dialog

The SQL Tab contains the SQL statements to be executed for re-creating the TableSpace (and all its DataFiles!).

4. Cluster Disk Objects Metadata

The source for Cluster Disk Object Metadata in MySQL? 5.1 is the information_schema.files table. I’ll try to post a more detailed article on Disk Object Metadata later on.

In the HoneyMonitor’s Metadata Catalog there is a visualization dedicated to Cluster Disk Objects (Fig. 11).

Fig. 11: Metadata Catalog - Cluster Disk Objects

That visualization is very useful to know, with just a look, the Cluster Disk Objects’ hierarchy. You can use popup menus to create / edit / drop the objects.

5. Creating Cluster Disk Tables

Now that our TableSpace has been created, we can create a Cluster Disk Table. We can use the command line client

CREATE TABLE my_disk_data_table (
….
)
TABLESPACE tablespace1 STORAGE DISK
ENGINE = NDBCLUSTER;

or the Create Table Wizard (Fig. 12).

Fig. 12: Creating a Cluster Disk Table

6. Dropping Cluster Disk Data Objects

Please, note that there are particular rules for dropping Cluster Disk Data Objects. You have to follow a logical order. For more information, please refer to http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-disk-data-objects.html.

7. The Cluster Monitor

The Cluster Monitor (Fig. 13) allows you to monitor the status of your Cluster.

Fig. 13: The Cluster Monitor

At this stage of development it’s a simple (but useful) Window which shows information about the NDB Engine Status (at a glance or category by category) and the status, dynamic and system variables of the Server related to Cluster.

We plan to add new features for Cluster Management and Monitoring in HoneyMonitor, so stay tuned!

8. Cluster Disk Data Limitations

Disk Data Objects are subject to the following maximums:

Maximum number of TableSpaces: 2^32 (4294967296)
Maximum number of DataFiles per TableSpace: 2^16 (65535)
The theoretical maximum number of extents per TableSpace data file is 2^16 (65525); however, for practical purposes, the recommended maximum number of extents per DataFile is 2^8 (32768).
Maximum DataFile size: The theoretical limit is 64G; however, in MySQL? 5.1, the practical upper limit is 32G. This is equivalent to 32768 extents of 1M each.The minimum and maximum possible sizes of extents for TableSpace data files are 32K and 2G, respectively.

For known limitations of MySQL Cluster, please refer to http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-limitations.html.

9. Cluster Disk Data Quiz

Create a LogFile Group, some TableSpaces and some Cluster Disk Tables. Then choose a TableSpace and write a query to find the list of the tables which are using that TableSpace.

10. Other Resources

It’s now time to close this article. If you want to learn more on HoneyMonitor please visit the Project Home Page, at http://www.honeysoftware.com/honeymonitor, or check out one of the following resources:

Enjoy your MySQL? Cluster!

TextMate Plug-in: ProjectPlus

Mon, 11 Aug 2008 00:08:38 -0700

Badges to indicate svn/git status of files.

Git statistics for Linus' kernel tree

Sat, 09 Aug 2008 02:08:19 -0700

HTTP/1.1: Status Code Definitions

Fri, 08 Aug 2008 14:09:20 -0700

Fission :: Firefox Add-ons

Thu, 07 Aug 2008 16:09:00 -0700

Fission combines address bar and progress bar (Safari style). This makes the progress bar more visible and allows for a nice visual effect.

Status/Nov07 - GHC - Trac

Tue, 22 Jul 2008 17:50:34 -0700

Places query URIs - MDC

Thu, 10 Jul 2008 18:49:05 -0700

Wow, Firefox lets you define a static query string and it will maintain a dynamic display of matching bookmarks! Clever!! They call this feature "Places query URIs".

Facebook's new iPhone app says to Twitter (and SMS): Here's what I'm doing " VentureBeat

Thu, 10 Jul 2008 13:01:43 -0700

facebook's iphone app, which aggregates statuses, could be a huge threat to twitter

HTTP/1.1: Status Code Definitions

Tue, 08 Jul 2008 00:50:25 -0700

Six Ways To Update Your Status - ReadWriteWeb

Sun, 06 Jul 2008 18:49:20 -0700

To update your social status on multiple services, there are several different options to choose from.

Information radiator screen savers for MacOS X

Sun, 06 Jul 2008 07:53:18 -0700

Mundane Essays: bash: don't make me think

Tue, 01 Jul 2008 12:47:51 -0700

git + bash

status on SWiK

Firefox3.1/StatusMeetings - MozillaWiki

Audit a MySQL Instance with MySQLTuner

The State of Location-Based Social Networking On The iPhone

Hive Five: Five Best Download Managers

SIP Status Codes

HTTP/1.1: Status Code Definitions

[Trac] Custom status values.

Firefox - Cache Status extension

Managing Samba Servers

Hypertext Transfer Protocol -- HTTP/1.1

HTTP/1.1: Status Code Definitions

SHOW STATUS WHERE .

SHOW STATUS WHERE?.

HTTP/1.1: Status Code Definitions

HTTP/1.1: Status Code Definitions

Flock 1.2.5: Facebook and Twitter Fixes

HTTP/1.1: Status Code Definitions

HTTP/1.1: Status Code Definitions

Using Cluster Disk Data in MySQL? 5.1

[HoneyMonitor is a MySQL? GUI Tool for Windows? Systems. Server Administration, Database and Database Objects Administration, Code Development, Server Monitoring, Performance Monitoring, Performance Auditing. Read more on http://www.honeysoftware.com/]

Contents

1. Introduction

2. Log File Group & UndoFiles

3. TableSpaces & DataFiles

4. Cluster Disk Objects Metadata

5. Creating Cluster Disk Tables

6. Dropping Cluster Disk Data Objects

7. The Cluster Monitor

8. Cluster Disk Data Limitations

9. Cluster Disk Data Quiz

10. Other Resources

TextMate Plug-in: ProjectPlus

Git statistics for Linus' kernel tree

HTTP/1.1: Status Code Definitions

Fission :: Firefox Add-ons

Status/Nov07 - GHC - Trac

Places query URIs - MDC

Facebook's new iPhone app says to Twitter (and SMS): Here's what I'm doing " VentureBeat

HTTP/1.1: Status Code Definitions

Six Ways To Update Your Status - ReadWriteWeb

Information radiator screen savers for MacOS X

Mundane Essays: bash: don't make me think

SHOW STATUS WHERE.