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??

Hello. i saw /usr/share/mysql/my-innodb-heavy-4G.cnf file, then, i replacethe existing one (/etc/my.cnf). but, it failed to start the mysql server. please advise. thanks? What is in the error log? See: http://dev.mysql.com/doc/refman/4.1/en/error-log.html

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

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

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

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

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