Remote desktop sharing Ammyy Admin - download!

Ammyy Admin is free of charge for non-commercial use. You can download remote control application and start working with it within a few seconds.

Ammyy Admin - is a fast and easy way to gain remote sharing and remote desktop control!

Source: http://www.ammyy.com/en/downloads.html

Get list of existing TRIGGERs in MYSQL

While MySQL has features like StoredProcedure and View, it doesn't have any option for displaying TRIGGER list in the 'Schemata' tab (right) section of QueryBrowser.

Generally, we need a third party control like MySQL Workbench to get the list of existing TRIGGER lists.But there is another way through which we can get existing trigger lists and that is from the Metadata(Data about data).

To get all the trigger list irrespective of the database name:

 

SELECT * FROM information_schema.TRIGGERS;

To get list of trigger against a specific database:

 

SELECT * FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA='database_name';

 

 

Source: http://www.mindfiresolutions.com/Get-list-of-existing-TRIGGERs-in-MYSQL-856.php

 

Howto: Performance Benchmarks a Webserver

Apache Benchmark

You can benchmark Apache, IIS and other web server with apache benchmarking tool called ab. Recently I was asked to performance benchmarks for different web servers.
It is true that benchmarking a web server is not an easy task. From how to benchmark a web server:

First, benchmarking a web server is not an easy thing. To benchmark a web server the time it will take to give a page is not important: you don't care if a user can have his page in 0.1 ms or in 0.05 ms as nobody can have such delays on the Internet.

What is important is the average time it will take when you have a maximum number of users on your site simultaneously. Another important thing is how much more time it will take when there are 2 times more users: a server that take 2 times more for 2 times more users is better than another that take 4 times more for the same amount of users."
Here are few tips to carry out procedure along with an example:

Apache Benchmark Procedures

• You need to use same hardware configuration and kernel (OS) for all tests
• You need to use same network configuration. For example, use 100Mbps port for all tests
• First record server load using top or uptime command
• Take at least 3-5 readings and use the best result
• After each test reboot the server and carry out test on next configuration (web server)
• Again record server load using top or uptime command
• Carry on test using static html/php files and dynamic pages
• It also important to carry out test using the Non-KeepAlive and KeepAlive (the Keep-Alive extension to provide long-lived HTTP sessions, which allow multiple requests to be sent over the same TCP connection) features
• Also don't forget to carry out test using fast-cgi and/or perl tests

Source : http://www.cyberciti.biz/tips/howto-performance-benchmarks-a-web-server.html#comments