Avatar
mkudelka7
Člen
Avatar
mkudelka7:

Zdravím,
před nedávnem jsem si stáhnul a nainstaloval UwAmp, Apache server běží v pohodě, ale MySQL server se pokaždé sotva nahodí a po ca. 10 vteřinách spadne. Už si s tím opravdu nevím rady, blokuje mi to veškerou moji práci, a ani Google mi moc nepomohl. Ví někdo co s tím? Dole je kompletní Mysql log.
Předem díky za rady

2015-06-06 20:05:11 5100 [Note] Plugin 'FEDERATED' is disabled.
2015-06-06 20:05:11 5100 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-06-06 20:05:11 5100 [Note] InnoDB: The InnoDB memory heap is disabled
2015-06-06 20:05:11 5100 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-06-06 20:05:11 5100 [Note] InnoDB: Memory barrier is not used
2015-06-06 20:05:11 5100 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-06-06 20:05:11 5100 [Note] InnoDB: Not using CPU crc32 instructions
2015-06-06 20:05:11 5100 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-06-06 20:05:11 5100 [Note] InnoDB: Completed initialization of buffer pool
2015-06-06 20:05:11 5100 [Note] InnoDB: Setting log file .\ib_logfile101 size to 48 MB
2015-06-06 20:05:14 5100 [Note] InnoDB: Setting log file .\ib_logfile1 size to 48 MB
2015-06-06 20:05:16 5100 [Note] InnoDB: Renaming log file .\ib_logfile101 to .\ib_logfile0
2015-06-06 20:05:16 5100 [Warning] InnoDB: New log files created, LSN=1600887
2015-06-06 20:05:16 5100 [Note] InnoDB: Highest supported file format is Barracuda.
2015-06-06 20:05:16 5100 [Note] InnoDB: 128 rollback segment(s) are active.
2015-06-06 20:05:16 5100 [Note] InnoDB: Waiting for purge to start
2015-06-06 20:05:16 5100 [Note] InnoDB: 5.6.20 started; log sequence number 1601036
2015-06-06 20:05:16 5100 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-06-06 20:05:16 5100 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2015-06-06 20:05:16 5100 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-06-06 20:05:16 5100 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-06-06 20:05:16 5100 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
2015-06-06 20:05:16 5100 [Note] Event Scheduler: Loaded 0 events
2015-06-06 20:05:16 5100 [Note] C:\UwAmp\bin\database\mysql-5.6.20\bin\mysqld.exe: ready for connections.
Version: '5.6.20-log'  socket: ''  port: 0  MySQL Community Server (GPL)
2015-06-06 20:05:16 5100 [ERROR] TCP/IP, --shared-memory, or --named-pipe should be configured on NT OS
2015-06-06 20:05:16 5100 [ERROR] Aborting

2015-06-06 20:05:16 5100 [Note] Binlog end
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'partition'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_METRICS'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_CMP'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'INNODB_TRX'
2015-06-06 20:05:16 5100 [Note] Shutting down plugin 'InnoDB'
2015-06-06 20:05:16 5100 [Note] InnoDB: FTS optimize thread exiting.
2015-06-06 20:05:16 5100 [Note] InnoDB: Starting shutdown...
2015-06-06 20:05:18 5100 [Note] InnoDB: Shutdown completed; log sequence number 1601046
2015-06-06 20:05:18 5100 [Note] Shutting down plugin 'BLACKHOLE'
2015-06-06 20:05:18 5100 [Note] Shutting down plugin 'ARCHIVE'
2015-06-06 20:05:18 5100 [Note] Shutting down plugin 'MRG_MYISAM'
2015-06-06 20:05:18 5100 [Note] Shutting down plugin 'MyISAM'
2015-06-06 20:05:18 5100 [Note] Shutting down plugin 'MEMORY'
2015-06-06 20:05:18 5100 [Note] Shutting down plugin 'CSV'
2015-06-06 20:05:18 5100 [Note] Shutting down plugin 'sha256_password'
2015-06-06 20:05:18 5100 [Note] Shutting down plugin 'mysql_old_password'
2015-06-06 20:05:18 5100 [Note] Shutting down plugin 'mysql_native_password'
2015-06-06 20:05:18 5100 [Note] Shutting down plugin 'binlog'
2015-06-06 20:05:18 5100 [Note] C:\UwAmp\bin\database\mysql-5.6.20\bin\mysqld.exe: Shutdown complete
Editováno 6.6.2015 20:13
Odpovědět 6.6.2015 20:12
Žádný kód není dostatečně krátký na to, aby se v něm nedaly udělat alespoň tři chyby
Avatar
Richard
Člen
Avatar
Odpovídá na mkudelka7
Richard:

V my.cnf zakomentovat skip-networking a enable-named-pipe

Nahoru Odpovědět 6.6.2015 20:18
$action = $_GET['Life']; | Když dáš mínus, napiš proč!
Avatar
IT Man
Redaktor
Avatar
Nahoru Odpovědět 6.6.2015 20:31
Když nevíš jak dál, podá ti ruku někdo, od koho by jsi to nečekal. A tu šanci musíš přijmout!
Avatar
mkudelka7
Člen
Avatar
Odpovídá na IT Man
mkudelka7:

S toho jsem taky nebyl moc chytrej :)

Nahoru Odpovědět 6.6.2015 20:34
Žádný kód není dostatečně krátký na to, aby se v něm nedaly udělat alespoň tři chyby
Avatar
mkudelka7
Člen
Avatar
Odpovídá na Richard
mkudelka7:

Díky za odpověď,
našel jsem, že my.cnf je na windowsech my.ini (snad je to dobře), zakomentoval jsem skip networking, ale enable named pipe jsem v tom souboru našel jen v "okecávacích" komentech, takže pořád nefacha. Port 3306 jsem ve firewallu odblokoval a port 90 je taky volnej. Přikládám soubor a v komentech jsem označil problematická místa.
Díky za jakékoliv (správné) další rady.

# The following options will be passed to all MySQL clients
[client]
#password       = your_password
port            = 3306
socket          = /tmp/mysql.sock

[mysqld]
default-storage-engine = myisam
port            = 3306
socket          = /tmp/mysql.sock
datadir         = "C:/UwAmp/bin/database/mysql-5.6.20/data"
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
explicit_defaults_for_timestamp = TRUE

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless! <-tohle...
#
# skip-networking  <- ...a tohle mi dělá vrásky na čele

# Replication Master Server (default)
# binary logging is required for replication
log-bin=mysql-bin

# binary logging format - mixed recommended
binlog_format=mixed

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id       = 1

# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#

# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id       = 2
#
# The replication master for this slave - required
#master-host     =   <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user     =   <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password =   <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port     =  <port>
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin

# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = C:\\mysql\\data\\
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = C:\\mysql\\data\\
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout
Nahoru Odpovědět 6.6.2015 22:03
Žádný kód není dostatečně krátký na to, aby se v něm nedaly udělat alespoň tři chyby
Avatar
Richard
Člen
Avatar
Odpovídá na mkudelka7
Richard:

Popravdě úplně si to už nepamatuju, zkus pod definici portu hodit:
skip-networking
enable-named-pipe

Editováno 7.6.2015 1:50
Nahoru Odpovědět 7.6.2015 1:50
$action = $_GET['Life']; | Když dáš mínus, napiš proč!
Avatar
mkudelka7
Člen
Avatar
mkudelka7:

Po přidání už nepadá, ale pro změnu vůbec nereaguje, nejde vypnout/zapnout a k databázi se pořád nedá připojit :-/

Nahoru Odpovědět 7.6.2015 14:07
Žádný kód není dostatečně krátký na to, aby se v něm nedaly udělat alespoň tři chyby
Avatar
mkub
Redaktor
Avatar
Odpovídá na mkudelka7
mkub:

a tentoraz, co sa hodilo do logu?

 
Nahoru Odpovědět 9.6.2015 8:23
Avatar
mkudelka7
Člen
Avatar
Odpovídá na mkub
mkudelka7:

trošku jsem to mezitím předělal, my.ini teď vypadá takhle:

[client]
port = 3306
socket=/tmp/mysql.sock

[mysql]
default-character-set = utf8

[mysqld]
port = 3306
basedir="C:/UwAmp/bin/database/mysql-5.6.20/"
datadir="C:/UwAmp/bin/database/mysql-5.6.20/data"
character-set-server = utf8
default-storage-engine = INNODB
socket=/tmp/mysql.sock
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
explicit_defaults_for_timestamp
max_connections = 341
query_cache_size = 9M
tmp_table_size = 16M
bind-address = 0.0.0.0
thread_cache_size = 17
myisam_max_sort_file_size = 100G
myisam_sort_buffer_size = 8M
key_buffer_size = 16M
read_buffer_size = 64K
read_rnd_buffer_size = 256K
sort_buffer_size = 208K
innodb_flush_log_at_trx_commit = 1
innodb_log_buffer_size = 1M
innodb_buffer_pool_size = 256M
innodb_log_file_size = 10M
innodb_thread_concurrency = 10
skip-networking
enable-named-pipe

a log takhle

2015-06-09 16:35:52 5668 [Note] Plugin 'FEDERATED' is disabled.
2015-06-09 16:35:52 5668 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-06-09 16:35:52 5668 [Note] InnoDB: The InnoDB memory heap is disabled
2015-06-09 16:35:52 5668 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-06-09 16:35:52 5668 [Note] InnoDB: Memory barrier is not used
2015-06-09 16:35:52 5668 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-06-09 16:35:52 5668 [Note] InnoDB: Not using CPU crc32 instructions
2015-06-09 16:35:52 5668 [Note] InnoDB: Initializing buffer pool, size = 256.0M
2015-06-09 16:35:52 5668 [Note] InnoDB: Completed initialization of buffer pool
2015-06-09 16:35:53 5668 [Note] InnoDB: Highest supported file format is Barracuda.
2015-06-09 16:35:53 5668 [Note] InnoDB: The log sequence numbers 1602582 and 1602582 in ibdata files do not match the log sequence number 1603104 in the ib_logfiles!
2015-06-09 16:35:53 5668 [Note] InnoDB: Database was not shutdown normally!
2015-06-09 16:35:53 5668 [Note] InnoDB: Starting crash recovery.
2015-06-09 16:35:53 5668 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-06-09 16:35:53 5668 [Note] InnoDB: Restoring possible half-written data pages
2015-06-09 16:35:53 5668 [Note] InnoDB: from the doublewrite buffer...
2015-06-09 16:35:56 5668 [Note] InnoDB: 128 rollback segment(s) are active.
2015-06-09 16:35:56 5668 [Note] InnoDB: Waiting for purge to start
2015-06-09 16:35:56 5668 [Note] InnoDB: 5.6.20 started; log sequence number 1603104
2015-06-09 16:35:57 5668 [Note] Event Scheduler: Loaded 0 events
2015-06-09 16:35:57 5668 [Note] C:\UwAmp\bin\database\mysql-5.6.20\bin\mysqld.exe: ready for connections.
Version: '5.6.20'  socket: ''  port: 0  MySQL Community Server (GPL)

díky za rady/připomín­ky/poznámky/co­koliv

Nahoru Odpovědět 9.6.2015 16:37
Žádný kód není dostatečně krátký na to, aby se v něm nedaly udělat alespoň tři chyby
Avatar
mkudelka7
Člen
Avatar
mkudelka7:

ok, vyřešeno. Prostě jsem místo Uwampu stáhnul XAMPP, tam to fachá na první nástřel :)

Akceptované řešení
+5 Zkušeností
Řešení problému
Nahoru Odpovědět 11.6.2015 17:46
Žádný kód není dostatečně krátký na to, aby se v něm nedaly udělat alespoň tři chyby
Děláme co je v našich silách, aby byly zdejší diskuze co nejkvalitnější. Proto do nich také mohou přispívat pouze registrovaní členové. Pro zapojení do diskuze se přihlas. Pokud ještě nemáš účet, zaregistruj se, je to zdarma.

Zobrazeno 10 zpráv z 10.