Big help...

I wanted to get my table sizes in infobright, and this page came to my help...

SELECT table_schema,table_name,engine, table_rows, avg_row_length,
(data_length+index_length)/1024/1024 as total_mb,(data_length)/1024/1024 as data_mb,
(index_length)/1024/1024 as index_mb, CURDATE() AS today
FROM information_schema.tables
WHERE table_schema='mySchemaName'
ORDER BY 7 DESC

Thanks Ron...
in reference to: Calculating your database size | MySQL Expert | MySQL Performance | MySQL Consulting (view on Google Sidewiki)

Useful mysql stuff...

Here's a compilation of my day to day use of mysql related stuff...

1. Resetting root password in mysql
   - Goto this page https://help.ubuntu.com/community/MysqlPasswordReset
   
   
2. To give privileges to a certain user in mysql
   - grant all on *.* to username
   
   
3. 
   

Improved Gutsy for 6710b

Going through a few Ubuntu forums, it turned out that many of the initial glitches around Gutsy installation for HP6710b have been removed.

My installation was originally an upgrade from Feisty, a very troubled and hacked one at that. So, I thought why not try to give it a clean shot and get a fresh copy of Gutsy installed on my laptop.

I dared and I like the results already. Few features -

• The system is a lot faster than it was before
• The graphics quality in general a lot better
• The fonts looks much better (though the settings are same)
• After installing xserver-xgl package, the Visual effects work
  

Though I had to spend some time to configure a few things again from scratch, it looks and works like a much better system than it used to.

After my fresh installation, I had initial trouble with installing rails. There this page helped. Though it talks about installation on FreeBsd, it worked perfectly on my Gutsy.

Then I had some trouble with initial password of root user on MySQL. For some reason, after the initial installation, I could not go in mysql environment through any means at all. Then again, googling and ubuntu forums helped out. This page helped me through that.

Finally, when I was installing Eclipse to be able to work faster/better with rails, I came across the fact that the standard Eclipse package from Ubuntu, does not come with any java runtime environment. I tried downloading and using Sun Java but that didnt turn out very well.

Later I found that Synaptics has a cunning little feature. On a right click on a package name, there is a option for "Mark Recommended For Installation". Once I clicked on that, it selected about 15 more packages and this time managed to get all the required stuff for Java as well.

Surprised as I was at the intuitiveness of the package management system, I felt it should hae done the same to start with. Anyway, its fine now. Took some time, but working great now. :)

Order for installing ruby gems locally

For installing ruby on rails basic framework when u dont have access to internet, you could follow the following order of installing gems...

Install Ruby

Install RubyGems

Install different gems

1. Rake
2. ActiveSupport
3. ActionPack
4. ActionMailer
5. ActiveRecord
6. ActionWebService
7. Rails

Also found some more info on installation of rails when internet connection is actually available. Here's the source of info, the rails wiki site

1. Installing Ruby

1. sudo apt-get install ruby irb ri rdoc ruby1.8-dev build-essential

2. Installing Ruby Gems

1. sudo apt-get install rubygems

3. Installing Rails

1. sudo gem install rails -y

4. Installing MySql

1. sudo apt-get install libmysql-ruby mysql-server libmysqlclient15-dev

2. sudo gem install mysql

Some more documentation on Ubuntu site