SQL> SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type" FROM sys.v_$parameter WHERE name = 'spfile'; Init File Type -------------------------------- SPFILE &n…
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.
Oracle License SQL Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL>…
esxcli system snmp set –communities public esxcli system snmp set –targets pod23-esx-01a.pml.local@161/public esxcli system snmp set –enable true esxcli system snmp test &nbs…
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 -…
#Advanced Options "/S /v"/qn REBOOT=R""
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…
http://<FQDN or IP Address>:9443/vsphere-client/ vCLI VMware vSphere® Management Assistant (vMA): - virtual appliance VMware vSphere® PowerCLI: • Automation tool f…
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…