-+----------+--------------+------------------+
| mysql-bin.003 | 73 | test | manual,mysql |
+---------------+----------+--------------+... = optimization =====
[[https://github.com/major/MySQLTuner-perl|MySQLTuner]] is a great tool to start with. You can fin... d tips on [[http://wiki.deimos.fr/index.php?title=MysqlTuner_:_Optimiser_votre_serveur_MySQL|this page]] (in French).
If MySQLTuner reports ... uthentification
<code bash>
# /usr/local/libexec/mysqld -u mysql --skip-grant
</code>
* connect to MySQL and ch
====== mtop ======
[[http://mtop.sourceforge.net/|MySQL real-time monitoring]]. access MySQL using the "mysqltop" user with no password by default, so create on the MySQL server.
====== iotop ======
[[http://guichaz.fre
proto ipv6-icmp all
</code>
===== MySQL =====
as stated [[http://bugs.mysql.com/bug.php?id=49024|here]], you need at least MySQL v5.5.x for ipv6 to work.