Jump to content


Photo

Inno Database support in Coral 8.0


  • Please log in to reply
1 reply to this topic

#1 Yoni

Yoni

    Support Team Member

  • Support Team
  • PipPip
  • 97 posts
  • Gender:Male
  • Main OS: Other

Posted 30 December 2011 - 11:30 AM

Hi all,

I'm trying to find a way to enable and use InnoDB storage instead of MyISAM. Unfortunately I haven't found a way to enable InnoDB in Coral 8.0. I cannot even see InnoDB in phpMyAdmin. I checked my.ini and as far as I'm concerned InnoDB settings are there and they are enabled. Is it there a way to switch to InnoDB storage instead of using MyISAM as my primary db storage?

I'm new to UniServer and I wanna thank everyone of you who worked to make this wonderful "on the go" package possible. By the way, I'm using it in a production environment hosted in VMWare with good uptime and few positive feedbacks from end users.

Checking Logs and I found that InnoDB is not initializing...

111230  4:45:01 InnoDB: The InnoDB memory heap is disabled
111230  4:45:01 InnoDB: Mutexes and rw_locks use Windows interlocked functions
111230  4:45:01 InnoDB: Compressed tables use zlib 1.2.3
111230  4:45:01 InnoDB: Initializing buffer pool, size = 200.0M
111230  4:45:02 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file D:\UniServer\usr\local\mysql\data\ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 67108864 bytes!
111230  4:45:02 [ERROR] Plugin 'InnoDB' init function returned error.
111230  4:45:02 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
111230  4:45:02 [Note] Event Scheduler: Loaded 0 events
111230  4:45:02 [Note] D:\UniServer\usr\local\mysql\bin\mysqld1.exe: ready for connections.
Version: '5.5.18'  socket: ''  port: 3306  MySQL Community Server (GPL)

Yoni


#2 Yoni

Yoni

    Support Team Member

  • Support Team
  • PipPip
  • 97 posts
  • Gender:Male
  • Main OS: Other

Posted 30 December 2011 - 12:19 PM

I solved the issue by shutting down the MySQL service and deleting the ib_logfile0 and ib_logfile1. These files are recreated after MySQL is launched next time and since my InnoDB is enabled in my.ini the InnoDB db storage is now loading and showing up in phpMyAdmin. :(

Time to convert a couple of tables from MyISAM to InnoDB now.

Good luck everyone.

Yoni





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users