Diskuse JPW: mysql vytěžuje 100% cpu

	Autor	Zpráva
	Pavlínka Profil	#1 · Zasláno: 31. 1. 2018, 16:37:54 · Upravil/a: Pavlínka o 1 hodinu později Odpovědět Citovat zrovna moc tomu nerozumím, mylela jsem, že mám chybu v scriptu ale po opravení mi stále Vytěžuje mysql server na 100 CPU v mysql/error.log je toto: 180131 16:22:40 [Note] /usr/sbin/mysqld: Normal shutdown 180131 16:22:40 [Note] Event Scheduler: Purging the queue. 0 events 180131 16:22:42 InnoDB: Starting shutdown... 180131 16:22:43 InnoDB: Waiting for 1 pages to be flushed 180131 16:22:44 InnoDB: Shutdown completed; log sequence number 153646677 180131 16:22:44 [Note] /usr/sbin/mysqld: Shutdown complete 180131 16:22:58 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 180131 16:22:58 [Note] Plugin 'FEDERATED' is disabled. 180131 16:22:58 InnoDB: The InnoDB memory heap is disabled 180131 16:22:58 InnoDB: Mutexes and rw_locks use GCC atomic builtins 180131 16:22:58 InnoDB: Compressed tables use zlib 1.2.8 180131 16:22:58 InnoDB: Using Linux native AIO 180131 16:22:58 InnoDB: Initializing buffer pool, size = 128.0M 180131 16:22:58 InnoDB: Completed initialization of buffer pool 180131 16:22:58 InnoDB: highest supported file format is Barracuda. 180131 16:22:58 InnoDB: Waiting for the background threads to start 180131 16:22:59 InnoDB: 5.5.58 started; log sequence number 153646677 180131 16:22:59 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 180131 16:22:59 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 180131 16:22:59 [Note] Server socket created on IP: '127.0.0.1'. 180131 16:22:59 [Note] Event Scheduler: Loaded 0 events 180131 16:22:59 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.58-0+deb8u1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian) moc prosím o radu co s tím :( google skutečně nepomohl :( vyřešeno :)
	Kajman Profil	#2 · Zasláno: 31. 1. 2018, 17:36:42 Odpovědět Citovat K odhalení dotazů, které tak dlouho trvají, by mohl pomoci dev.mysql.com/doc/refman/5.5/en/slow-query-log.html
	Časová prodleva: 6 let

Autor

Zpráva

Pavlínka
Profil

#1 · Zasláno: 31. 1. 2018, 16:37:54 · Upravil/a: Pavlínka o 1 hodinu později

zrovna moc tomu nerozumím, mylela jsem, že mám chybu v scriptu ale po opravení mi stále
Vytěžuje mysql server na 100 CPU

v mysql/error.log je toto:

180131 16:22:40 [Note] /usr/sbin/mysqld: Normal shutdown

180131 16:22:40 [Note] Event Scheduler: Purging the queue. 0 events
180131 16:22:42  InnoDB: Starting shutdown...
180131 16:22:43  InnoDB: Waiting for 1 pages to be flushed
180131 16:22:44  InnoDB: Shutdown completed; log sequence number 153646677
180131 16:22:44 [Note] /usr/sbin/mysqld: Shutdown complete

180131 16:22:58 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
180131 16:22:58 [Note] Plugin 'FEDERATED' is disabled.
180131 16:22:58 InnoDB: The InnoDB memory heap is disabled
180131 16:22:58 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180131 16:22:58 InnoDB: Compressed tables use zlib 1.2.8
180131 16:22:58 InnoDB: Using Linux native AIO
180131 16:22:58 InnoDB: Initializing buffer pool, size = 128.0M
180131 16:22:58 InnoDB: Completed initialization of buffer pool
180131 16:22:58 InnoDB: highest supported file format is Barracuda.
180131 16:22:58  InnoDB: Waiting for the background threads to start
180131 16:22:59 InnoDB: 5.5.58 started; log sequence number 153646677
180131 16:22:59 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
180131 16:22:59 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
180131 16:22:59 [Note] Server socket created on IP: '127.0.0.1'.
180131 16:22:59 [Note] Event Scheduler: Loaded 0 events
180131 16:22:59 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.58-0+deb8u1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Debian)

moc prosím o radu co s tím :(
google skutečně nepomohl :(

vyřešeno :)

Kajman
Profil

#2 · Zasláno: 31. 1. 2018, 17:36:42

Odpovědět Citovat

K odhalení dotazů, které tak dlouho trvají, by mohl pomoci
dev.mysql.com/doc/refman/5.5/en/slow-query-log.html

Časová prodleva: 6 let

Vaše odpověď

Mohlo by se hodit