…2172) ==9090== by 0x6B35B5E: fil_io (fil0fil.c:4432) ==9090== by 0x6B67EDA: log_group_write_buf (log0log.c:1290) ==9090== by 0x6B68496: log_…JOIN*, enum_schema_table_state) (sql_show.cc:6238) ==9090== by 0x6A5E0C: JOIN::exec() (sql_select.cc:1863) ==9090== by 0x6A7D72: mysql_select(THD…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
Post: How (not) to find unused indexes
October 16, 2009 By 2 Comments
… AUTO_INCREMENT=65691 DEFAULT CHARSET=latin1; mysql> SELECT count(*), status FROM sales GROUP by status; +———-+———+ | count(*) | status | +———-+———+ | … ”, `Name` char(52) NOT NULL DEFAULT ”, `Continent` enum(‘Asia’,'Europe’,'North America’,'Africa’,'Oceania’,'Antarctica…
Post: Idea: Couple of more string types
April 18, 2008 By 12 Comments
MySQL has a lot of string data types – CHAR, VARCHAR, BLOB, TEXT, ENUM and bunch of variants such as VARBINARY but I… if BLOB is not used in any WHERE clause (HAVING, GROUP BY etc) you could actually transparently decompress it on the client…. Though this is likely to require more significant changes in MySQL so I would not expect to happen quickly. The basic…
Post: Intro to OLAP
July 12, 2010 By 10 Comments
…particularly OLAP (or online analytical processing) tools using MySQL and other free open source software. OLAP… into different groups. A typical OLAP analysis might show “sale total, by year, by sales rep, by product …. A degenerate dimension is stored as an ENUM in many cases. In the example below…
