Hi Brian,
On 14/08/2008, at 10:10 AM, Brian Aker wrote:
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?
I thought I'd shown you my inserter gizmo at the MySQL Conf.
The test uses 60 byte rows, single thread, no selects.
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.
Update... the library I meant was LZO.
Anyway as I mentioned on IRC, I have some ideas on this; will hack out
something, see how it behaves, and report back.
Also for indexing.
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.
Maria could just have its own BZR tree, since it's pluggable. right?
Cheers,
Arjen.
--
Arjen Lentz, Founder @ Open Query
Training and Expertise for MySQL in Australia and New Zealand
http://openquery.com.au/training/ (ph. +61-7-3103 0809)
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
