Posted by Vadim |
This is next post in series
Analyzing air traffic performance with InfoBright and MonetDB
Air traffic queries in LucidDB
Air traffic queries in InfiniDB: early alpha
Let me explain the reason of choosing these engines. After initial three posts I am often asked “What is baseline ? Can we compare results with standard MySQL engines ?”. So there come MyISAM to consider it as base point to see how column-oriented-analytic engines are better here.
[read more...]
Posted by Morgan Tocker |
We’ve been busy expanding our training curriculum to include training for developers building applications with MySQL. We have reached the point where we’re ready for a pilot teach – and it brings me great pleasure to announce that we’re opening it up for blog readers to attend, free of charge.
The details:
San Francisco
4th December
9:30AM – 5PM
Spaces are limited, so to give everyone a fair chance we’re delaying registration to open at noon tomorrow (Friday) Pacific Time. It’s strictly first in first served, so be quick! The registration link is here.
Posted by Vadim |
One problem made me puzzled for couple hours, but it was really interesting to figure out what's going on.
So let me introduce problem at first. The table is
CODE:
-
CREATE TABLE `c` (
-
`tracker_id` int(10) unsigned NOT NULL,
-
`username` char(20) character set latin1 collate latin1_bin NOT NULL,
-
`time_id` date NOT NULL,
-
`block_id` int(10) unsigned default NULL,
-
PRIMARY KEY (`tracker_id`,`username`,`time_id`),
-
KEY `block_id` (`block_id`)
-
) ENGINE=InnoDB
Table has 11864696 rows and takes Data_length: 698,351,616 bytes on disk
The problem is that after restoring table from mysqldump, the query that scans data by primary key was slow. How slow ? Let me show.
[read more...]
del.icio.us
digg