If you're
planning to attend UKOUG in Birmingham on Dec 3-5, here's your guide
to know more about Oracle's MySQL.
There's a MySQL stream on Monday 5th and we've a great list of
sessions, including:
Planning to attend the DOAG Conference this week in Nuremberg? There will be several MySQL presentations, including the three following ones from Oracle team members:
Oracle GoldenGate: Bindeglied zwischen Oracle & MySQL
Datenbanken
Ileana Somesan
Wednesday November 21, 12:00
NoSQL and SQL: Blending the Best of Both Worlds
Andrew Morgan
Wednesday November 21, 14:00
MySQL Replikation
Carsten Thalheimer
Wednesday November 21, 16:00
We look forward to seeing you there!
Palomino was honored to serve as part of the team of technologists on President Obama's re-election campaign. Atlantic Magazine ran a fascinating piece about Narwhal, the sophisticated data architecture that enabled the campaign to track voters, volunteers and online trends.
Palomino CEO Laine Campbell joined the team in Chicago for the final days of the campaign, ensuring maximum uptime and performance on the MySQL databases. Afterwards, President Obama thanked her for Palomino's contributions.
Palomino was honored to serve as part of the team of technologists on President Obama's re-election campaign. Atlantic Magazine ran a fascinating piece about Narwhal, the sophisticated data architecture that enabled the campaign to track voters, volunteers and online trends.
Palomino CEO Laine Campbell joined the team in Chicago for the final days of the campaign, ensuring maximum uptime and performance on the MySQL databases. Afterwards, President Obama thanked her for Palomino's contributions.
How To Install MySQL 5.6 On Ubuntu 12.10 (Including memcached Plugin)
According to What's New in MySQL 5.6, MySQL 5.6 will bring some performance improvements over MySQL 5.5. If you want to test out MySQL 5.6, you have to install one of the development releases from the MySQL downloads page because there is no stable release yet. This tutorial explains how to install the MySQL 5.6.8rc1 (Linux Generic) development release on an Ubuntu 12.10 server.
I have a soft spot for hierarchical databases. My first
database-related job was programming in M/Mumps. I know the
standard history of databases says that hierarchical databases
are a relic of the past, and that, thanks to Codd, relational
databases solve many of the problems of hierarchical (and other
kinds of) databases. I like relational databases – I was an
Oracle DBA, I’ve worked with DB2, Sybase, Postgres, mSQL, others,
and now MySQL. I really like InnoDB. However, I am
occasionally sad that hierachical databases seem a thing of the
past.
Or are they? Yesterday I had a thought that hierarchical
databases are much more widely used than relational
databases. In fact, maybe every single computer has a
hierarchical database that is used by every computer user,
whether they have database software installed or not. The
file system! Isn’t that a hierarchical database? The
idea …
I’m currently working on a new project about the explain
command output.
For my research I’ve read a lot of documentations, presentations
and blog posts and I would like to focus on the join type in
the explain output.
And in particular when type=index in
this explain output.
Take a look at what says the official documentation about type=index :
Wait a second, only the index tree is scanned? really?
This description seems to be the definition of a covering index.
But a covering index is only characterized by a
“Using index” in the extra column of the
explain output.
Consider the t1 table, just …
[Read more]
Important: Before you start any operation
mentioned below do a proper file system backup of your XFS file
system you want to resize. If MySQL is running on this mount
point do this with a stopped mysqld. Alternatively
you can also use mysqldump to do the MySQL backup
but test the restore time before continuing to not experience
ugly surprises...
All these operations have to be performed as the
root user. First we want to see what mount points
are available:
shell> df -h Filesystem Size Used Avail Use% Mounted on /dev/sda1 485M 77M 383M 17% / /dev/sdb1 496M 314M 157M 67% /var/lib/mysql
Our MySQL data are located on /dev/sdb1.
After the file system backup unmount /dev/sdb1 and
resize the disk, partition or volume (works for VMware, NetApp
filer and similar equipment, for LVM …
Is there simply an sql query or a complex combination of them to search a string..
Twice last week, a developer wanted to convert the existing
datetime values in a database to UTC. The datetime values were
the default for the server, which was the US/Pacific time zone,
which is subject to Daylight Saving Time changes. Both developers
for both applications wanted to convert all the times to UTC, so
there would not be any changes due to Daylight Saving Time, and
asked me for an easy query to know which times should be changed
by adding 7 hours and which times should have 8 hours added to
them.
The good news is that MySQL has some built-in functionality to
make this easier. You may know about the CONVERT_TZ() function in MySQL, and that you
can use it in a query to convert times like this:
mysql> SELECT CONVERT_TZ(NOW(),'-8:00','-0:00');
+-----------------------------------+
| …
