sql_log_bin=0

A client that has the SUPER privilege can disable binary logging of its own statements by using a SET sql_log_bin=0 statement.

http://dev.mysql.com/doc/refman/5.1/en/upgrading-from-previous-series.html

Комментарии

SET GLOBAL

SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;

for table in `mysql $db

for table in `mysql $db –skip-column-names -e 'show tables' ; do
  echo "Dumping $table"
  mysqldump --opt -Q $db $table > $table.sql
done

mysqld_safe

mysqld_safe –skip-grant-tables &
mysqladmin -u root flush-privileges password “newpassword”

http://dev.mysql.com/doc/refm

сам с собой общаешься?

сам с собой общаешься? подредактировать сам пост прав не хватило? ))

так проще :) коплю заметки на

так проще :)
коплю заметки на пост

'Sending data' means that

'Sending data' means that rows are read from one table to further processing. Under congestion, I think that state is a very common thread state.

CREATE TABLE recipes_new LIKE

CREATE TABLE recipes_new LIKE production.recipes; INSERT recipes_new SELECT * FROM production.recipes;

http://dev.mysql.com/doc/refm

How to calculate a good

Percona Replication Manager,

Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
http://www.mysqlperformanceblog.com/2011/11/29/percona-replication-manag...

http://www.ducea.com/2008/02/

http://blogs.component.hu/ind

mysqlreport innotop http://ha

http://dev.mysql.com/doc/refm

SET GLOBAL read_only = ON;

SET GLOBAL read_only = ON;