Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MySQL56 service won't start upon fresh install

Posted on 2015-02-19
4
Medium Priority
?
619 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 84

Accepted Solution

by:
Dave Baldwin earned 2000 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 84

Expert Comment

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

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

The following article is comprised of the pearls we have garnered deploying virtualization solutions since Virtual Server 2005 and subsequent 2008 RTM+ Hyper-V in standalone and clustered environments.
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
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.
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…
Suggested Courses

876 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