Much thanks, that did the trick.
Pierre
Jasper Bryant-Greene <[EMAIL PROTECTED]> wrote:
P. Evans wrote:
> skip-innodb is commented out,thats why its not in the options I sent
> previously.
> The logs are showing something peculiar -
> InnoDB: Error: log file ./ib_logfile0 is of different si
P. Evans wrote:
skip-innodb is commented out,thats why its not in the options I sent
previously.
The logs are showing something peculiar -
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 268435456 bytes!
ls shows
skip-innodb is commented out,thats why its not in the options I sent
previously.
The logs are showing something peculiar -
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 268435456 bytes!
ls shows :
drwxr-x--- 2
Hello.
> Anywhere else I can check for that ?
Send the output of 'show variables'. I'm especially interested
in version, and have_innodb. Are there any lines in the error
log similar to "InnoDB: Started"? BTW, options to MySQL Server
could be passed in several different ways:
http://dev
P. Evans wrote:
Shawn,
as far as I can tell, no. Here's all my innodb options set in my.cnf :
Well, it's easy to check:
grep skip-innodb my.cnf
Is there anything interesting in the logs, maybe on MySQL startup?
Jasper
--
MySQL General Mailing List
For list archives: http://lists
Shawn,
as far as I can tell, no. Here's all my innodb options set in my.cnf :
innodb_additional_mem_pool_size = 16M
innodb_buffer_pool_size = 4G
innodb_data_file_path = ibdata1:10M:autoextend
innodb_file_io_threads = 4
innodb_thread_concurrency = 16
innodb_flush_log_at_trx_commit = 1
inno
Is your server configured with "skip-innodb" ? It's an option that turns
off support to that engine forcing it to elect a different method of
storage.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"P. Evans" <[EMAIL PROTECTED]> wrote on 11/10/2005 10:10:44 AM:
> Here's a
Here's an example :
mysql> create table petest (col1 integer,col2 char(5)) engine=innodb;
Query OK, 0 rows affected, 1 warning (0.07 sec)
mysql> show warnings
-> ;
+-+--++
| Level | Code | Message
P. Evans wrote:
Whenever I try to create a table using innodb, i get a 1266 warning that the
table has been created with myisam instead. I receive the error both at the
mysql command line and using the mysql query browser.
Can you please show us the CREATE TABLE command that you are using?
