Just a quick note to say I'll be giving a 1 hour webinar on performance tuning practices for MySQL at 1pm EST, 10am PDT today. Here is a link to sign up for it:

http://www.mysql.com/news-and-events/web-seminars/display-373.html

Hope to see you on the webinar

Most commonly used MySQL specific SQL Commands - Now I don't have to google for them every time I forget the syntax.


GRANT


The GRANT statement enables system administrators to create MySQL user accounts and to grant rights to accounts. To use GRANT, you must have the GRANT OPTION privilege, and you must have the privileges that you are granting. The REVOKE statement is related and enables administrators to remove account privileges. To determine what privileges an account has, use SHOW GRANTS.

GRANT

priv_type [(column_list)]

[, priv_type [(column_list)]] ...

ON [object_type] …

I'm pleased to announce a release of a new storage engine "Vertical Partitioning storage engine".
http://launchpad.net/vpformysql
You can use relation tables of one to one like one table by using Vertical Partitioning storage engine.
It is near by a view of joined relation tables of one to one but different point is following.
- It can insert.
- It can do partition pruning.(Not use partitions that are no necessity)


Vertical Partitioning storage engine can use following purposes.
(Vertical Partitioning table is called "parent table", integrated tables are called "child table")


1.A MySQL's InnoDB table that has the big record size is very slow if a select statement needs table scanning with a lot of records.
  Vertical Partitioning is good for resolving this performance problem.
…

Hello,

As a somewhat different choice, we have gone outside Europe and chosen to launch an Asian extension. You can now register and manage .JP domain names (the official ccTLD of Japan) at Gandi.

The extension is usually reserved for the Japanese, though we can provide you with a local contact for free that will let you register it, even if you are not in Japan.

.JP domains may be registered for €72 excl. VAT under A rates. Please note that we do not yet manage the transfer of .JP domains automatically.

You may see the .JP information page here: https://www.gandi.net/domain/jp/info

The complete .JP price list can be found at: https://www.gandi.net/domaine/prix/detail/jp/

Platform - Linux

Sample script to backup MySQL DBs

#!/bin/bash

# Pls change these
db_host='localhost'
db_user='backupuser'
db_user='secretpassword'
#
# BACKUP_DIR - Need to change as per HOST/DB environment
#
BACKUP_DIR="/backups/`hostname -s`/mysql"

if [ ! -d $BACKUP_DIR ] ; then
mkdir -p $BACKUP_DIR
chmod 700 $BACKUP_DIR
fi

# Pls donot touch below code

DATE=`date +"%Y%m%d"`
MYSQLDUMP="$(which mysqldump)"
LOG_FILE=${BACKUP_DIR}/runlog${DATE}.log
MYSQL="$(which mysql)"

DB_LIST="$($MYSQL -u$db_user -h$db_host -p$db_pass -Bse 'show databases')"

exec 2> ${LOG_FILE}

MYSQLDUMP_OPT="${MYSQLDUMP} -u${db_user} -p${db_pass} -h${db_host} --opt"

for DB_NAME in ${DB_LIST} ; do

if [ ! -d …

Well signposted :)

Thanks to echolibre for providing the content of the beers tables (in the pub schema, of course)!

Hello,

Today we have added the possibility of registering domain names in .me.uk, which is the UK extension that is designed for individuals. The extension nonetheless remains open to all. It may be registered for a minimum of 2 years at a rate of €6 under A rates.

You may see the .ME.UK information page here: https://www.gandi.net/domain/me.uk/info

The complete .ME.UK price list can be found at: https://www.gandi.net/domaine/prix/detail/nl/

I presented on "Creating powerful web applications using GlassFish, MySQL and NetBeans/Eclipse" as the first talk of FISL 10 yesterday. The room was only partial full being the first talk of FISL but got packed towards the middle so that was exciting. The slides are available here.

The key message is that NetBeans and Eclipse provide a seamless development/deployment environment for GlassFish.

The several demos shown in the talk are explained at:

• …

There has been a lot of discussion in the blogosphere recently about benchmarks, and I can't help but notice that a lot of the comments and opinions are harsh, sometimes downright mean, and alas uninformed.

Why do people care so much about a benchmark. IT IS JUST NUMBERS PEOPLE.

Seriously (and this isn't directed at any one person in particular):

Who doesn't like to play "my thing is bigger than your thing" every once in awhile, but you don't have to take it so personally. If a vendor wants to waste money running a huge benchmark for little profit - WHO CARES? There must be some audience for the benchmark results, but if you aren't it, why bother screaming at the top of your lungs that the benchmark is ludicrous, or useless or ineffective. Just ignore it.  You obviously are not the intended audience.  If you are the intended audience and you still don't care, then go play another game.  …

On the MySQL Proxy channel we get questions from time to time if the authentication can be intercepted and replaced data from a external source.

From now on, you can. For example if you want to get data from a external source (like LDAP) or want to implement roles.

Mapping Accounts to “Roles”

There isn’t much needed to implement Roles for MySQL with the help of the MySQL Proxy.

• mysql.user doesn’t contain users, but roles instead
• the proxy maps user-accounts to role-accounts with a script like above

It works like this:

1. login to the proxy

        $ mysql --user=jan --password=secret --port=4040

2. proxy looks up username password, finds a role for him

3. proxy replaces credentials ad hoc

4. …