Deryck, in MySQL -Max the only thing that differs from MySQL is the binary mysqld. To install MySQL -Max in place of MySQL you only need to replace the binary. You do not need to uninstall MySQL-3.23.41.
If you have defined InnoDB options in my.cnf like explained in the manual http://www.innodb.com/ibman.html: ... 2 InnoDB startup options To use InnoDB tables you must specify configuration parameters in the MySQL configuration file in the [mysqld] section of the configuration file `my.cnf'. Suppose you have a Windows NT machine with 128 MB RAM and a single 10 GB hard disk. Below is an example of possible configuration parameters in `my.cnf' or 'my.ini' for InnoDB: [mysqld] # You can write your other MySQL server options here # ... # innodb_data_home_dir = c:\ibdata innodb_data_file_path = ibdata1:2000M;ibdata2:2000M set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = c:\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 Note that data files must be < 4G, and < 2G on some file systems! The combined size of data files must be >= 10 MB. InnoDB does not create directories: you have to create them yourself. ... and have got MySQL -Max to start, then you can convert your MyISAM tables like explained in the manual: ... 4.1 Converting MyISAM tables to InnoDB InnoDB does not have a special optimization for separate index creation. Therefore it does not pay to export and import the table and create indexes afterwards. The fastest way to alter a table to InnoDB is to do the inserts directly to an InnoDB table, that is, use ALTER TABLE ... TYPE=INNODB, or create an empty InnoDB table with identical definitions and insert the rows with INSERT INTO ... SELECT * FROM .... To get better control over the insertion process, it may be good to insert big tables in pieces: INSERT INTO newtable SELECT * FROM oldtable WHERE yourkey > something AND yourkey <= somethingelse; After all data has been inserted you can rename the tables. During the conversion of big tables you should set the InnoDB buffer pool size big to reduce disk i/o. Not bigger than 80 % of the physical memory, though. You should set InnoDB log files big, and also the log buffer large. Make sure you do not run out of tablespace: InnoDB tables take a lot more space than MyISAM tables. If an ALTER TABLE runs out of space, it will start a rollback, and that can take hours if it is disk-bound. In inserts InnoDB uses the insert buffer to merge secondary index records to indexes in batches. That saves a lot of disk i/o. In rollback no such mechanism is used, and the rollback can take 30 times longer than the insertion. ... Regards, Heikki At 02:23 PM 10/4/10 -0500, you wrote: >Yes, I know, go look at the web site, but it's too confusing :(. I have >found out how to setup and start with MySQL and InnoDB but I have no clue >how to make my tables/databases InnoDB type. Oh, and, I just upgraded to >MySQL Max 3.23.42 for Win32 but all of the previous stuff from MySQL 3.23.41 >are still lurking around and messing up stuff. I tested this by moving the >Data folder (my new one) somewhere else and my other (older) data folder >somewhere else but I still got the data when I put a query to it. I just >want to completely uninstall MySQL 3.23.41 and keep 3.23.42 Max. Any ideas? >Thanx. > >************** >- Deryck Henson >- http://www.comp-u-exchange.com >************** >----- Original Message ----- >From: "Heikki Tuuri" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Friday, October 05, 2001 2:18 AM >Subject: Re: InnoDB Tables/Databases > > >> Deryck, >> >> the latest information on InnoDB you can always find at >> http://www.innodb.com >> >> Regards, >> >> Heikki >> Innobase Oy >> >> >> >Here is two thing for you. >> > >> >First, GREAT source for search of pass problem on any thing really. >> > >> >http://marc.theaimsgroup.com/ >> > >> >Then, information on the InnoDB. Not hard to find really. >> > >> >>http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html# >I >> >nnoDB >> > >> >Have a good reading. >> > >> >Daniel >> >> >> >> OK, I will soon have a huge database, home to about 500,000,000+ >> >> records and >> >> believe that MySQL needs to be faster. I have heard good things about >> >> InnoDB but Ihave no idea what it is. Can someone please tell me >> >> (or give a >> >> url telling) what it is, the benifits, how I can set it up on an >already >> >> existing database, and what it can do for me. Thank you. Also, if >anyone >> >> knows a very good search query for this that would be good for a >high-end >> >> search engine (google, yahoo, etc), please let me know. Thank You. >> >> >> > >> > >> >> >> >> --------------------------------------------------------------------- >> Before posting, please check: >> http://www.mysql.com/manual.php (the manual) >> http://lists.mysql.com/ (the list archive) >> >> To request this thread, e-mail <[EMAIL PROTECTED]> >> To unsubscribe, e-mail ><[EMAIL PROTECTED]> >> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
