Percona's MySQL & InnoDB performance and scalability blog
… NULL, `full_name` varchar(100) DEFAULT NULL, `details` text, PRIMARY KEY (`id`), FULLTEXT KEY `full_name` (`full_name`,`details`) ) ENGINE=InnoDB DEFAULT CHARSET… a hidden column (similar to GEN_CLUST_INDEX when you don’t define a PRIMARY KEY, I assume) when I already have an… the table and which need to be merged back into or removed from the main index. I’m not entirely sure about…
… I tried to create an InnoDB FT index before declaring the `FTS_DOC_ID` primary key column properly, MySQL crashed with an out… the operating system. So be careful about declaring the correct primary key! Mario asked: Q: Did you compare relevancy of search results… be a function to merge an RT index with an on-disk index, so integrating recent changes with the full index may require reindexing…
…, Normalize! > INDEX OOU (`ObjectClass`, `ObjInstance`, `UTCTime`), > INDEX `GroupId` (`ObjectClass`) DROP the latter (as I mentioned earlier) MERGE is an… all your secondary keys; they are possibly useless. This will greatly speed up INSERTs. > PRIMARY KEY (`ObjectClass`, `ObjInstance`, `UTCTime`),…
…. For medium sized blobs it would be much better to merge them and store on the same segment and ie only… by primary key it is so helpful in many cases, but in other cases you would like to cluster data by index which… penalty of very long primary key – you can simply select not to cluster by it instead of creating fake primary key and promoting real…
…: Page may be an index page where index id is 0 25556 InnoDB: (index “PRIMARY” of table “test”.”…-> `id` int(10) unsigned NOT NULL AUTO_INCREMENT, -> PRIMARY KEY (`id`) -> ) ENGINE=MYISAM; Query OK, 0 rows… to block purging activity, insert buffer merge or recovery from transactional logs all together…
…INDEX OOU (`ObjectClass`, `ObjInstance`, `UTCTime`), INDEX `UTCTime` (`UTCTime`), INDEX `MSISDN` (`ObjInstance`), INDEX `GroupId` (`ObjectClass`) ) ENGINE=MERGE…NOT NULL, PRIMARY KEY (`ObjectClass`, `ObjInstance`, `UTCTime`), INDEX `UTCTime` (`UTCTime`), INDEX `MSISDN` (`ObjInstance`), INDEX `GroupId…
… which was had data merged into it with INSERT ON DUPLICATE KEY UPDATE statements. The performance … NOT NULL, `c` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY(c) ) ENGINE=InnoDB PARTITION BY RANGE(id) … we remove index on column C – the “UPDATE” part of INSERT ON DUPLICATE KEY UPDATE completes …
… table on which all parts of a primary key or unique key lookup are satisfied in the where clause….read. This is because these tables contain no indexes. There is another interesting thing, and I …MySQL makes when accessing views which use the MERGE algorithm. For example: mysql> create view v1 as …
… you try to query against an indexed data, mysql will go trough each index and if the index‘s size is around a few megabytes for each table, this can dramatically slow down the usually fast unique/primary key look ups (as all partition(table) got its own indexes right?). It was the same for me with myisam-merge (what…
… primary key consisting of 3 columns (ObjInstance (10000 types), objectClass (100 types) and timestamp of addition). All the 3 columns are also indexed… (NOT good if it does not match insert rate) b) MERGE tables based on dates (sharding the main table) –> Queries and… that this might be because all the tables below the merge table are queried. Also, there might be locking happening when…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.