DB Status and Queries Running

May 3rd, 2012

Here are a few useful tips to assist in determining the impact of your queries on your database.

If you have multiple databases that are load balanced or want to ensure that you are on the intended database server/instance:
SELECT @@hostname;

To check what queries are currently running:
SHOW FULL PROCESSLIST;

Often when checking your query performance using EXPLAIN, it tells you the possible keys/indexes that will be used. But what can be even more useful to determine just how many rows are being scanned each time it runs, embed your query within the following:

FLUSH STATUS;
SHOW SESSION STATUS LIKE "Handler%";
SELECT * FROM `mytable`;
SHOW SESSION STATUS LIKE "Handler%";

The Value for Variable_name = Handler_read_next is the number of records actually scanned during your query.

Variable_name Value
Handler_commit 1
Handler_delete 0
Handler_discover 0
Handler_prepare 0
Handler_read_first 1
Handler_read_key 2
Handler_read_next 806
Handler_read_prev 0
Handler_read_rnd 0
Handler_read_rnd_next 0
Handler_rollback 0
Handler_savepoint 0
Handler_savepoint_rollback 0
Handler_update 0
Handler_write 0

West Coast Aquatic Safaris website launched!

April 26th, 2008

West Coast Aquatic Safaris invites you, your friends and family to see for yourselves. Their boat has been specially designed to make the most of your experience, and their tours to take you off the beaten path. Environmentally responsible, knowledgeable, innovative and safe, West Coast Aquatic Safaris represents a new wave of ecological tourism.

ยป www.whalesafaris.com

Welcome To Toad Hall, Ludlow England

October 1st, 2007

Toad Hall offers a delightful place to spend your time in Ludlow. It has 3 bedrooms, 2 washrooms and a full bathtub, diningroom, and sitting room with adjoining conservatory leading to the garden.

All this comfort is located within a 3 minute walk to the center of town where you can explore the old Norman Castle, the bustling farmers market, or the grand tower of St. Lawrence Church with its spectacular view of the countryside.

» www.stayludlow.co.uk

FirlingCanada.com is launched!

September 15th, 2007

FirlingCanada is a small technology company based out of South Western British Columbia. We specialise in a wide range of technologies from Telecommunications to Web Development. The primary drive of the company now is Web Development, focusing on PHP scripting and Flex design.