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 );
genearated some error condition
Error 1030 table_handler error 12
A net posting suggested
set SQL_BIG_TABLES=1
as a solution, but it made no change.
I then exported the table modified the create statement to include the index,
and then attempted to load the result. It ran along fine, but eventually
crashed the server producing
Error 2002, Cannot connect to server
diagnostics--lots of them.
The host machine is a dual processor Athlon with 2GB of memory. Operating system is
Linux, RH7.3.
Can anyone suggest what might be the problem? Thanks.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php