Autor Zpráva
Pavlínka
Profil
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
K odhalení dotazů, které tak dlouho trvají, by mohl pomoci
dev.mysql.com/doc/refman/5.5/en/slow-query-log.html

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: