Error 1030 table_handler error 12

Inspection of the mysql.log shows that the failing sql query alter table foo add index foodex( colone, coltwo, colthree); where foo is a BerkeleyDB type table with 150,000 entries of 500 bytes organized into 10 fields dies when it runs out of locks. How does one change the size of the

Re: MySQL eats 99& CPU time problem help

> On Wed, Dec 11, 2002 at 11:12:33AM -0500, shawn xu wrote: > > We have MySQL 3.23.53 running on Intel machine with OS > > BSDI 4.3. > > > > The problem happened more often like this. > > > > MySQL eated up 99% cpu time which was told by running > > "top". When this happened, I guess it still an

Re: Building Web Pages

> Does anyone know of a package that computer novices can use to build simple > web pages. Even if they know nothing of HTML? > > I'm using mysql and I figure there might be something out there all ready > built. This is for a small college that teachers can use to put on there > stuff. > typo/g

BDB and mysql problem

Using the sql: alter table foo add index dex( keycol1, keycol2, keycol3 ); causes a Error 1030 with the annotation "table handler error 12". The particular table involved has about 15 entries, contains 10 or so varchar() fields with a record size of O(500) bytes. The table is decla

Re: opaque error message [2]

I have found a work around, but I do wonder what the problem is with MySQL and BDB tables. When I rerun the load with the table type set to ISAM it all works. Looks like there may be some limitation of the BDB implementation I am triggering. In my previous post, I reported receiving an Error

Opaque mysql error ...

I have a moderately large database (150K records of nine fields, a bit under 500 bytes per record with a primary key. The database is of Type BDB. To improve query performance I concluded I needed to add a three element index. Running alter table foo add index udex( w_1, w_2, w3 );