Table Sizes on MySQL

Hi,

During the course of my daily work I occasionally search for mysql queries which are cool and helpful. I once found the following query on http://forge.mysql.com/:

SELECT table_name article_attachment,
engine,
ROUND(data_length/1024/1024,2) total_size_mb,
ROUND(index_length/1024/1024,2) total_index_size_mb,
table_rows
FROM information_schema.tables
WHERE table_schema = 'dbname'
ORDER BY 3 desc;

You can add or remove columns etc and but this query shows the table size (data wise) index size, approx number of rows, size in KB etc. If you would like to know what else is available to add to this query, just do a "desc tables" while using the informations chema (database).

Firefox & Shortcuts Maniacs

Mornings guys & gals, just a small and quick note which some of you might like others won't give a shit about ....... there is a list of Firefox shortcuts linked to this blog. There are some cool ones, others obvious ones and few stupid ones.

tc
Darren

Living a life terrified from mobile phone tunes!

Life on call makes you mobilephoneophobic. Shivers go down your spine at the sound of a mobile call or an sms, night sleep is troubled, fearing the worst, sometimes you’re even afraid of going out without a laptop (having to go home in the middle of an event) while a first date during the week on call is unthinkable :). A weekend without calls, sounds like a myth and definitely is a blessing. It’s the curse of sysadmins, dbas and consultants! (at least consultants are paid well for it :)).

Oh well, life ain’t easy, deal with it!

Intelligent Platform Management Interface (IPMI)

ipmitool found under (/usr/sfw/bin/ipmitool) is a cool tool for controlling IPMI enabled devices. It can run either locally or remotely (though highly insecure *read man ipmitool) and can serve several purposes from monitoring (ipmitool chassis status) to power off / restart machine (ipmitool power off) etc.

Introducing Myself

Greetings guys and gals, my name is Darren Cassar a Maltese engineer with a passion for technology and systems engineering. After graduating in 2005 with a B.Eng(Hons) from the University of Malta, specialising in computer and communications, I worked at Vodafone Malta Ltd as a systems engineer for 365 days :) after which I moved to Ixaris Systems Malta Ltd, a company providing a service ENTROPAY (online payment system) used throughout the world. My roles shifted from systems engineering in the IT department for 11months to database administration in the operations department since June 2006.

MySQL: a job, a life, I work MySQL, read MySQL, eat MySQL, sleep .... nah fuck MySQL during sleep :). The reason why I decided to start this BLOG (my second one) is that I would like to share my DBA experiences at work as well as during play (yeah right) which include, setup and configuration, performance tuning and debugging, profiling, replication and hopefully soon enough, CLUSTERING.

I am also a keen but junior unix like OS user including and preferring Solaris10 and Suse 10.3 platforms.

Saying something about my personal life, well, I'm a semi professional photographer (www.photomalta.com is my domain), a son to two great parents, a brother to two older pest brothers (both engineers too) and an uncle to two angels Hayden and Matthew (engineers to be hopefully hehe) :).