mysql> pager less; PAGER set to ‘less’   Выводим информацию о текущих установках глобальных переменных: mysql> SHOW VARIABLES; | slow_query_log | OFF | | slow_query_log_…

I skimmed over this thread and I think I can help clarify the innodb, rsync, and lvm situation. The basic issue with just running rsync on the files under a running mysqld is that…

1. Download and install the latest version http://www.percona.com/downloads/XtraBackup/LATEST/ #For Debian wget http://www.percona.com/downloads/XtraBackup/LATEST/deb/squeeze/x86_6…

http://www.selectorweb.com/sql_sybase.html

Show process list: SHOW PROCESSLIST; asd  Properties of Transactions: Transactions have the following four standard properties, usually referred to by the acronym ACID: Atomicity:…

mysql> SHOW TABLES LIKE "phpbb_%"; /* list all phpBB tables */ mysql> DROP TABLES LIKE "phpbb_%"; /* DROP THEM? Quite a naive approach.. */ Well, even before executing it I w…

SQL Injection Cheat Sheet SQL Injection Cheat Sheet, Document Version 1.4 About SQL Injection Cheat Sheet Currently only for MySQL and Microsoft SQL Server, some ORACLE and some Po…

For successful backup the packet size must be the same [mysqld] key_buffer                                      = 160M max_allowed_packet                      = 150M [mysqldump] qu…

Mysql Instances mysqlmanager --passwd >> /etc/mysqlmanager.passwd ## ##/etc/mysql/my.cnf ## [mysql.server] user-manager [manager] port                            =2273 monito…