RE: default table type = innodb is stable??

this is my error log file. InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes InnoDB: than specified in the .cnf file 0 268435456 bytes! Your problem here is that you must have started MySQL when you had a 5MB transaction log file specified, but you then put a new

Re: default table type = innodb is stable??

Is that stable if i started mysql server by defining default_table_type = INNODB at the my.cnf file? from which by default my.cnf is defining MYISAM table to be the defaulted. Richard Dale wrote: this is my error log file. InnoDB: Error: log file ./ib_logfile0 is of different size

Re: default table type = innodb is stable??

- Original Message - From: Hiu Yen Onn [EMAIL PROTECTED] if i uncomment it, then mysql server wont start at all. if i comment it, then, that's ok. please advise. thanks again If the mysql server does not start it will probably leave a lot of messages in the error log. If you send the

Re: default table type = innodb is stable??

release. i have a machine with 6G memory, What is the architecture of the server? x86? Hiu Yen Onn wrote: hi, i have a machine with 6G memory, loaded with RHEL4. now, my question is mysql support innodb as the default table type? will be stable running RHEL4? i saw /usr/share/mysql

Re: default table type = innodb is stable??

Jigal van Hemert wrote: - Original Message - From: Hiu Yen Onn [EMAIL PROTECTED] if i uncomment it, then mysql server wont start at all. if i comment it, then, that's ok. please advise. thanks again If the mysql server does not start it will probably leave a lot of

default table type = innodb is stable??

hi, i have a machine with 6G memory, loaded with RHEL4. now, my question is mysql support innodb as the default table type? will be stable running RHEL4? i saw /usr/share/mysql/my-innodb-heavy-4G.cnf file, then, i replace the existing one (/etc/my.cnf). but, it failed to start the mysql

Re: default table type = innodb is stable??

Currently i have 4 Gbyte RAM and RH 9 Linux using InnoDB and yes, it's stable :) Hiu Yen Onn wrote: hi, i have a machine with 6G memory, loaded with RHEL4. now, my question is mysql support innodb as the default table type? will be stable running RHEL4? i saw /usr/share/mysql/my-innodb

Re: default table type = innodb is stable??

Are you using the my-innodb-heavy-4G.cnf file for your machine? i loaded the cnf file to /etc/my.cnf. then, it fails to start. what's wrong with it? mind to tell me on how to set the default table type equal to innodb?perhaps, can you guide me for cnf configuration for a 6G memory big machine

Re: default table type = innodb is stable??

hereby, i attached the my.cnf file. by default, i copied it from /usr/share/mysql/my-huge.cnf. however, i have added default table type = INNODB. from the my.cnf, i can see that there are flags for innodb table, starting from # Uncomment the following if you are using InnoDB tables

INNODB as default table type

Hallo, is it possible to use as a default INNODB instead of ISAM in a mysql server, so that every table, database (at least the complete server) is based on a INNODB tablespace? Is this a practical and good way to use mysql in that setup, if possible? regards Harald -- MySQL General

Re: INNODB as default table type

? Take a look at --default-table-type option of mysqld: http://www.mysql.com/doc/en/Command-line_options.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net

Re: INNODB as default table type

, if possible? No, at least not unless you disable the grant tables in the mysql database. Those tables must be MyISAM tables. You can set the default table type for new table using the --default-table-type, as Egor has already mentioned. -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL

Re: default table type

You can select default table type at mysqld startup: mysqld --default-table-type=tabletype Pierre Baridon wrote: how can i change the default table type ? (innodb instead of myisam) thanks, Pierre -- sql,query

Re: default table type

Pierre Baridon [EMAIL PROTECTED] writes: how can i change the default table type ? (innodb instead of myisam) In the startup-script for mysql, add --default-table-type=innodb as an option to safe_mysqld. -- - håkon

RE: default table type

Add this to your my.cnf file : # The MySQL server [mysqld] # Default table type for new tables default-table-type=InnoDB CB. -Original Message- From: Pierre Baridon [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 12:09 To: [EMAIL PROTECTED] Subject: default table type how

default table type

Hi! Is it possible to change default table type from MyISAM to InnoDB, for example by putting set-variable = table_type=InnoDB line into my.cnf file? Thanks Rafa - Before posting, please check: http://www.mysql.com

Re: default table type

Rafal, Hi! Is it possible to change default table type from MyISAM to InnoDB, for example by putting set-variable = table_type=InnoDB line into my.cnf file? Starting from 3.23.43 you can put default-table-type=innodb to my.cnf. Before .43 it was default-table-type=innobase Thanks Rafal