… constantly referring to the amazing MySQL manual, especially the option and variable reference table. But…commanual have_profilingblogpercona.commanual have_query_cacheblogpercona.commanual have_rtree_keysblogpercona.commanual have_sslblogpercona.commanual have_symlinkblogpercona.commanual …
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… forbid moving to Innodb are typically Full Text Search and RTREE indexes/GIS with Full Text being much more common. There are… well as it exercises not so common paths in the MySQL server – in particular Optimizer may have harder time because costs…
Comment: Duplicate indexes and redundant indexes
September 22, 2006 By 38 Comments
… at least in MySQL, the prefix redundancy problem just cannot occur for RTREE Spatial index, because they cannot be composite: mysql> create table geom (g1 geometry not null, g2 geometry not null, spatial index(g1…
