Solved

MySQL56 service won't start upon fresh install

Posted on 2015-02-19
4
554 Views
Last Modified: 2015-02-20
Hi,

i'm having difficulties installing MySQL Server 5.6.23 on a new server.

The MySQL installer stops when trying to attempt to start the MySQL56 service.

"Service MySQL56 changed status from StartPending to Stopped ..."

OS is MS Windows Server 2012 R2
64-bit OS, X64-based processor
16GB RAM (15,9 usable)

The .err log says "innobase_buffer_pool_size can't be over 4GB on 32-bit systems"
which is strange because it is a 64bit system

I tried uninstalling and reinstalling a previous mysql version, but that also fails at the same event.

All help is welcome.



This is my .err log:
____________________

2015-02-19 18:45:45 2076 [Note] Plugin 'FEDERATED' is disabled.
2015-02-19 18:45:45 2076 innobase_buffer_pool_size can't be over 4GB on 32-bit systems
2015-02-19 18:45:45 2076 Plugin 'InnoDB' init function returned error.
2015-02-19 18:45:45 2076 Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-02-19 18:45:45 2076 Unknown/unsupported storage engine: INNODB
2015-02-19 18:45:45 2076 Aborting

2015-02-19 18:45:45 2076 [Note] Binlog end
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'partition'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_METRICS'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_CMP'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'INNODB_TRX'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'BLACKHOLE'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'ARCHIVE'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'MRG_MYISAM'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'MyISAM'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'MEMORY'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'CSV'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'sha256_password'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'mysql_old_password'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'mysql_native_password'
2015-02-19 18:45:45 2076 [Note] Shutting down plugin 'binlog'
2015-02-19 18:45:45 2076 [Note] C:\Program Files (x86)\MySQL\MySQL Server 5.6\bin\mysqld.exe: Shutdown complete







Regards,
Davey
0
Comment
Question by:24Carat
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 500 total points
ID: 40620638
Looks to me like you are trying to install a 32-bit version.

C:\Program Files (x86)\MySQL\MySQL Server 5.6\bin\mysqld.exe

Look here: http://dev.mysql.com/downloads/mysql/
0
 

Author Comment

by:24Carat
ID: 40620674
When i follow the 64bit download link on the second page there is a message like this.

"Note: MySQL Installer is 32 bit, but will install both 32 bit and 64 bit binaries."

During installation i was never asked to chose between 32bit or 64bit.
0
 

Author Comment

by:24Carat
ID: 40620692
Hi,

Thanks it was in fact the 32 bit it was trying to install.

For some reason if you select 'full' in stead of custom it doesn't recognize X86 or X64.

so i chose custom and manually chose X64

Thanks that helped.
Regards
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 40620738
You're welcome, glad to help.
0

Featured Post

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The article will show you how you can maintain a simple logfile of all Startup and Shutdown events on Windows servers and desktops with PowerShell. The script can be easily adapted into doing more like gracefully silencing/updating your monitoring s…
What to do when Windows Update is not working correctly? What tools can I use to detect the cause of the malfunction problem? What does this numeric error code mean? These and other questions that you have been asking in the past are answered here (…
In this Micro Tutorial viewers will learn how to use Windows Server Backup to create full image of their system. Tutorial shows how to install Windows Server Backup Feature on Windows 2012R2 and how to configure scheduled Bare Metal Recovery backup.…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question