Hi!
On Thu, Feb 19, 2009 at 2:14 PM, Claudio Nanni wrote:
> I need to add an index on a table on a production server.
> It is one 7Gb InnoDB table with single .ibd file (one_file_per_table),
> the index creation on preprod server took 40 minutes but table was smaller.
> I tried to add the index b
In the last episode (Feb 20), Jim Lyons said:
> On Fri, Feb 20, 2009 at 12:59 AM, Krishna Chandra Prajapati wrote:
> > On Fri, Feb 20, 2009 at 5:25 AM, Jim Lyons wrote:
> >> We have 5.0.22 installed on a test machine and for some reason the
> >> innodb storage engine was not enabled. We install f
yes, but how does one add engines to an existing install? Is it possible?
I might want/need to add a storage engine that was not in the initial
install.
On Fri, Feb 20, 2009 at 12:59 AM, Krishna Chandra Prajapati <
prajapat...@gmail.com> wrote:
> Hi Jim,
>
> mysql rpm installation comes with def
Jim,
Where did you get your RPM from?
Regards
John
> Sorry, but I'm resending because I made a mistake in terminology and want
> to
> be clear. The problem isn't that innodb is "DISABLED" on the database.
> The
> innodb engine is not supported by the database.
>
> We have 5.0.22 installed on a
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
The online help for mysql administrator is here:
http://dev.mysql.com/doc/administrator/en/index.html
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Fri, Feb 20, 2009 at 7:17 AM, Jeff Murdock wrote:
> This is on a Mac OS X (v10.5.6) s
