December 26, 2006

Geek

Bum!

MySQL supports large files if your operating system does. So there's no need to worry about your application dropping dead if a particular MyISAM table exceeds 4GB.

Except that the default table pointer size is 32 bits.

And it seems that changing it from 32 to 40 bits slows database writes by about 10%.

Not that I will necessarily be using MyISAM. What I was doing when my table hit 4GB was finding out whether to use MyISAM or InnoDB.

Well, off we go again. About 4500 inserts per second right now (at one record per query, which is far from the fastest method, but is after all what the application will be doing).

Posted by: Pixy Misa at 11:57 AM | Comments (96) | Add Comment | Trackbacks (Suck)

1 I can't be bothered with anything these days, but such is life. I don't care. So it goes. More or less nothing seems worth thinking about. I've just been hanging out waiting for something to happen, but that's how it is.

Posted by: Sten4470 at May 12, 2007 01:52 AM (9LigW)

2 I haven't been up to anything today. I don't care. I've just been staying at home not getting anything done. Basically not much happening right now. Maybe tomorrow. I guess it doesn't bother me.

Posted by: Sten58621 at May 17, 2007 06:39 PM (P9uGY)

3 I just don't have anything to say. Not that it matters. Eh. I've just been staying at home doing nothing, but I don't care. That's how it is.

Posted by: Sten88120 at May 21, 2007 03:46 AM (jSW3h)

4 My life's been pretty dull recently. Shrug. My mind is like a void. I haven't gotten anything done lately. I can't be bothered with anything recently.

Posted by: Sten62960 at June 09, 2007 03:52 PM (Jr80K)

5 wdae upyxsmel ydzxtbpa jwotml ohirw clqiombxg tblaed

Posted by: omxvwy xkmqv at June 22, 2007 12:04 AM (/TcH6)

6 if1j27

Posted by: gBqCPWBvh at April 02, 2009 06:24 AM (5hgre)

7 [url=http://www.tissotsale.com/ladies-gold-tissot-watches.php]ladies gold tissot watches[/url]

Posted by: grgt at June 11, 2011 08:33 PM (8+5mI)

8 zhengjie199054
Gucci outlet
Gucci Travel Bags
New Arrivals Bags
Gucci Outlet
cheap bags
gucci bag
Gucci Business Bags
Gucci Hobo Bags
Gucci Indy Bags
Gucci Messenger Bags
Gucci New Jackie Bags
Gucci Shoulder Bags
Gucci Tote Bags
Gucci Travel Bags
New Arrivals
Gucci Handbags Outlet

Posted by: Gucci handbag store at June 30, 2011 04:57 PM (HHNAl)

Hide Comments | Add Comment






Processing 0.0, elapsed 0.0135 seconds.
16 queries taking 0.0094 seconds, 30 records returned.
Page size 10 kb.
Powered by Minx 0.8 beta.