Hi!
On Aug 13, 2008, at 5:04 PM, Arjen Lentz wrote:
For rapid high volume inserts (data acquisition, web clicks), InnoDB
is too slow.
And MyISAM outperforms both Archive and CSV; the final bottleneck is
not disk I/O, it's CPU.
For write speed? Never once seen that happen. If you had tiny rows
with constant select while INSERT then maybe. Can you get me a
benchmark showing this?
Antony tells me that replacing the zlib in Archive with the lzh
(sp?) library reduces CPU significantly.
LZH is much slower and hogs CP. You do get slightly better compression
out of it. We looked at this early on and dismissed it for this reason.
The current state of Maria can already replace MyISAM, can't it.
No, Maria is still in Alpha. I expect them to have a working engine
that is rock solid in about a year. I keep up a dialogue with Monty on
this, since I think we will eventually add it, but right now it is
nowhere near ready to go in. I am not against including it as a plugin
when they are ready (assuming someone will keep patches going back and
forth) but they have a few months worth of work to make that happen.
Cheers,
-Brian
--
_______________________________________________________
Brian "Krow" Aker, brian at tangent.org
Seattle, Washington
http://krow.net/ <-- Me
http://tangent.org/ <-- Software
_______________________________________________________
You can't grep a dead tree.
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
