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 answer
queries,
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
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
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.
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 );
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