EC_TO_TIME() returns a TIME, is constrained to the range of the TIME data type, and a warning occurs for arguments resulting in values outside of that range 1. Solution DROP FUNCTION IF EXISTS BIGTIMEDIFF; DELIMITER $$ CREATE FUNCTION `test`.`BIGTIMEDIFF` (end_time…
myisam teble fix CHECK TABLE test_table; #CHECK TABLE test_table FAST QUICK; REPAIR TABLE table_name; Don’t undervalue the backup of the to be repair table .
shell> mysql -u username -p mysql> PURGE BINARY LOGS TO ‘mysql-bin.000015’; Alternatively, you can remove the binary older than a specific date. shell> mysql -u username -p mysql> PURGE BINARY LOGS BEFORE ‘2009-11-01 00:00:00’; expare_logs_days = 10 mysql> show variables…
mysql> pager less; PAGER set to ‘less’ Выводим информацию о текущих установках глобальных переменных: mysql> SHOW VARIABLES; | slow_query_log | OFF | | slow_query_log_file | Включаем ведение лога: mysql> set global log_slow_queries=’ON’; Query OK, 0 rows affected,…
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 the rsync will copy different parts…
1. Download and install the latest version #For Debian wget deb/squeeze/x86_64/percona-xtrabackup_2.0.6-521.squeeze_amd64.deb dpkg -i percona-xtrabackup_2.0.6-521.squeeze_amd64.deb #For RedHat wget RPM/rhel6/x86_64/percona-xtrabackup-2.0.6-521.rhel6.x86_64.rpm yum install percona-xtrabackup-2.0.6-521.rhel6.x86_64.rpm innobackupex –user=DBUSER –password=DBUSERPASS ${/path_to/BACKUP-DIR} $ gpg –keyserver –recv-keys 1C4CBDCDCD2EFD2A … [some output removed] … gpg: imported: 1…
Show process list: SHOW PROCESSLIST; asd Properties of Transactions: Transactions have the following four standard properties, usually referred to by the acronym ACID: Atomicity: ensures that all operations within the work unit are completed successfully; otherwise, the transaction is aborted…
mysql> SHOW TABLES LIKE “phpbb_%”; /* list all phpBB tables */ mysql> DROP TABLES LIKE “phpbb_%”; /* DROP THEM? Quite a naive approach.. */
For successful backup the packet size must be the same [mysqld] key_buffer = 160M max_allowed_packet = 150M [mysqldump] quick max_allowed_packet = 160M
Mysql Instances