This is a real question asked by Ivan Zoratti in his blog post. Another frequently heard question is : Should I still use MySQL now that my business is turning into a very serious business or should I switch to Oracle 11G.

To illustrate this question let me talked about MySQL users I met last [...]

I'll try to pass on some basic knowledge about those confusing stack traces we sometimes see in the mysql error logs.  What can you tell from them, what are they useful for, and how to validate them?
Debugging Crashes
We tried to improve postmortem debugging of crashes + stack traces in the error log:o) old versions of mysqld only printed numerical numbers instead of function names (if you're lucky!)o) some platforms/architectures printed no stack trace what-so-ever!o) …

I'm happy to announce that today we've released the first beta of Drizzle7! It's been an exciting ride so far and I'm expecting it to be only more exciting moving forward, now that I can actually say things like "yes! please try it!"

Some quick thoughts:

• We're speaking MySQL Protocol over 3306 by default - all of your MySQL connectors should work fine.
• drizzledump can read from MySQL and write to Drizzle.
• Replication has changed.
• Authentication has changed.
• Options processing has changed.
• There are tons of plugins.

We're actually going to care about breaking things moving forward. 

So... yes! please try it! I'm excited to find out what new things people are going to try to do with it. …

Yes, I said InnoDB+ with a plus sign at the end (also see the first comment here).

Please note that this blog post is only based on public information. It has absolutely nothing in it that I only could have learned from back when I worked at Sun or MySQL AB. Everything has links or pointers to where you can find the information out on the Internet and all thoughts are based on stringing these things together.

There was a lot of talk around the acquisition of Sun Microsystems by Oracle about MySQL (MySQL AB was bought by Sun). Some of the talk centred around Oracle and their ability to make a closed source version of MySQL with added bits that wouldn’t …

As an update to my prior post, I’ve added a form to the workbench plugin.  Now, the user can select a slow query log file and generate statistics from it.  The plugin provides information to answer the following questions:

Figure 1. Sample plugin form

• What type of queries run most often?
• What type of queries are the slowest?
• Which queries access the most rows?
• Which queries send the most data?

The plugin scans the slow query log, aggregates similar queries, and provides summary statistics for each group.  It’s very similar to the mysqldumpslow perl utility, which is included in the mysql bin folder. …

There is much excitement this week (understandably) about the formation of the Document Foundation and the LibreOffice fork of Openoffice.org.

Alan Bell sees correlation with the previous fork of Joomla from Mambo and has illustrated the potential impact that forking a project can have with a Google Trends chart, where Mambo is the blue line, and Joomla is the red line:

A similar chart for Debian (blue) and Ubuntu (red) is also instructive:

Or what about Nagios (blue) and Icinga (red):

Hmm. Maybe not the best example. …

Here is the comparison between mysql and postgresql for selects (only). I had used the same table that i had created earlier http://jayant7k.blogspot.com/2010/09/database-speed-tests-mysql-and.html while comparing insertion speed. I have created approximately 1,000,000 records in the table and ran selects on them. I also modified the configuration of both mysql and postgresql to enable faster

In this post I want to show three things:

1. How many single row SELECTs per second (on the PRIMARY KEY, no batching) you can do on on a Cluster with two data nodes
2. Show how MySQL Cluster scales with threads and mysql servers
3. How ndb_cluster_connection_pool affects performance

Next post will be what happens to INSERTs, and then UPDATEs.

Setup

• two data nodes
• one to four mysql servers
• interconnected with Gig-E (single NIC)
  

deployed on six computers (of varying quality, see below). www.severalnines.com/bencher was co-located with each mysql servers to drive the load. The reads were a PK SELECT like:

SELECT data1,data2 FROM t1 WHERE id=[random];

data1 and data2 are each 256B, so in total 512B was read. …

This miniconf aims to cover many of the current methods of data storage and retrieval and attempt to bring order to the universe. We’re aiming to cover what various systems do, what the latest developments are and what you should use for various applications.

We aim for talks from developers of and developers using the software in question.

Aiming for some combination of: PostgreSQL, Drizzle, MySQL, XFS, ext[34], Swift (open source cloud storage, part of OpenStack), memcached, TokyoCabinet, TDB/CTDB, CouchDB, MongoDB, Cassandra, HBase….. and more!

Call for Papers open NOW (Until 22nd October).

Umas das características mais interessantes que o MySQL adquiriu com o passar do tempo e também o que o diferencia dos outros produtos de bancos de dados é a capacidade de ser um plugable database. Esta é a característica que permite que o MySQL receba na segunda camada de sua arquitetura os plugins, sendo que [...]