May, 2010
How to Collect EVA logs – HP StorageWorks Enterprise Virtual Array
Collect  EVA logs / Events. 1. On the primary navigation bar, click Devices 2. Click “command view eva” 3. Click on the logical name of storage (below HSV Storage Network ) 4. Click “View Events” 5. Click (in box) to see the events listed in screen. Controller Event Log 6. To collect event logs click [...]
How to enable Query Caching in Mysql – Query Cache Configuration
The performance tuning of MySQL is very important for high traffic websites with MySQL as there DB. Â The db Admin always looking for ways to speed up query, in mysql we can enable query cache to speed up query performance. Whenever query cache is enable, it will cache the query in memory and boost query [...]
Some of MySQL Key area of performance tuning
1. Disks The fundamental battle in a database server is usually between the CPU(s) and available disk I/O performance; we’ll discuss memory momentarily. The CPU in an average server is orders of magnitude faster than the hard disks. If you can’t get data to the CPU fast enough, it must sit idle while the disks [...]
How to Purge MySQL Binary Logs periodically
If you are a Database Administrator then you should know about  Purge MySQL Binary Logs periodically. If you are having a replication environment then you can find so many binary files in your master server. This will eat-up lot of space of your hard disk. what is MySQL Binary Logs.– The binary log is a set [...]
How to speed up your website for Google Page Rank
Google has recently updated caffeine – Google’s New Search Engine Index.  The new  Google search Engine Index consider speed of the site as a matter for deciding  the page rank.  Google has released a wonderful tool to check the speed of the site. The tool is called pagespeed, its a Firefox add-on and its works with Firebug. You can Download pagespeed from [...]
How to Create a User for MySQL Replication
Each Slave must connect to the Master using a standard username and password. The user that you use for this operation can be any user, providing they have been granted the REPLICATION SLAVE privilege You do not need to create a specific user for replication. However, you should be aware that the username and password will [...]
How to Review hp service Guard Cluster and Package States
Information about cluster status is stored in the status database, which is maintained on each individual node in the cluster. You can display information contained in this database by issuing the cmviewcl command: # cmviewcl -v You can issue the cmviewcl command with non-root access: In clusters with Serviceguard version 11.16 or later, create a Monitor role in [...]
Google Apps Sync for Microsoft Outlook
What is Google Apps Sync? Google Apps Sync for Microsoft Outlook is a plug-in for Outlook 2003 or 2007 that lets you import your existing data from Exchange (or any other hosted service you use Outlook with) into Google Apps. You can then keep using your familiar Outlook interface to manage your Google Apps mail, [...]
How to get RHEL Version from command prompt
You can use the following command to get the RHEL version of your runing box. Just go the teminal and type the following command [root@pds6 ~]# cat /etc/redhat-release Red Hat Enterprise Linux ES release 4 (Nahant Update 5)
How to do Performance Tuning on MySQL – Best Practices for MySQL
It is very important to fine tune MySQL. There are so many things that may slowing down your MySQL server. May be the select queries may be scanning the entire table which may have millions of records. This happens because you may not using proper indexing. so let us go through the video for best [...]
What is Tornado web server? How to Install Tornado web server
Tornado is an open source version of the scalable, non-blocking web server and tools that power FriendFeed. The FriendFeed application is written using a web framework that looks a bit like web.py or Google’s webapp, but with additional tools and optimizations to take advantage of the underlying non-blocking infrastructure. The framework is distinct from most mainstream web server [...]
How to enable JavaScript in your browser
Click the link for your browser below to get specific instructions on enabling JavaScript in your browser. If your browser isn’t listed, please consult its help resources. Internet Explorer 6 or 7 Click the Tools menu. Select Internet Options. Click the Security tab. Click the Custom Level button. Scroll down until you see the ‘Scripting’ [...]
How to Get MySQL
This section does not apply to MySQL Enterprise Server users. Check our downloads page at http://dev.mysql.com/downloads/ for information about the current version of MySQL and for downloading instructions. For a complete up-to-date list of MySQL download mirror sites, see http://dev.mysql.com/downloads/mirrors.html.
How to Determine your current MySQL version
To determine the version and release of your currently installed MySQL installation, there are a number of options. For example, here is the output from a MySQL Community Server edition installed on Linux: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 Server version: 5.0.27-standard MySQL Community [...]