MySQL-Konfiguration optimieren - MySQL-Absturz und Neustart funktionieren

350
leo

Mein WAMP MySQL ist in der letzten Woche 2 mal abgestürzt und ich wundere mich wirklich warum! Sobald ich den Server neu starte, funktioniert alles gut! Unten füge ich das Fehlerprotokoll von MySQL und die Datei my.ini an! Kann jemand etwas vorschlagen?

MySQL-Fehlerprotokoll:

2018-02-23 21:45:52 2000 [Note] Plugin 'FEDERATED' is disabled. 2018-02-23 21:45:52 2000 [Note] InnoDB: The InnoDB memory heap is disabled 2018-02-23 21:45:52 2000 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2018-02-23 21:45:52 2000 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-02-23 21:45:52 2000 [Note] InnoDB: Not using CPU crc32 instructions 2018-02-23 21:45:53 2000 [Note] InnoDB: Initializing buffer pool, size = 67.0G 2018-02-23 21:45:55 2000 [Note] InnoDB: Completed initialization of buffer pool 2018-02-23 21:45:55 2000 [Note] InnoDB: Highest supported file format is Barracuda. 2018-02-23 21:47:37 2000 [Note] InnoDB: 128 rollback segment(s) are active. 2018-02-23 21:47:37 2000 [Note] InnoDB: Waiting for purge to start 2018-02-23 21:47:38 2000 [Note] InnoDB: 5.6.12 started; log sequence number 321531472808 2018-02-23 21:48:16 2000 [Note] Server hostname (bind-address): '*'; port: 3306 2018-02-23 21:48:16 2000 [Note] IPv6 is available. 2018-02-23 21:48:16 2000 [Note] - '::' resolves to '::'; 2018-02-23 21:48:16 2000 [Note] Server socket created on IP: '::'. 2018-02-23 21:48:18 2000 [Note] Event Scheduler: Loaded 0 events 2018-02-23 21:48:18 2000 [Note] wampmysqld: ready for connections. Version: '5.6.12-log' socket: '' port: 3306 MySQL Community Server (GPL) 

My.ini-Konfigurationsdatei:

[wampmysqld]  port = 3306  socket = /tmp/mysql.sock key_buffer = 64M max_allowed_packet = 1000M  sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M basedir=c:/wamp/bin/mysql/mysql5.6.12 log-error=c:/wamp/logs/mysql.log datadir=c:/wamp/bin/mysql/mysql5.6.12/data #innodb_thread_concurrency = 8 innodb_read_io_threads = 12 innodb_buffer_pool_size = 67G max_connections = 4000 max_user_connections = 0  # Disable Federated by default skip-federated  [mysqldump] quick max_allowed_packet = 1000M  [mysql] no-auto-rehash  [isamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 4M write_buffer = 4M  [myisamchk]  key_buffer = 20M sort_buffer_size = 20M read_buffer = 4M write_buffer = 4M  [mysqlhotcopy] interactive-timeout  [mysqld] port=3306 table_definition_cache = 800 

Meine Serverdetails:

RAM: 128 GB RAM CPU: Intel XEON 3,5 GHz HD: 2 TB HDD

Irgendeine Empfehlung??

0
Was meinst du mit "abgestürzt" Damon vor 6 Jahren 0

0 Antworten auf die Frage