...
For seeing this one must enable the general query log of mysql
mysql> show variableslike '%log%';mysql> set global general_log=ON; |
The default location of the general query log on most distributions is /var/run/mysqld/mysqld.log
alternatively edit `/etc/my.cnf
` adding
general-log
And if you are looking just for slow queries, add the following:slow-query-log
slow_query_log_file=/location/of/your/slow.log
slow_query_log=1
long_query_time=<your choice of value>
2. Unable To Migrate the Instances which are with vCenter
Check if vMotion is enabled [http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1036145]
To enable vMotion |
3. How to get the CloudStack version from database?
mysql>select *from cloud.versionorder by iddesc limit 1; |
id | version | updated | step |
2 | 3.0.1 | 2012-04-03 06:42:06 | Complete |
4. How to get the complete details of a vm instance?
mysql>select *from cloud.vm_instance; |
5. How to enable trace logging for a particular class in CloudStack?
...
6. How to enable the ssh in vmware esx server?
• Edit the configuration filefor SSH with the command:nano /etc/ssh/sshd_config• Find the line that starts with PermitRootLogin and change the no to yes. You can findthis line about2 pages down from the top. Save the file by first pressing Ctrl-O and then Enter.. Exit with Ctrl-X.• Restart the sshd service with the command: service sshd restart |
7. Possible causes for Host to get into Alert State are :
1) Ping times out |
8. Failed to deploy Virtual Router : Reasons
1) No capacity in hypervisor - CPU/Memory |
9. How to enable innodb status to capture relevant db information?
1) To enable innodb logging, on every management server in the"db.properties" file add "includeInnodbStatusInDeadlockExceptions=true " to the"db.cloud.url.params" property |
10. KVM How to revert libvirt from latest version to old version Cent OS 6.1 KVM
1) Move all cent os repos to /oldrepos folder from yum.repos.d |
11. How to access router ?
1) Login to the host where Router VM is available2) Take the Link Local IP3) ssh -i ~/.ssh/id_rsa.cloud -p3922 vr-link-local-ip |
12. How to mount ISO and create Rhel repo ?
1) mkdir /root/nfssailaja |
13. Define the conserve mode which comes with network offering ?
Ans: Conserve mode meaning, we want to conserve thepublic IP address. soif it is on , then we can use onepublic ip addrfor multiple purposes like pf, lb,static nat, source nat etc.if it is off, then onepublic ip serves only one purpose. |
14. How to get Virt-manager working ?
yum groupinstall"X Window System" |
15 .KVM host cleanup steps?
1. Unmount all Primary storages |
16. Xenserver cleanup steps?
1. Destroy all VM's : xe vm-uninstall --multiple --force |
17. How to write into the attached volumes of cloudstack intances ?
1. fdisk /dev/sd* |
18. How to Enable HTTPS for CloudStack Web Interface?
Refer the documented information @ http://support.citrix.com/article/CTX132008 |
19. How to deploy CS UserVMs with User-data?
...
20. How to add Rhel5 repo?
1. mkdir /root/nfssailaja |
21. How can I allocate a specific IP when I create an instance
...
23. How to find if Xen PV drivers are installed on the instance?
1.Access VM console |
24. How to redirect SQL query results to a file ?
...
26. SSVM/CPVM are not working after DB dump from Management server 1 to Management Server2 ?
1. Access SSVM from Hypervisor and run /usr/local/cloud/systemvm/ssvm-check.sh |
27. How to install VMWare tools on a guest VM?
...
a. .cd vmware-tools-distrib
b. ./vmware-install.pl
28:How to install Xen tools on a guest VM?
...