Database performance can make or break your application's user experience. When your SQL queries are running slowly, users feel it immediately through sluggish page loads and unres…
https://www.youtube.com/watch?v=b2F-DItXtZs
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 FUNC…
MyISAM table 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 -…
mysql> pager less; PAGER set to ‘less’ Выводим информацию о текущих установках глобальных переменных: mysql>…
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…
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…