Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский
Showing entries 1 to 20 of 18283 Next 20 Older Entries
18/Nov/2009 - The Open Source Data Warehouse Revolution
Employee +0 Vote Up -0Vote Down
On the 18th of November we've hold in Milan an event focused on Open Source Data Warehousing.

For many organizations, data warehouses are simply too costly to buy, too costly to implement and too costly to maintain. Data warehousing is still a luxury of deep-pocketed organizations, although the resulting benefits can be virtually reaped by companies of all sizes.
Open Source Software is changing the rules again, lowering the economic barriers to undertake Business Intelligence and Data Warehousing projects.

During the event we proved that MySQL can help organizations to achieve higher ROI on their projects. With the support of our partners, Infobright and Talend, we showed how to design, deploy and manage a multi-terabyte Data




  [Read more...]
Josh Berkus helps clarify clustering
+0 Vote Up -0Vote Down

If you haven’t seen it, Josh Berkus has a very concise way to look at the confusing mess that is database “clustering” from the point of view of three distinct types of users: transactional, analytic, and online. I think that using this kind of distinction could help keep discussions clear — I’ve seen a lot of conversations around clustering run off the rails due to disagreements about what clustering means. MySQL Cluster, for example, is a huge red herring for a lot of people, but it seems to be a difficult process to learn it well enough to decide. If we called it a clustering solution for transactional users, but not for analytic or online users, it might help a lot.

Related posts:

  [Read more...]
ON DUPLICATE KEY With NULL Validation
+0 Vote Up -0Vote Down

I am not sure if this is a bug or how MySQL works on validating constraints in association with ON DUPLICATE KEY (late or early checking). For example, consider the following use case (this is irrepective of storage engine and MySQL version):

mysql> create table t1(id int not null primary key, val int not null) Engine=MyISAM;
Query OK, 0 rows affected (0.07 sec)
 
mysql> insert into t1 values(10,20);
Query OK, 1 row affected
  [Read more...]
DynamoDB: Built in Time Dimension support!
+1 Vote Up -0Vote Down

DynamoDB (aka LucidDB) is not just another column store database. Our goal is being the best database for actually doing Business Intelligence; while that means being fast and handling large amounts of data there’s a lot of other things BI consultant/developers need. I’ll continue to post about some of the great BI features that DynamoDB has for the modern datasmiths.

First feature to cover that’s dead easy, is the built in ability to generate a time dimension, including a Fiscal Calendar attributes. If you’re using Mondrian (or come to that, your own custom SQL on a star schema) you need to have a time dimension. Time is the most important dimension! Every OLAP model I’ve

  [Read more...]
GROUP UNCONCAT
Employee_Team +0 Vote Up -0Vote Down

Dunno why you’d rather do this in SQL than in your application layer, but if you do, here’s one way to turn a delimited string of values back into multiple rows - just the opposite of GROUP_CONCAT:

SET @sourceString = 'a,b,c,d,e';
SET @sql = CONCAT('INSERT INTO t VALUES (\'', REPLACE(@sourceString, ',', '\'),(\''), '\')');
PREPARE myStmt FROM @sql;
EXECUTE myStmt;

Just to show what’s going on:

mysql> SELECT @sql;
+----------------------------------------------------+
| @sql                                               |
+----------------------------------------------------+
| INSERT INTO t VALUES ('a'),('b'),('c'),('d'),('e') |
+----------------------------------------------------+
Paul McCullagh answers your questions about PBXT
+3 Vote Up -0Vote Down

Following on from our earlier announcement, Paul McCullagh has responded with the answers to your questions – as well as a few I gathered from other Percona folks, and attendees of OpenSQL Camp. Thank you Paul!

What’s the “ideal” use case for the PBXT engine, and how does it compare in performance?  When would I use PBXT instead of a storage engine like MyISAM, InnoDB or XtraDB?

Unfortunately it is not possible to point to a specific category of applications and say, “PBXT will be better here, so try it”.  PBXT is a general purpose transactional storage engine, designed to perform well on a broad range of tasks, much like InnoDB.  However, PBXT’s log-based architecture makes performance characteristics different to both MyISAM and InnoDB/XtraDB. Tests show that PBXT’s performance

  [Read more...]
Microsoft's embrace of MySQL could kill it
+0 Vote Up -1Vote Down
Microsoft is now offering support for MySQL, which should give pause to every open-source company that expects to make money through support subscriptions.
Crouching dolphin, hidden bugs.
+2 Vote Up -0Vote Down
I hate it when the changelog of any MySQL release references bugs which when clicked, simply says "You do not have access to bug".
Open source and the cloud - the quick and the dead
+0 Vote Up -0Vote Down

Savio Rodrigues has published a post arguing that cloud platforms such as Amazon Web Services and Microsoft’s Azure pose a threat to the monetization of open source by specialist vendors.

Savio makes a good case based on the recent launch of AWS’s Relational Database Service, based on MySQL, and Microsoft’s support for MySQL and Tomcat on Azure:

    “When Amazon decided to offer MySQL via Amazon RDS, they did so without purchasing MySQL support from Sun. I’ve confirmed that Microsoft Azure is supporting MySQL on Azure without paying Sun for a MySQL Enterprise subscription.”

Clearly there is a threat to open source vendors from cloud-based services. Meanwhile I have previous

  [Read more...]
Log Buffer #170: a Carnival of the Vanities for DBAs
+1 Vote Up -0Vote Down

This is the 170th edition of Log Buffer, the weekly review of database blogs. Welcome. Let’s kick off this week with a double-helping of . . . 

SQL Server

There are lots of good technical posts this week. The SSIS Junkie has some observations and a straw poll on sort transform arbitration. He writes, “This post was prompted by a thread on the MSDN SSIS forum today where the poster was asking how he could replicate the behaviour of SSIS’s Sort transform using T-SQL, specifically he wanted to know how the Sort transform chooses what data to pass through when the ‘Remove

  [Read more...]
451 CAOS Links 2009.11.20
+0 Vote Up -0Vote Down

Google launches Chromium project, Terracotta acquires Quartz. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

For the latest on Oracle’s acquisition of MySQL via Sun, see Everything you always wanted to know about MySQL but were afraid to ask

# Google launched the Chromium OS open source project, a prelude to the Chrome OS, while Canonical confirmed that it is contributing to the development of Chrome OS.

# Terracotta


  [Read more...]
MySQL Performance: Conference Session @Paris
+1 Vote Up -0Vote Down

I'm presenting during MySQL Performance Session in Paris which will take place on 24th November in our office building - Sun Solution Center, 32 rue Monceau, 75008 Paris. I did not blog about to avoid to increase frustration for all people who cannot attend it.. Because even we reserved for this even the biggest conference hall in the building there is still not enough place to accept everybody.. As well we did not expect so high interest - the first invitations were sent in priority to MySQL customers, and in few days there was already no more place..

So, why I'm writing now? ;-) Just because I'm pretty sure there will be a second session! :-) I cannot say you date & place yet because it'll directly depend on the number of persons willing to attend. And if

  [Read more...]
New challenges and new location
+0 Vote Up -0Vote Down

Hello again.

After I left Pythian I was looking at a couple of other places to begin working with, but finally settled on staying in the mediterranean region, however with a small relocation.

Thus, this post is now long overdue, but I am working for a spanish company called Tuenti, which is the largest social network in spain. I am quite excited and have now settled down in Madrid, so I will be using this website in order to blog about challenges, problems, solutions and everything that comes with running a large scale deployment of MySQL.

Stay tuned for the first technical post, it’s on its way already!

Partitioning as performance booster
Employee +4 Vote Up -0Vote Down
When I developed partitioning for MySQL the main goal was
to make it easier for MySQL users to manage large tables
by enabling them to easily add and drop partitions.

It turns out that partitioning can also be used as a manner
to make MySQL more scalable. The reason is that in some
cases the storage engine have internal locks per table or
per index (one such example is the btr_search_latch in InnoDB).

So in this case adding a
PARTITION BY KEY (key_part)
PARTITIONS 4
to the table definition makes a very hot table into 4 tables
from the storage engine point of view.

This would mostly be beneficial in cases where the main
operation is primary key lookups on the table. Dividing the
indexes in cases of scans can be both positive and negative.
So this solution is definitely not a

















  [Read more...]
Full automation of DBT2 test runs in benchmark scripts
Employee +1 Vote Up -0Vote Down
My benchmark scripts was upgraded once more today.
I fixed all issues pertaining to full automation
of DBT2 runs. So now it is as easy to start a
DBT2 test run as it previously was to start a
sysbench run. Obviously DBT2 was already earlier
supported in the benchmark scripts, so what I did
now was add the final steps to make it fully
automated. This includes also generating the DBT2
load files needed to load the DBT2 database.

See the download section on www.iclaustron.com
for the tarball including some description of
how to configure sysbench and DBT2 test runs.
Flexviews 1.5.0-beta is now released at https://sourceforge.net/projects/flexviews/
+1 Vote Up -0Vote Down
New in this release:
External PHP based binary log consumer. It wraps 'mysqlbinlog' and reads settings from an .ini file.
The consumer must be running in order to refresh views and collect table change logs.
MIN/MAX and COUNT(DISTINCT) are now supported, experimentally.
Many other improvements.
How to tell if someone is bullshitting
+4 Vote Up -3Vote Down

Ever been around a group of people discussing some technology and heard Cool-Whip phrases like this?

It’s not about MySQL versus PostgreSQL, it’s about using the right tool for the job.

Or how about this one?

You need to take the important factors into account before you decide whether [hot new fad] or [trusty old solution] is best suited for your application.

Both are signs that someone might be trying to sound important. In situations like this, I’ve noticed that the people I look up to usually don’t make weighty-sounding statements about other people’s systems. They talk about what they are qualified to talk about: either they say something about their own systems, or if it’s warranted and invited, they ask intelligent questions about other

  [Read more...]
Kontrollbase is featured in OSDB Magazine this month
+0 Vote Up -1Vote Down
For those of you interested in the open source database world, you will get a good in-depth look at Kontrollbase this month in the OSDB Magazine. Keith Murphy has been kind enough to give me pages 37 through 50 to tell you all about the history, current features, and plans for the future. It’s a [...]
Kontrollbase demo back online
+0 Vote Up -0Vote Down
It’s been hectic to find a good provider even with all of the choices out there these days but I’m happy to let you know that we settled on ServerBeach for the demo server and are back online. The page load testing is positive and quick, and all features are available for you to try. [...]
MySQL Permissions – Restarting MySQL
+3 Vote Up -0Vote Down

I am working with a client that is using managed hosting on dedicated servers. This has presented new challenges in obtaining the right permissions to undertake MySQL tasks but not have either ‘root’ or ‘mysql’ access and not have to involve a third party everytime.

Adding the following to the /etc/sudoers file enabled the ability to restart MySQL.

User_Alias	DBA = rbradfor, user2, etc
Host_Alias 	DB_SERVERS = server1.example.com, server2.example.com, etc
Cmnd_Alias	MYSQL = /etc/init.d/mysqld, /usr/sbin/tcpdump

DBA DB_SERVERS = MYSQL

As you can see I also got tcpdump, which I find valuable to monitor via mk-query-digest.

Next, permissions for log files.

Showing entries 1 to 20 of 18283 Next 20 Older Entries

Planet MySQL © 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Sun Microsystems, Inc. and does not
necessarily represent the opinion of Sun Microsystem, Inc. or any other party.