I’ve a xampp configurated regionally to run wordpress. I will need to have finished one thing mistaken when fixing some points ‘cuz on the finish, I bought caught with the next log from mysql database.
2015-11-10 15:26:56 10fc InnoDB: Warning: Utilizing innodb_additional_mem_pool_size is DEPRECATED. This selection could also be eliminated in future releases, along with the choice innodb_use_sys_malloc and with the InnoDB's inside reminiscence allocator.
2015-11-10 15:26:56 4348 [Note] InnoDB: Utilizing mutexes to ref depend buffer pool pages
2015-11-10 15:26:56 4348 [Note] InnoDB: The InnoDB reminiscence heap is disabled
2015-11-10 15:26:56 4348 [Note] InnoDB: Mutexes and rw_locks use Home windows interlocked features
2015-11-10 15:26:56 4348 [Note] InnoDB: Reminiscence barrier will not be used
2015-11-10 15:26:56 4348 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-10 15:26:56 4348 [Note] InnoDB: Not utilizing CPU crc32 directions
2015-11-10 15:26:56 4348 [Note] InnoDB: Initializing buffer pool, measurement = 16.0M
2015-11-10 15:26:56 4348 [Note] InnoDB: Accomplished initialization of buffer pool
2015-11-10 15:26:56 4348 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-10 15:26:57 4348 [Note] InnoDB: 128 rollback phase(s) are energetic.
2015-11-10 15:26:57 4348 [Note] InnoDB: Ready for purge to begin
2015-11-10 15:26:57 4348 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 began; log sequence quantity 1835027
2015-11-10 15:26:57 6140 [Note] InnoDB: Dumping buffer pool(s) not but began
2015-11-10 15:26:57 4348 [Note] Plugin 'FEEDBACK' is disabled.
2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'.
2015-11-10 15:26:57 4348 [Note] Occasion Scheduler: Loaded 0 occasions
2015-11-10 15:26:57 4348 [Note] C:xamppmysqlbinmysqld.exe: prepared for connections.
Model: '10.1.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2015-11-10 15:27:11 5152 [Note] C:xamppmysqlbinmysqld.exe: Regular shutdown
--------
2018-07-19 21:28:34 568 InnoDB: Warning: Utilizing innodb_additional_mem_pool_size is DEPRECATED. This selection could also be eliminated in future releases, along with the choice innodb_use_sys_malloc and with the InnoDB's inside reminiscence allocator.
2018-07-19 21:28:34 1384 [Note] InnoDB: Utilizing mutexes to ref depend buffer pool pages
2018-07-19 21:28:34 1384 [Note] InnoDB: The InnoDB reminiscence heap is disabled
2018-07-19 21:28:34 1384 [Note] InnoDB: Mutexes and rw_locks use Home windows interlocked features
2018-07-19 21:28:34 1384 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for reminiscence barrier
2018-07-19 21:28:34 1384 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-07-19 21:28:34 1384 [Note] InnoDB: Utilizing generic crc32 directions
2018-07-19 21:28:34 1384 [Note] InnoDB: Initializing buffer pool, measurement = 2.0G
2018-07-19 21:28:34 1384 [Note] InnoDB: Accomplished initialization of buffer pool
2018-07-19 21:28:34 1384 [Note] InnoDB: Highest supported file format is Barracuda.
2018-07-19 21:28:34 1384 [Note] InnoDB: The log sequence quantity 0 in ibdata file don't match the log sequence quantity 49463 within the ib_logfiles!
2018-07-19 21:28:34 1384 [Note] InnoDB: Restoring attainable half-written information pages from the doublewrite buffer...
2018-07-19 21:28:34 1384 [Note] InnoDB: Creating tablespace and datafile system tables.
2018-07-19 21:28:35 1384 [Note] InnoDB: Tablespace and datafile system tables created.
2018-07-19 21:28:35 1384 [Warning] InnoDB: Resizing redo log from 2*320 to 2*16384 pages, LSN=53524
2018-07-19 21:28:35 1384 [Warning] InnoDB: Beginning to delete and rewrite log information.
2018-07-19 21:28:35 1384 [Note] InnoDB: Setting log file D:xamppmysqldataib_logfile101 measurement to 256 MB
2018-07-19 21:28:35 1384 [Note] InnoDB: Setting log file D:xamppmysqldataib_logfile1 measurement to 256 MB
2018-07-19 21:28:35 1384 [Note] InnoDB: Renaming log file D:xamppmysqldataib_logfile101 to D:xamppmysqldataib_logfile0
2018-07-19 21:28:35 1384 [Warning] InnoDB: New log information created, LSN=53772
2018-07-19 21:28:35 1384 [Note] InnoDB: 1 rollback phase(s) are energetic.
2018-07-19 21:28:35 1384 [ERROR] InnoDB: Plugin initialization aborted at D:win32-packagesbuildsrcstoragextradbsrvsrv0start.cc [2969] with error Generic error.
2018-07-19 21:28:35 1384 [ERROR] Plugin 'InnoDB' init operate returned error.
2018-07-19 21:28:35 1384 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-07-19 21:28:35 1384 [Note] Plugin 'FEEDBACK' is disabled.
2018-07-19 21:28:35 1384 [ERROR] Unknown/unsupported storage engine: InnoDB
2018-07-19 21:28:35 1384 [ERROR] Aborting
this man right here appears to repeat itself numerous occasions – I do know, It’s particular. I do know, I virtually understand it like poetry however nonetheless, I cannot discover the answer. I’ve tried a number of strategies discovered all around the web, a few of them be
*deleting ib_logfile0 and ib_logfile1
*rising InnoDB buffer pool measurement
*eradicating the ‘sys_malloc’ from db configuration
Bellow I am going to paste the my.ini file of my sql server
# Instance MySQL config file for small methods.
#
# That is for a system with little reminiscence (<= 64M) the place MySQL is barely used
# on occasion and it is vital that the mysqld daemon
# does not use a lot sources.
#
# You may copy this file to
# D:/xampp/mysql/bin/my.cnf to set world choices,
# mysql-data-dir/my.cnf to set server-specific choices (on this
# set up this listing is D:/xampp/mysql/information) or
# ~/.my.cnf to set user-specific choices.
#
# On this file, you should utilize all lengthy choices {that a} program helps.
# If you wish to know which choices a program helps, run this system
# with the "--help" possibility.
# The next choices shall be handed to all MySQL purchasers
[client]
# password = your_password
port = 3306
socket = "D:/xampp/mysql/mysql.sock"
# Right here follows entries for some particular applications
# The MySQL server
[mysqld]
innodb_force_recovery = 4
port= 3306
socket = "D:/xampp/mysql/mysql.sock"
basedir = "D:/xampp/mysql"
tmpdir = "D:/xampp/tmp"
datadir = "D:/xampp/mysql/information"
pid_file = "mysql.pid"
# enable-named-pipe
key_buffer = 20M
max_allowed_packet = 1M
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 20M
log_error = "mysql_error.log"
innodb_use_sys_malloc = 1
# Change right here for bind listening
# bind-address="127.0.0.1"
# bind-address = ::1 # for ipv6
# The place do all of the plugins stay
plugin_dir = "D:/xampp/mysql/lib/plugin/"
# Do not hear on a TCP/IP port in any respect. This generally is a safety enhancement,
# if all processes that want to connect with mysqld run on the identical host.
# All interplay with mysqld should be made through Unix sockets or named pipes.
# Word that utilizing this feature with out enabling named pipes on Home windows
# (through the "enable-named-pipe" possibility) will render mysqld ineffective!
#
# commented in by lampp safety
#skip-networking
#skip-federated
# Replication Grasp Server (default)
# binary logging is required for replication
# log-bin deactivated by default since XAMPP 1.4.11
#log-bin=mysql-bin
# required distinctive id between 1 and a couple of^32 - 1
# defaults to 1 if master-host will not be set
# however won't operate as a grasp if omitted
server-id = 1
# Replication Slave (remark out grasp part to make use of this)
#
# To configure this host as a replication slave, you may select between
# two strategies :
#
# 1) Use the CHANGE MASTER TO command (totally described in our handbook) -
# the syntax is:
#
# CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
# MASTER_USER=<person>, MASTER_PASSWORD=<password> ;
#
# the place you exchange <host>, <person>, <password> by quoted strings and
# <port> by the grasp's port quantity (3306 by default).
#
# Instance:
#
# CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
# MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR
#
# 2) Set the variables beneath. Nevertheless, in case you select this methodology, then
# begin replication for the primary time (even unsuccessfully, for instance
# in case you mistyped the password in master-password and the slave fails to
# join), the slave will create a grasp.information file, and any later
# change on this file to the variables' values beneath shall be ignored and
# overridden by the content material of the grasp.information file, except you shutdown
# the slave server, delete grasp.information and restart the slaver server.
# For that cause, chances are you'll need to go away the traces beneath untouched
# (commented) and as a substitute use CHANGE MASTER TO (see above)
#
# required distinctive id between 2 and a couple of^32 - 1
# (and totally different from the grasp)
# defaults to 2 if master-host is about
# however won't operate as a slave if omitted
#server-id = 2
#
# The replication grasp for this slave - required
#master-host = <hostname>
#
# The username the slave will use for authentication when connecting
# to the grasp - required
#master-user = <username>
#
# The password the slave will authenticate with when connecting to
# the grasp - required
#master-password = <password>
#
# The port the grasp is listening on.
# non-obligatory - defaults to 3306
#master-port = <port>
#
# binary logging - not required for slaves, however advisable
#log-bin=mysql-bin
# Level the next paths to totally different devoted disks
#tmpdir = "D:/xampp/tmp"
#log-update = /path-to-dedicated-directory/hostname
# Uncomment the next in case you are utilizing BDB tables
#bdb_cache_size = 4M
#bdb_max_lock = 10000
# Remark the next in case you are utilizing InnoDB tables
#skip-innodb
innodb_data_home_dir = "D:/xampp/mysql/information"
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = "D:/xampp/mysql/information"
#innodb_log_arch_dir = "D:/xampp/mysql/information"
## You may set .._buffer_pool_size as much as 50 - 80 %
## of RAM however watch out for setting reminiscence utilization too excessive
innodb_buffer_pool_size = 200M
innodb_additional_mem_pool_size = 200M
## Set .._log_file_size to 25 % of buffer pool measurement
innodb_log_file_size = 5M
innodb_log_buffer_size = 200M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
## UTF 8 Settings
#init-connect='SET NAMES utf8'
#collation_server=utf8_unicode_ci
#character_set_server=utf8
#skip-character-set-client-handshake
#character_sets-dir="D:/xampp/mysql/share/charsets"
[mysqldump]
fast
max_allowed_packet = 20M
[mysql]
no-auto-rehash
# Take away the subsequent remark character in case you are not conversant in SQL
#safe-updates
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
I am fairly beginner to mysql, and attempting all these stuffs with out even altering the error… sucks. And I am going to in all probability suck extra untill I rock (ya, I simply did that one for not letting you guys take benefit). Cheers!