Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 61 to 70 of 72 2 Older Entries

Displaying posts with tag: storage (reset)

Managing a Bestseller
Employee +0 Vote Up -0Vote Down

There are a couple of bookstores in my neighborhood. They could not be more different from one another.

The first is known to focus on best seller lists, to promote popular books, and use displays and traditional retail techniques to drive business. They seem to do well, year in, year out. The other bookstore is more of a community treasure, beloved by the neighborhood, with a focus on the (thoughtful) insights of their staff. Those insights are delivered via small note cards appended to shelving throughout the store, where books are displayed alphabetically, with library-like neutrality.

…  [Read more...]
How much DataMemory+IndexMemory do you need for disk data?
Employee_Team +0 Vote Up -0Vote Down

One thing we were guessing at with Massimo yesterday is, if you store
large blobs as disk data, how much will they consume DataMemory and
IndexMemory (primary key, each "chunk" has a hidden primary key, first 25x bytes
of blob stored in memory...)?

My empirical test showed that about 2% of the total size of blobs is needed for RAM
(25% of that is IndexMemory).

IMHO this is close to negligible, but in many situations not negligible
at all (may have close to TB of disk data -> 20GB of RAM needed for
disk data).

Also note that this is a minimum figure. …







  [Read more...]
How much DataMemory+IndexMemory do you need for disk data?
Employee_Team +0 Vote Up -0Vote Down

One thing we were guessing at with Massimo yesterday is, if you store
large blobs as disk data, how much will they consume DataMemory and
IndexMemory (primary key, each "chunk" has a hidden primary key, first 25x bytes
of blob stored in memory...)?

My empirical test showed that about 2% of the total size of blobs is needed for RAM
(25% of that is IndexMemory).

IMHO this is close to negligible, but in many situations not negligible
at all (may have close to TB of disk data -> 20GB of RAM needed for
disk data).

Also note that this is a minimum …







  [Read more...]
How much DataMemory+IndexMemory do you need for disk data?
Employee_Team +0 Vote Up -0Vote Down

One thing we were guessing at with Massimo yesterday is, if you store
large blobs as disk data, how much will they consume DataMemory and
IndexMemory (primary key, each "chunk" has a hidden primary key, first 25x bytes
of blob stored in memory...)?

My empirical test showed that about 2% of the total size of blobs is needed for RAM
(25% of that is IndexMemory).

IMHO this is close to negligible, but in many situations not negligible
at all (may have close to TB of disk data -> 20GB of RAM needed for
disk data).

Also note that this is a minimum …







  [Read more...]
You Have to Stop to Change Direction
Employee +0 Vote Up -0Vote Down

The bursting of the internet bubble was good for the computer industry.

Many of us didn't like the medicine, but I can't remember a single customer upset at the idea of paying $20,000 for computing infrastructure that used to cost them $100,000. The price compression came from open source software, and a move toward general purpose servers, and resulted in companies formerly making 65% gross profit on products (Sun among them) facing a new reality.

But what doesn't kill you makes you stronger.

Since then, …

  [Read more...]
Sweet new Sun storage stuff on Monday, Nov 10th
+0 Vote Up -0Vote Down

FYI, Sun is announcing some sweet new storage stuff on Monday at 3:30pm PT.

I’m reviewing a few of the things they’re announcing, and hope to publish my thoughts here soon (one of them joins my production network tonight if all goes well). However, I’m at Disneyland with my kids (first trip!) from Monday through Thursday, so I don’t know (yet) when I’ll be able to write them up. Bear with me if it takes a few days.

But the gear is exciting, and the direction Sun is headed is even more exciting!

  [Read more...]
A cool idea - Revision engine
+0 Vote Up -0Vote Down


Yesterday I saw an announcement in the MySQL internals@ list, about a new storage engine being released. DDengine has created a revision engine, a sort of embedded proxy inside MySQL that keeps track of the changes you do to your data.
The idea is clever. You write to your table, update and delete without any concern, and the revision engine stores your changes in the background.
I wanted to tried the engine on my laptop (Mac OSX), but there was no binary available for this architecture. I contacted the authors and I received prompt …


  [Read more...]
Fanning the Winds of Change in Storage
Employee +0 Vote Up -0Vote Down

It's been over a month (and three hurricanes in America) since I've posted a blog. More than a few of you've noticed - thanks for the prodding...

It's been a busy summer, on nearly every front. Customer activity hasn't slowed down, and the good news surrounding the (otherwise unfortunate) economic crisis embroiling many customers (especially those in the financial services industry, a heavy concentration for Sun) is that it's whipping up the winds of change. Customers facing spending pressure, or tiring of vendor price increases have new options, and there's a new appetite to explore those options (nothing like mandates from the CEO to reduce spending by 50%). …

  [Read more...]
Using the 'EXAMPLE' storage engine on MySQL 5.1.24-rc
Employee +0 Vote Up -0Vote Down

MySQL 5.1.24-rc ships with a EXAMPLE storage engine which is basically a dummy storage engine and serves as a useful source to start writing your own custom storage engine.

However, it is not available for use, by default. You can verify this as follows:

mysql> show engines;

+------------+---------+-----------------------------------------------------------+--------------+----+------------+ | Engine     | Support | …


  [Read more...]
Using the 'EXAMPLE' storage engine on MySQL 5.1.24-rc
Employee +0 Vote Up -0Vote Down

MySQL 5.1.24-rc ships with a EXAMPLE storage engine which is basically a dummy storage engine and serves as a useful source to start writing your own custom storage engine.

However, it is not available for use, by default. You can verify this as follows:

mysql> show engines;

+------------+---------+-----------------------------------------------------------+--------------+----+------------+ | Engine     | Support | …


  [Read more...]
10 Newer Entries Showing entries 61 to 70 of 72 2 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.