Thread:Project:Support desk/Very slow MW website, possibly due to database/reply (5)

1) So MySQL is in fact not generally slow, but slow when it writes to the database.

2) Looks good.

3) On the shell you can e.g. do shell> mysqldump --opt -u -p db_name > backup-file.sql with your username and your password (and really without space after the "-p"). Use of --opt is the same as specifying --add-drop-table, --add-locks, --create-options, --disable-keys, --extended-insert, --lock-tables, --quick, and --set-charset. All of the options that --opt stands for also are on by default because --opt is on by default.

4) All the different options are explained here: http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

5) Should not hurt. But when you say that MySQL is slow, when someone writes to the DB, then a PHP accelerator won't change the main part of that problem.