?

Log in

No account? Create an account
x86 on IA-64 - brad's life — LiveJournal [entries|archive|friends|userinfo]
Brad Fitzpatrick

[ website | bradfitz.com ]
[ userinfo | livejournal userinfo ]
[ archive | journal archive ]

x86 on IA-64 [Dec. 27th, 2004|10:54 am]
Brad Fitzpatrick
I'm running a CPU-heavy app on an Itanium2 box now. For a while I couldn't get it to compile IA-64 so I was using the x86 binary.... 100% CPU. Got it to rebuild and it's now at 80% CPU and running 4x faster.
LinkReply

Comments:
[User Picture]From: brad
2004-12-27 10:08 pm (UTC)
InnoDB checksum validator... pulling 16k at a time off a 340 GB file and verifying the checksum of that database pages matches what it thinks it is.
(Reply) (Parent) (Thread)
From: jamesd
2004-12-27 10:44 pm (UTC)

InnoDB checksum validator

Please say more about the InnoDB checksum validator. Something other than check table?
(Reply) (Parent) (Thread)
[User Picture]From: brad
2004-12-27 11:59 pm (UTC)

Re: InnoDB checksum validator

Yeah, it does the same per-16k-page integrity checks that InnoDB does itself. marksmith basically gutted the InnoDB source code and found the checksumming bits and made an independent tool:

http://www.livejournal.com/~xb95/260706.html

We gave them permission to own the code and include it in the next version of MySQL ... we'll see if they do.
(Reply) (Parent) (Thread)
From: jamesd
2004-12-28 12:59 am (UTC)

Re: InnoDB checksum validator

Thanks. I want that.:) Arjen was in IRC and I told him as much, told him that I was telling you that you could say Wikipedia wants it as well if you like... He mentioned that if you want it in the next version it's really up to you to watch over it and make sure it's in there.

I like the sound of compaction as well. Also defragmentation. Journal post coming up about that...
(Reply) (Parent) (Thread)