lunatechian (lunatech-ian)

one relating to, belonging to, or resembling lunatech

innodb and blobs

Are you planning on storing blobs in Innodb tables? If yes, think again. According to the manual,

InnoDB stores the first 768 bytes of a VARBINARY, VARCHAR, BLOB, or TEXT column in the row, and the rest into separate pages.

This translates into slower retrieval for blobs. However, InnoDB can skip reading blobs if they are not in select column list.

One solution for this is to keep blobs in a separate myisam table and do a join when you need the blob column.

Defined tags for this entry:

mysql bugs

If you are a heavy user of MySQL, I think you will appreciate this list of saved bug searches. For example, check out "p1_bugs_in_5.1" or "ActiveInnoDBBugs" These saved searches are also available as rss feeds.

Defined tags for this entry:

Mon Sep 29

In the morning I had to visit to the VFS office in Bangalore. The place has very strict security. I was carrying my laptop and the security person at the gate did not allow me to go in :-(. The man at the parking section said he could keep the bag, but he wanted 50 Rupees for that. I really lost my head when he told me the amount. Anyhow, I did not think it would be safe to leave the laptop with him. I will have to visit that office tomorrow again.

Due to time taken to visit the VFS office, I could not do much work at the office.

I had woken up at 6:00 AM today and that had given me enough time in the morning to do some emacs hacking. I really should spend time on learning lisp instead of copying stuff from random places.

Today my trainer at the gym changed my exercise schedule. It became quite grilling. However, I was able to get through the workout. Hopefully in 2-3 days time, I would be able to breeze through the workout.

Defined tags for this entry: