Autor Zpráva
Taps
Profil
Zdravím, v mysql chci pracovat s INNODB, ale bohužel se mi zobrazuje chyba Plugin 'FEDERATED' is disabled.
v my.ini mám uvedeno

innodb_data_home_dir = C:/Program Files (x86)/uwamp/bin/database/mysql-5.6.20/data/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = C:/Program Files (x86)/uwamp/bin/database/mysql-5.6.20/data/
innodb_log_arch_dir = C:/Program Files (x86)/uwamp/bin/database/mysql-5.6.20/data/
set-variable = innodb_buffer_pool_size=16M
set-variable = innodb_additional_mem_pool_size=2M
set-variable = innodb_log_file_size=170M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
set-variable = innodb_lock_wait_timeout=50

a celý error log mysql vypadá následovně

2015-11-22 16:48:06 5832 [Note] Plugin 'FEDERATED' is disabled.
2015-11-22 16:48:06 5832 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-11-22 16:48:06 5832 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-22 16:48:06 5832 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-22 16:48:06 5832 [Note] InnoDB: Memory barrier is not used
2015-11-22 16:48:06 5832 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-22 16:48:06 5832 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-22 16:48:06 5832 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-11-22 16:48:06 5832 [Note] InnoDB: Completed initialization of buffer pool
2015-11-22 16:48:06 5832 [Note] InnoDB: Setting log file C:\Program Files (x86)\uwamp\bin\database\mysql-5.6.20\data\ib_logfile101 size to 48 MB
2015-11-22 16:48:07 5832 [Note] InnoDB: Setting log file C:\Program Files (x86)\uwamp\bin\database\mysql-5.6.20\data\ib_logfile1 size to 48 MB
2015-11-22 16:48:07 5832 [Note] InnoDB: Renaming log file C:\Program Files (x86)\uwamp\bin\database\mysql-5.6.20\data\ib_logfile101 to C:\Program Files (x86)\uwamp\bin\database\mysql-5.6.20\data\ib_logfile0
2015-11-22 16:48:07 5832 [Warning] InnoDB: New log files created, LSN=1601056
2015-11-22 16:48:07 5832 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-22 16:48:07 5832 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-22 16:48:07 5832 [Note] InnoDB: Waiting for purge to start
2015-11-22 16:48:07 5832 [Note] InnoDB: 5.6.20 started; log sequence number 1601548
2015-11-22 16:48:07 5832 [ERROR] C:\Program Files (x86)\uwamp\bin\database\mysql-5.6.20\bin\mysqld.exe: unknown variable 'innodb_log_arch_dir=C:/Program Files (x86)/uwamp/bin/database/mysql-5.6.20/data/'
2015-11-22 16:48:07 5832 [ERROR] Aborting

2015-11-22 16:48:07 5832 [Note] Binlog end
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'partition'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_METRICS'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_CMP'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'INNODB_TRX'
2015-11-22 16:48:07 5832 [Note] Shutting down plugin 'InnoDB'
2015-11-22 16:48:07 5832 [Note] InnoDB: FTS optimize thread exiting.
2015-11-22 16:48:07 5832 [Note] InnoDB: Starting shutdown...
2015-11-22 16:48:09 5832 [Note] InnoDB: Shutdown completed; log sequence number 1601558
2015-11-22 16:48:09 5832 [Note] Shutting down plugin 'BLACKHOLE'
2015-11-22 16:48:09 5832 [Note] Shutting down plugin 'ARCHIVE'
2015-11-22 16:48:09 5832 [Note] Shutting down plugin 'MRG_MYISAM'
2015-11-22 16:48:09 5832 [Note] Shutting down plugin 'MyISAM'
2015-11-22 16:48:09 5832 [Note] Shutting down plugin 'MEMORY'
2015-11-22 16:48:09 5832 [Note] Shutting down plugin 'CSV'
2015-11-22 16:48:09 5832 [Note] Shutting down plugin 'sha256_password'
2015-11-22 16:48:09 5832 [Note] Shutting down plugin 'mysql_old_password'
2015-11-22 16:48:09 5832 [Note] Shutting down plugin 'mysql_native_password'
2015-11-22 16:48:09 5832 [Note] Shutting down plugin 'binlog'
2015-11-22 16:48:09 5832 [Note] C:\Program Files (x86)\uwamp\bin\database\mysql-5.6.20\bin\mysqld.exe: Shutdown complete

Mohl by mi prosím někdo poradit jak tento problém odstranit. Používám MYSQL 5.6.20
juriad
Profil
Plugin 'FEDERATED' is disabled. není chyba.
Chybou je až unknown variable na 18. řádku. www.josephmoore.co.uk/wampserver-mysql-innodb-log-arch-dir-error
Taps
Profil
juriad:
Děkuji

Vaše odpověď

Mohlo by se hodit


Prosím používejte diakritiku a interpunkci.

Ochrana proti spamu. Napište prosím číslo dvě-sta čtyřicet-sedm: