List:General Discussion« Previous MessageNext Message »
From:Joerg Bruehe Date:March 4 2011 3:03pm
Subject:Re: how to RE-add innoDB storage?
View as plain text  
Hi ed, all!


ed wrote:
> I have recently noticed I can not access a PHP application's data files,
> and the errors I am getting seem to show that a recent update of the
> distro (mandriva) no longer supports innodb, and this may be a reason

Which version were you using before, and which one are you using now?


> (if this is not some sort of "catchall" error). I would like to know how
> to add innodb plugin back into my mysql, or to convert the data to a
> usable format. I would be pleased with a pointer to the correct rtfd
> location.

From your output, I'd say they removed or unconfigured some parts in the
source before creating binaries.
(If your previous version was taken from the same source, they did an
incompatible change IMNSHO, and I hope they did give a thorough warning.
If not, you should raise a complaint.)

> 
> 
> I guess wordwrap is going to mess this up;
> 
> 
> mysql> show engines ;
>
> +------------+---------+-----------------------------------------------------------+--------------+------+------------+
> 
> | Engine     | Support | Comment                                      |
> Transactions | XA   | Savepoints |
>
> +------------+---------+-----------------------------------------------------------+--------------+------+------------+
> 
> | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO  | NO  
> | NO  |
> | CSV                 | YES     | CSV storage engine    | NO   |
> NO         |
> | MEMORY         | YES     | Hash based, stored in memory, useful for
> temporary tables | NO           | NO   | NO         |
> | MyISAM           | DEFAULT | Default engine as of MySQL 3.23 with
> great performance    | NO           | NO   | NO         |
>
> +------------+---------+-----------------------------------------------------------+--------------+------+------------+
> 
> 
> show plugins;
> +------------+--------+----------------+---------+---------+
> | Name       | Status | Type           | Library | License |
> +------------+--------+----------------+---------+---------+
> | binlog     | ACTIVE | STORAGE ENGINE | NULL    | GPL    |
> | partition  | ACTIVE | STORAGE ENGINE | NULL    | GPL   |
> | CSV        | ACTIVE | STORAGE ENGINE | NULL    | GPL    |
> | MEMORY | ACTIVE | STORAGE ENGINE|NULL |GPL         |
> | MyISAM  | ACTIVE | STORAGE ENGINE | NULL| GPL|
> | MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL    | GPL     |


This is what "show engines" and "show plugins" report in my test build
of post-5.1.57 (complete sources):

  ===== ENGINES =====
  Engine  Support Comment Transactions    XA      Savepoints
  ndbcluster      NO      Clustered, fault-tolerant tables        NULL
  NULL    NULL
  MRG_MYISAM      YES     Collection of identical MyISAM tables   NO
  NO      NO
  BLACKHOLE       YES     /dev/null storage engine (anything you write
to it disappears)  NO      NO      NO
  CSV     YES     CSV storage engine      NO      NO      NO
  MEMORY  YES     Hash based, stored in memory, useful for temporary
tables       NO      NO      NO
  FEDERATED       NO      Federated MySQL storage engine  NULL    NULL
  NULL
  ARCHIVE YES     Archive storage engine  NO      NO      NO
  InnoDB  YES     Supports transactions, row-level locking, and foreign
keys      YES     YES     YES
  MyISAM  DEFAULT Default engine as of MySQL 3.23 with great performance
 NO      NO      NO

  ===== PLUGINS =====
  Name    Status  Type    Library License
  binlog  ACTIVE  STORAGE ENGINE  NULL    GPL
  partition       ACTIVE  STORAGE ENGINE  NULL    GPL
  ARCHIVE ACTIVE  STORAGE ENGINE  NULL    GPL
  BLACKHOLE       ACTIVE  STORAGE ENGINE  NULL    GPL
  CSV     ACTIVE  STORAGE ENGINE  NULL    GPL
  FEDERATED       DISABLED        STORAGE ENGINE  NULL    GPL
  MEMORY  ACTIVE  STORAGE ENGINE  NULL    GPL
  InnoDB  ACTIVE  STORAGE ENGINE  NULL    GPL
  MRG_MYISAM      ACTIVE  STORAGE ENGINE  NULL    GPL
  MyISAM  ACTIVE  STORAGE ENGINE  NULL    GPL
  ndbcluster      DISABLED        STORAGE ENGINE  NULL    GPL

I don't think there is a way to add those missing parts back to your
current binaries.

If you have tables using the InnoDB engine, I see these approaches you
could take:

1) Go back to the version you used previously.
   You have a full system backup, I trust ?

2) Build from source.

3) Use other binary packages, like those available directly from MySQL
   (now: Oracle).

> 
> 
> [[...]]

HTH,
Joerg

-- 
Joerg Bruehe,  MySQL Build Team,  joerg.bruehe@stripped
ORACLE Deutschland B.V. & Co. KG,   Komturstrasse 18a,   D-12099 Berlin
Geschaeftsfuehrer: Juergen Kunz, Marcel v.d. Molen, Alexander v.d. Ven
Amtsgericht Muenchen: HRA 95603
Thread
how to RE-add innoDB storage?ed4 Mar
  • Re: how to RE-add innoDB storage?Joerg Bruehe4 Mar
  • RE: how to RE-add innoDB storage?Jerry Schwartz4 Mar
    • Re: how to RE-add innoDB storage?ed5 Mar
      • Re: how to RE-add innoDB storage? kinda kludgy fixed8 Mar