… data in pages, not rows, and so the whole page needs to be in memory even if you need only one row from… 20% from 9216 to 11059. The results for 4K results start dropping earlier. This is because the database actually takes more space… 620MB so if Innodb would chose to keep only compressed pages in memory it should be able to keep about 1/5 of…
Comment: Full Text Search Webinar Questions Followup
August 27, 2012 By 5 Comments
… particular bit: > Since RT indexes are in volatile memory, not stored on disk, you are responsible …a binary write-ahead log, just like a database would. You can explicitly disable that for performance…the full index may require reindexing the whole dataset from time to time. And, for the record, …
Comment: When should you store serialized objects in the database?
January 21, 2010 By 47 Comments
… 1 or 2 characters, writing and reading the whole thing. I indexed it in my notes file…be: compress it before stuffing it into the database. Different strokes for different folks. 70 requests …, and 20GB/week doesn’t mean much to me unless I know things like the … like a b-tree not fitting into memory…
Comment: Analyzing air traffic performance with InfoBright and MonetDB
February 2, 2010 By 50 Comments
… first time I was impressed by performance numbers of columnar databases, but now … I think that there are a lot of… sec for Infobright. -Q1: Count flights per day from 2000 to 2008 years SELECT DayOfWeek, count(*) AS c FROM ontime WHERE… aggregation in memory. DayOfWeek requires only 3 bits per row => for 117M row table, it will need ~30Mb to store the whole column…
Comment: Finding your MySQL High-Availability solution – The questions
October 19, 2009 By 36 Comments
…to be in memory but… that about the same with InnoDB, at least the active dataset needs to … to row based replication would have help. @Ryan H: Yes, my discussion is about a single database… way to reduce cross-node interactions. How do you manage things like searching through the whole dataset…
