Schlagwort-Archive: mysql
MySQL: Datenbank checken und reparieren aus der Kommandozeile
mysqlcheck -u root -p –auto-repair –check –optimize –all-databases
MySQL bei 100% Diskussion-Thread
Schreibe eine Antwort
Diskussion Weiterlesen
MySQL optimieren Huschi-Net
Grundsätze bei der Optimierung, Dokumentation, etc
Die wichtigsten Tuning-Parameter und Ihre Auswirkungen. Tools (Tuning Primer Script, MySQL Tuner).
MySQL The General Query Log
The general query log is a general record of what mysqld is doing. The server writes information to this log when clients connect or disconnect, and it logs each SQL statement received from clients. The general query log can be very useful when you suspect an error in a client and want to know exactly what the client sent to mysqld.
aus der MySQL Doku http://dev.mysql.com/doc/refman/5.1/en/query-log.html
mytop – a top clone for MySQL
mytop is a console-based (non-gui) tool for monitoring the threads and overall performance of a MySQL Server
von http://jeremy.zawodny.com/mysql/mytop/