Hi Jim, all!
Jim Lyons wrote:
> Yes, I had a slip of the mind. The engine that was not supported by the
> install is the Federated engine. I apologize, I had a blind spot. The
> "SHOW ENGINES" command lists FEDERATED but has NO in the Support column.
>
> The question, though, is how does one add an unsupported engine to an RPM
> install? Is it possible? Otherwise I have to either compile from source or
> upgrade to a version that I hope will have it.
You cannot add an engine later to a MySQL 5.0 binary.
This will change with newer versions when plugins can be used for table
handlers.
>
> On Thu, Feb 19, 2009 at 10:08 PM, Baron Schwartz <baron@stripped> wrote:
>
>> [[...]]
>>
>> On Thu, Feb 19, 2009 at 6:58 PM, Jim Lyons <jlyons4435@stripped> wrote:
>>> [[...]]
>>>
>>> We have 5.0.22 installed on a test machine and for some reason the innodb
>>> storage engine was not installed with it. We install from RPMs [[...]]
Let me repeat: 5.0.22 on a test machine? We built those binaries in
May, 2006, so they are nearly three years old by now. Are your tests
that thorough?
I checked the logs, and I found that for some reason which I really
don't know any more the "federated" engine was not configured in that
version.
The oldest community builds in which I find it configured are 5.0.41 and
5.0.45, which you can still get from the archive (accessible via the
download page).
There were some issues with "federated" which later caused us to disable
it by default, so it is configured in recent versions but not enabled in
the "my.cnf" coming with the packages.
Some more info can be found in bug report #37069:
http://bugs.mysql.com/bug.php?id=37069
Whatever you decide about "federated", you definitely should upgrade
from 5.0.22 to some current versions - there were several important
bugfixes (including security issues) which you are lacking.
And in your next posting, please specify exactly which packages you are
using - platforms *do* make a difference in some cases.
HTH,
Jörg
--
Joerg Bruehe, MySQL Build Team,
Joerg.Bruehe@stripped
Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028
