… as our schema changes over time: mysql> create view all_indexes …fk_address_id | | sakila | staff | idx_fk_store_id | | sakila | store | idx_fk_address_id | +————–+—————+—————————–+ 23… rental_date NON_UNIQUE: 0 COLUMN_CNT: 3 COLUMN_NAMES: rental_date,inventory_…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
…_no=10008; +——–+——–+————+————+ | emp_no | salary | from_date | to_date | +——–+——–+————+————+ | 10008 | 46671 | 1998-03-11 | 1999… to save a lot of time and some headaches 
Instead of… main tablespace which is not stored in .ibd file. innodb_import_…
Post: Intro to OLAP
July 12, 2010 By 10 Comments
…. The extra time spent during the load is usually called “processing” time. A relational OLAP (or ROLAP) server uses data stored in an…” example above, all the dimensions are degenerate: gender, region, style, date. [caption id=”attachment_3264″ align=”aligncenter” width=”293″ caption=”Example…
Comment: Full text search for all MySQL Storage Engines
June 28, 2006 By 37 Comments
…, IFs would just store those H hits, while SFs store N*W bits, so SFs needs store N*W/H bits…ll need to spend at least some bits from time to time to encode blocks of zeroes anyway. And with…d need to sort either by date, or by relevance, or something else. Date could sometimes be fine; sometimes, it…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… at least good to convert it in binary form and store as VARBINARY(16) for performance reasons. In any case you… time“, computing aggregate functions as needed. Q: Is there any special concerns or tricks for selecting using some date ranges? or between dates? or after a date? A: Date comparisons work very similar to other…
Post: Joining on range? Wrong!
May 17, 2010 By 10 Comments
…€“ a sales query. Our data is a tiny store directory consisting of three very simple tables: CREATE TABLE… crudity of this model, I didn’t have time to build it to scale or to paint it.”…__and__itm_order_date (itm_prd_id, itm_order_date); UPDATE items_ordered SET itm_order_date = DATE(itm_order_…
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
…date | +————-+———+———-+—————————–+ 1 row in set (0.00 sec) oops. Little gotcha. MySQL considers table up to date even though stats stored… refresh update time. mysql> show index from antest; …
Post: Using Flexviews - part one, introduction to materialized views
March 23, 2011 By 3 Comments
… results of the SELECT portion of the statement are stored in a table. Storing the results of a SQL statement into a… both store results in a table, the MV represents the results of a SQL statement at a specific point in time, essentially… must be refreshed. Refreshing a MV brings it up to date to reflect the changes in the database since the view…
Comment: Full text search for all MySQL Storage Engines
June 29, 2006 By 37 Comments
…using SPH_MATCH_ALL along with SPH_SORT_DATE_DESC/SPH_SORT_DATE_ASC. Regarding relevance the problem is that…interresting is if there exist some method to efficiently store sparse vectors. A quick fix in my case was…06 seconds (and 0.06 seconds was the total time, say 0.05 seconds was cpu bound or …
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
…RESERVATION/) { $SecGroup = $fields[3]; } if (/^INSTANCE/) { $IPAdd = $fields[17]; $STORE = $fields[20]; $Instance_ID= $fields[1]; $AMI_ID…to generate unique one is to run “date | md5sum” and grab a substring from the …to reach the other node and the timing parameters. “warntime” is a soft timeout in…
