ruturaj's blog

Federer !!!

Tags:

Federer was finally able to break the serve of Andy Roddick in the 5th set which he won 16-14. The although lasted 5hrs, was marred, yes marred by Aces, Federer with 50 and Andy with 27. The match was all on serves, hardly with any rallies going.

Roger kisses the cup

Roger kisses the cup

Michael Owen (Forward) - Manchester United

Tags:

Well no body expected that to happen, but it has finally. Michael Owen has signed a 2yr deal with Manchester United.

Owen signs for Man Utd

Michael Owen signs for Man Utd

Siddhagad Trek

Tags:

Monsoons had just arrived and we couldn't resist the first one of the wet season, Siddhagad. Located near Murbad, between Gorakhgad and Bhimashankar, it was a good outing for us, Vj, Mallik, R.A. Jo B.A, Sneha, Swati and Kudrat. We could've hiked the final Balekilla, but as we were on a tight one-day schedule, we had to reach up to the cave atop the Siddhagad machi and return back.

Siddhagad Photos
Siddhagad Photos

Travelling Directions

  • Get a train for Kalyan Railway Station (Central Railway)
  • A ST bus to Murbad
  • Another ST bus to Narivali
  • A walk starts which converts to a trek soon - towards Siddhagad

Approximate time of Trek: 6-7 hrs (including the return to the base village)

Fedora 11 on Acer 4736Z

Tags:

I finally managed to get a new Laptop, Acer 4736Z. I'd to wait before Fedora 11's download was complete and I could install it.

Overview

  • Graphics card works out of the box (1366x768 resolution)
  • Sound is detected well
  • Wireless and bluetooth are working
  • The Web Camera is detected and working well
  • The Brightness control doesn't work
  • The gsynaptics had to be installed to enable tap on the touchpad

All and all it looks good. Here is a screenshot.
Fedora 11 on Acer 4736Z

Pulseaudio CPU usage
Great work, Pulseaudio in F11 uses lesser CPU as compared to Fedora 10 Pulse Audio

French Open 2009

Tags:
Not going Safina's way
Not going Safina's way
Kuznetsova finally gets the trophy from Steffi Graf
Kuznetsova finally gets the trophy from Steffi Graf
Finally clay is conquered by Roger Federer, Agassi presents him the trophy
Finally clay is conquered by Roger Federer, Agassi presents him the troph

Manchester United - League leaders yet again

Tags:
2008-2009 EPL Tropy Winners
2008-2009 EPL Tropy Winners


Ferguson with the 2008-2009 EPL Tropy
Ferguson with the 2008-2009 EPL Tropy

Fedora 10 Pulse Audio High CPU Usage

Tags:

Guys using Fedora 10, must've seen this problem of Pulseaudio taking high CPU usage. After a lot of tweaking, I came to this. From System -> Preferences -> Hardware -> Sound

Change all the drop downs to ALSA. Just make sure u "Test" and hear the tone before applying the changes.

pulseaudio with lower cpu usage

Update

I've done this yum remove pulseaudio. This removes the root cause :)

Dell 1525 Fedora 10 Wifi

Tags:

Configuring Wifi on Dell 1525 with Fedora 10 wasn't much a problem. I enabled the RPM Fusion Free and Non Free repositories. And used the following command.

yum install broadcom-wl

Rest of the control was taken by GNOME.

Handwriting

I read this story on BBC, http://news.bbc.co.uk/2/hi/uk_news/magazine/7907888.stm.

A century from now, our handwriting may only be legible to experts.

For some, that is already the case. But writer Kitty Burns Florey says the art of handwriting is declining so fast that ordinary, joined-up script may become as hard to read as a medieval manuscript.

"When your great-great-grandchildren find that letter of yours in the attic, they'll have to take it to a specialist, an old guy at the library who would decipher the strange symbols for them," says Ms Florey, author of the newly-published Script and Scribble: The Rise and Fall of Handwriting.

Interesting as well as disappointing. In future we'd be lost in sans-serif and serif, the Verdanas and Tahomas.

MySQL DB Pie Graph

Tags:

Its same as what http://blog.olindata.com/2009/02/using-the-google-graph-api-with-mysql-stored-functions/ had posted, I've just updated a little. And there are no smart quotes here. So u can copy paste ;)

DELIMITER $$

DROP FUNCTION IF EXISTS `test`.`FNC_GOOGRAPH_DB_SIZE`$$
CREATE FUNCTION `test`.`FNC_GOOGRAPH_DB_SIZE` (
  p_chart_type CHAR,
  p_height INT,
  p_width INT) RETURNS varchar(3000) CHARSET latin1
  READS SQL DATA
BEGIN
  /* Author:    Walter Heck - OlinData */
  /* Date:      20090216 */
  /* Note:      After an idea by Alex Gorbachev - Pythian */
  /*            http://www.pythian.com/blogs/1490/google-charts-for-dba-tablespaces-allocation */

  /* variable declaration */
  DECLARE v_done BOOLEAN default false;
  DECLARE v_url varchar(3000);

  DECLARE v_schema_name varchar(3000);
  DECLARE v_data_length_sum int;
  DECLARE v_data_length_total int;
    
  DECLARE v_legend_labels varchar(3000);
  DECLARE v_chart_labels varchar(3000);
  DECLARE v_chart_data varchar(3000);

  /* Cursor declaration */
  DECLARE c_schema_sizes cursor for
      select
        t.table_schema,
        round(sum(t.data_length + t.index_length) / 1024 / 1024) as data_length_schema
      from
        information_schema.tables t
      group by
        t.table_schema
      order by
        t.table_schema;

  /* Handler declaration */
  DECLARE CONTINUE HANDLER FOR NOT FOUND SET v_done = true;

  /* Initialize the variables */
  SET v_legend_labels = '';
  SET v_chart_labels = '';
  SET v_chart_data = '';

  /* Get the total data length + index_length for all tables */
  select
      round(sum(t.data_length + t.index_length) / 1024 / 1024) as data_length_total
  into
      v_data_length_total
  from
      information_schema.tables t;
    
  /* Open the cursor */
  OPEN c_schema_sizes;

  /* Loop through the cursor */
  get_data: LOOP

      /* Fetch the next row of data into our variables */
      FETCH c_schema_sizes INTO v_schema_name, v_data_length_sum;

      /* if there is no more data, v_done will be true */
      IF v_done THEN
        /* Exit the loop */
        LEAVE get_data;
      END IF;

      /* Add the schema name to the labels for the legend */
      IF v_legend_labels = '' THEN
        SET v_legend_labels = v_schema_name;
      ELSE
        SET v_legend_labels = concat(v_legend_labels, '|', v_schema_name);
      END IF;

      /* Add the total size of the schema to the labels */
      IF v_chart_labels = '' THEN
        SET v_chart_labels = v_data_length_sum;
      ELSE
        SET v_chart_labels = concat(v_chart_labels, '|', v_data_length_sum);
      END IF;

      /* Get the percentage of the total size as the graph's data */
      IF v_chart_data = '' THEN
        SET v_chart_data = ROUND(v_data_length_sum / v_data_length_total, 2) * 100;
      ELSE
        SET v_chart_data = concat(v_chart_data, ',', ROUND(v_data_length_sum / v_data_length_total, 2) * 100);
      END IF;

  END LOOP get_data;

  /* Close the cursor */
  CLOSE c_schema_sizes;
    
  /* Build up the google graph url */
  SET v_url = 'http://chart.apis.google.com/chart?';
  SET v_url = CONCAT(v_url, 'cht=', p_chart_type);
  SET v_url = CONCAT(v_url, '&chs=', p_width , 'x', p_height);
  SET v_url = CONCAT(v_url, '&chtt=Database Sizes (MB)');
  SET v_url = CONCAT(v_url, '&chl=', v_chart_labels);
  SET v_url = CONCAT(v_url, '&chd=t:', v_chart_data);
  SET v_url = CONCAT(v_url, '&chdl=', v_legend_labels);

  /* return the url as the function's result */
  RETURN v_url;
END$$

DELIMITER ;