MySQL Forums
Forum List  »  NDB clusters

Re: insert update speed
Posted by: Josh B
Date: July 21, 2006 02:55PM

Our usual MRTG box got 6 video cards installed and setup for a 6 panel video demonstration, so our support guy had to build a new one and get it setup. Our traffic isn't bad, and our insert and updates have speed up and havn't caused any issues. We set engine_condition_pushdown on a global basis and man was that quick. The site was flying through pages and such but we had one problem.

Got error 1 'Unknown error code' from ndbcluster

Which I couldn't help but laugh at for the vagueness of it. Turns out it is a bug in mysql 5.0.22, it should of made it into the build but didn't, 5.0.23 and 5.0.24 have the fix, see we have a table we do a lookup on, it has a id field and a varchar field, the varchar field has a index since the table is 30,000 records. Its the only thing we get an error on. So I'm going to see if we can set it in stored procedures to turn this value on when needed and wait to see when we should do an upgrade to completlly resolve this issue. I'm also waiting for 5.1 to be a stable release.

Options: ReplyQuote


Subject
Views
Written By
Posted
1707
July 15, 2006 04:59PM
1095
July 16, 2006 04:08PM
1154
July 17, 2006 09:34AM
1006
July 17, 2006 04:10PM
Re: insert update speed
1115
July 21, 2006 02:55PM


Sorry, you can't reply to this topic. It has been closed.

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.