Solved

MySQL56 service won't start upon fresh install

Posted on 2015-02-19
4
445 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
  • 2
  • 2
4 Comments
 
LVL 82

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 82

Expert Comment

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

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

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…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
In this Micro Tutorial viewers will learn how they can get their files copied out from their unbootable system without need to use recovery services. As an example non-bootable Windows 2012R2 installation is used which has boot problems.
In this Micro Tutorial viewers will learn how to restore single file or folder from Bare Metal backup image of their system. Tutorial shows how to restore files and folders from system backup. Often it is not needed to restore entire system when onl…

708 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now