Databases
347 views | +0 today
Follow
Your new post is loading...
Your new post is loading...
Scooped by gilg
Scoop.it!

MySQL Performance: InnoDB vs MyISAM in 5.6

MySQL Performance: InnoDB vs MyISAM in 5.6 | Databases | Scoop.it

Since the latest changes made recently within InnoDB code (MySQL 5.6) to improve OLTP Read-Only performance + support of full text search (FTS), I was curious to compare it now with MyISAM..

more...
No comment yet.
Scooped by gilg
Scoop.it!

Knowing what pt-online-schema-change will do

Knowing what pt-online-schema-change will do | Databases | Scoop.it

pt-online-schema-change is simple to use, but internally it is complex.  Baron’s webinar about pt-online-schema-change hinted at several of the tool’s complexities.  Consequently, users often want to know before making changes what pt-online-schema-change will do when it runs.  The tool has two options to help answer this question: –dry-run and –print.

more...
No comment yet.
Scooped by gilg
Scoop.it!

Dude, where is my memory? - MySQL-dump

Dude, where is my memory? - MySQL-dump | Databases | Scoop.it

"Kris, please have a look at our database. We are running a materialized dataset processor, and on a database with about 40 GB of buffer pool and a database size of 6 GB, we are observing swapping."

Now, that is interesting. The box in question has 48 GB of memory, and indeed, hardly 6 GB of data.

more...
No comment yet.
Scooped by gilg
Scoop.it!

Mikael Ronstrom: My personal list of new features in MySQL 5.6

This blog post simply lists and describes a few of the most interesting new features in MySQL 5.6. The list is simply my preferences based on my development interest and what I think is very interesting feaures in general.

more...
No comment yet.
Scooped by gilg
Scoop.it!

» Identifying and killing blocking transactions in InnoDB Todd's MySQL Blog

The MySQL Server has a few options to help deal with transactions holding InnoDB locks for excessive periods of time.  The –innodb-lock-wait-timeoutoption is one such option, but that just affects statements waiting on locks already held by another transaction.  If you want to ensure your application isn’t holding locks for long periods of time to start with, what options do you have?

more...
No comment yet.
Scooped by gilg
Scoop.it!

MongoDB: Covered Indexes vs. Clustered Fractal Tree Indexes | Tokutek

MongoDB: Covered Indexes vs. Clustered Fractal Tree Indexes | Tokutek | Databases | Scoop.it
MongoDB’s covered indexes can provide some performance benefits over a regular MongoDB index, as they reduce the amount of IO required to satisfy certain queries.
more...
No comment yet.
Scooped by gilg
Scoop.it!

Karlsson on databases and stuff: So, what is the client/server protocol overhead then? Or: How MySQL can finally kick some MongoDB ****

Karlsson on databases and stuff: So, what is the client/server protocol overhead then? Or: How MySQL can finally kick some MongoDB **** | Databases | Scoop.it
So, what is the client/server protocol overhead then? Or: How MySQL can finally kick some MongoDB ****
more...
No comment yet.
Scooped by gilg
Scoop.it!

Optimizing IN() queries against a compound index at Xaprb

Optimizing IN() queries against a compound index at Xaprb | Databases | Scoop.it

Unfortunately, MySQL 5.5 doesn’t generate a very good query execution plan for IN() queries against a compound (multi-column) index, such as the following query that should be able to use the 2-column primary key

more...
No comment yet.
Scooped by gilg
Scoop.it!

MySQL Indexing Best Practices: Webinar Questions Followup - MySQL Performance Blog

MySQL Indexing Best Practices: Webinar Questions Followup - MySQL Performance Blog | Databases | Scoop.it

I had a lot of questions on my MySQL Indexing: Best Practices Webinar (both recording and slides are available now) We had lots of questions. I did not have time to answer some and others are better answered in writing anyway.

more...
No comment yet.
Rescooped by gilg from Open Source, Search and NoSQL
Scoop.it!

Cassandra vs MongoDB vs CouchDB vs Redis vs Riak vs HBase comparison :: Software architect Kristof Kovacs

Cassandra vs MongoDB vs CouchDB vs Redis vs Riak vs HBase comparison :: Software architect Kristof Kovacs | Databases | Scoop.it

While SQL databases are insanely useful tools, their monopoly of ~15 years is coming to an end. And it was just time: I can't even count the things that were forced into relational databases, but never really fitted them.

But the differences between NoSQL databases are much bigger than it ever was between one SQL database and another. This means that it is a bigger responsibility on software architects to choose the appropriate one for a project right at the beginning.


Via David Pilato
more...
No comment yet.
Rescooped by gilg from Open Source, Search and NoSQL
Scoop.it!

NoSQL Data Modeling Techniques

NoSQL Data Modeling Techniques | Databases | Scoop.it
NoSQL databases are often compared by various non-functional criteria, such as scalability, performance, and consistency. This aspect of NoSQL is well-studied both in practice and theory because specific non-functional properties are often the main justification for NoSQL usage and fundamental results on distributed systems like the CAP theorem apply well to NoSQL systems. At the same time, NoSQL data modeling is not so well studied and lacks the systematic theory found in relational databases. In this article I provide a short comparison of NoSQL system families from the data modeling point of view and digest several common modeling techniques.

Via David Pilato
more...
No comment yet.
Scooped by gilg
Scoop.it!

A few stats, rumors and stories on Hadoop's rapid growth

A few stats, rumors and stories on Hadoop's rapid growth | Databases | Scoop.it
The largest players in the Hadoop market are already raising money and sky-high valuations, employing hundreds of people and, in some cases, looking at nine-figure revenues.
more...
No comment yet.
Scooped by gilg
Scoop.it!

MySQL Lists: announce: MySQL Community Server 5.6.8-rc has been released

MySQL Lists: announce: MySQL Community Server 5.6.8-rc has been released | Databases | Scoop.it
MySQL Server 5.6.8 (Release Candidate) is a new version of the world's most popular open source database. The new features in this release are of Release Candidate quality. As with any other pre-production release, caution should be taken when installing on production level systems or systems with critical data.
more...
No comment yet.
Scooped by gilg
Scoop.it!

The Brain Of The Beast: Google Reveals The Computers Behind The Cloud : NPR

For years, Google has kept mostly silent about the technology that has made it one of the leaders in cloud computing. Now, for the first time, Google has opened the doors of its data centers to the outside.
more...
No comment yet.
Scooped by gilg
Scoop.it!

Damn Cool Algorithms: Cardinality Estimation - Nick's Blog

Damn Cool Algorithms: Cardinality Estimation

Posted by Nick Johnson | Filed under python, cardinality-estimation, damn-cool-algorithms

Suppose you have a very large dataset - far too large to hold in memory - with duplicate entries. You want to know how many duplicate entries, but your data isn't sorted, and it's big enough that sorting and counting is impractical. How do you

more...
No comment yet.
Scooped by gilg
Scoop.it!

Staying out of MySQL’s danger zone at Xaprb

Staying out of MySQL’s danger zone at Xaprb | Databases | Scoop.it

MySQL is a great database server. It has lots of flaws, but if you work with its strong points and try to minimize its weaknesses, it works fantastically well for a lot of use cases. Unfortunately, if you bang on its weak points, sometimes you get hit by falling bricks.

more...
No comment yet.
Scooped by gilg
Scoop.it!

Facebook is collecting your data -- 500 terabytes a day

Facebook is collecting your data -- 500 terabytes a day | Databases | Scoop.it
How much of your data is Facebook collecting every day? Some new stats from the company reveal just how large its user base is, and what big data means to a company with 950 million users.
more...
No comment yet.
Scooped by gilg
Scoop.it!

Recovery after DROP & CREATE - MySQL Performance Blog

Recovery after DROP & CREATE - MySQL Performance Blog | Databases | Scoop.it

In a very popular data loss scenario a table is dropped and empty one is created with the same name

more...
No comment yet.
Scooped by gilg
Scoop.it!

Disappearing test cases or did another part of MySQL just become closed source? « The MariaDB Blog

more...
No comment yet.
Scooped by gilg
Scoop.it!

Announcing Percona XtraBackup 2.0.2 - MySQL Performance Blog

Announcing Percona XtraBackup 2.0.2 - MySQL Performance Blog | Databases | Scoop.it

Percona is glad to announce the release of Percona XtraBackup 2.0.2 on August 13th, 2012. Downloads are available from our download site here and Percona Software Repositories.

This release is the current GA (Generally Available) stable release in the 2.0 series.

more...
No comment yet.
Scooped by gilg
Scoop.it!

No more locks with Xtrabackup « Code as Craft

No more locks with Xtrabackup « Code as Craft | Databases | Scoop.it

No more locks with Xtrabackup

 

Posted by Arie Kachler | Filed under databases, operations

Percona’s Xtrabackup is a great product. It performs binary backups of heavily loaded Mysql servers amazingly fast. We’ve used it here at Etsy for years and works very well for us. Mysqldump is another way of doing backups, but for servers with hundreds of gigabytes of data, it’s too slow to be useful, especially for restoring a backup. It can literally take days to restore a couple of hundred of gigabytes generated with Mysqldump. Usually when you need to restore from a backup, you’re in some sort of emergency, and waiting days is not an option.

more...
No comment yet.