Re: Newbie Question - MySQL Administrator
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 jeff_murd...@yahoo.com wrote: This is on a Mac OS X (v10.5.6) system in case that matters. 1. - MySQL Administrator Help button says: HELP Help isn't available for MySQL Administrator. Really, no help or did I screw-up the install somehow? 2. - I tried to create my first Table in MySQL Administrator but got this message: ERROR Error executing SQL commands to create table. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT NULL, `LastName` VARCHAR DEFAULT NULL, `Street1` VARCHAR DEFAULT NUL' at line 3 (error 1064) Trying to Execute this: CREATE TABLE `test`.`AddressBook` ( `RecNo` INT NOT NULL AUTO_INCREMENT, `FirstName` VARCHAR DEFAULT NULL, `LastName` VARCHAR DEFAULT NULL, `Street1` VARCHAR DEFAULT NULL, `Street2` VARCHAR DEFAULT NULL, `City` VARCHAR DEFAULT NULL, `State` VARCHAR DEFAULT NULL, `Zip` VARCHAR DEFAULT NULL, `HomePhone` VARCHAR DEFAULT NULL, `CellPhone` VARCHAR DEFAULT NULL, PRIMARY KEY (`RecNo`) ) CHARACTER SET utf8 COMMENT = 'Sample'; Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Resend: enabling storage engine with RPM install
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 ba...@xaprb.com wrote: [[...]] On Thu, Feb 19, 2009 at 6:58 PM, Jim Lyons jlyons4...@gmail.com 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.bru...@sun.com Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Resend: enabling storage engine with RPM install
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 test machine and for some reason the innodb storage engine was not installed with it. We install from RPMs so I'm not sure how to install the storage engine. If we compiled ourselves, we'd recompile but that's not an option. Does anyone know how to install a storage engine once mysql's been installed by an RPM? How does one make the selections in the first place with RPMs? We've always just taken what we got and it was sufficient. Thanks, Jim -- Jim Lyons Web developer / Database administrator http://www.weblyons.com __ This email has been scanned by Netintelligence http://www.netintelligence.com/email -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: enabling storage engine with RPM install
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 default storage engine myism and innodb. Just verify show engines on mysql prompt. On Fri, Feb 20, 2009 at 5:25 AM, Jim Lyons jlyons4...@gmail.com wrote: We have 5.0.22 installed on a test machine and for some reason the innodb storage engine was not enabled. We install from RPMs so I'm not sure how to enable the storage engine. If we compiled ourselves, we'd recompile but that's not an option. Does anyone know how to enable a storage engine once mysql's been installed by an RPM? How does one make the selections in the first place with RPMs? We've always just taken what we got and it was sufficient. Thanks, Jim -- Jim Lyons Web developer / Database administrator http://www.weblyons.com -- Krishna Chandra Prajapati MySQL DBA, Email-id: prajapat...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
Re: enabling storage engine with RPM install
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 jlyons4...@gmail.com wrote: We have 5.0.22 installed on a test machine and for some reason the innodb storage engine was not enabled. We install from RPMs so I'm not sure how to enable the storage engine. If we compiled ourselves, we'd recompile but that's not an option. Does anyone know how to enable a storage engine once mysql's been installed by an RPM? How does one make the selections in the first place with RPMs? We've always just taken what we got and it was sufficient. mysql rpm installation comes with default storage engine myism and innodb. Just verify show engines on mysql prompt. 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. You need MySQL 5.1 or newer: http://dev.mysql.com/doc/refman/5.1/en/pluggable-storage.html and even then, I don't believe any of the bundled engines are available as plugins. It's mainly for 3rd-party engines. -- Dan Nelson dnel...@allantgroup.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: InnoDB - CREATE INDEX - Locks table for too long
Hi! On Thu, Feb 19, 2009 at 2:14 PM, Claudio Nanni claudio.na...@gmail.com 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 but was locking all applications on production and had to kill it. I have requested a maintenance window but it will take long time. Since this application is scanning like crazy I'd like to do it a.s.a.p. Do you have any hint for a non locking solution? Try something like this: create table new_table like old_table; alter table new_table add key(.); insert into new_table select * from old_table where primary_key between ? and ?; Repeat the last statement until nearly finished, then: lock tables new_table write, old_table write; insert into new_table select * from old_table where primary_key ?; rename table old_table backup, new_table old_table; unlock tables; Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org