Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MySQL56 service won't start upon fresh install

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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

661 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