Skip navigation links

MySQL Forums :: MyISAM :: Indexes disabled by default?


Advanced Search

Re: Indexes disabled by default?
Posted by: Peter Wood ()
Date: January 31, 2006 02:33PM

Ingo Strüwing wrote:
> I tried to use your my.cnf, but still cannot
> repeat the problem.
>
> How did you get at the binary of your MySQL 5.0.18
> version?
>


We have actually figured out a workaround to the problem. Apparently, there is a bug where if you specify any value for the --with-max-indexes parameter, indexes are disabled. Our fix was to simply rebuild our binary and omit the --with-max-indexes flag.

Previously, we were using the following line to configure the build:

~~~~~~~

./configure \
--prefix=/mysql/mysql \
--datadir=/mysql/data \
--without-debug \
--with-embedded-server \
--with-extra-tools \
--with-mysqlmanager \
--with-bench \
--with-big-tables \
--without-innodb \
--with-max-indexes=128
~~~~~~~~

We redid the build using these options and it worked fine:

~~~~~~~~
./configure \
--prefix=/mysql/mysql \
--datadir=/mysql/data \
--without-debug \
--with-embedded-server \
--with-extra-tools \
--with-mysqlmanager \
--with-bench \
--with-big-tables \
--without-innodb
~~~~~~~~

For reference, here is an entry in the commits mailing list regarding the bug:

http://lists.mysql.com/commits/998

And here is a related bug report:

http://bugs.mysql.com/bug.php?id=10932

Options: ReplyQuote


Subject Views Written By Posted
Indexes disabled by default? 3182 Peter Wood 01/27/2006 10:18AM
Re: Indexes disabled by default? 1861 Ingo Strüwing 01/30/2006 04:02AM
Re: Indexes disabled by default? 1846 Peter Wood 01/30/2006 08:44AM
Re: Indexes disabled by default? 1918 Ingo Strüwing 01/31/2006 03:47AM
Re: Indexes disabled by default? 2032 Peter Wood 01/31/2006 02:33PM


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.