Percona's MySQL & InnoDB performance and scalability blog
…the STRAIGHT_JOIN, the query optimizer reordered the tables. It seemed to prefer an index-scan of 7 rows in the `kind_type` table to…
…the table ‘test.test’. This is deprecated and will be disallowed in a future release. 1 row in set (0.00 sec) As the…to get more familiar with this and other particularities of the latest MySQL GA release, have a look at our upcoming sessions for the “Moving to…
…get the table row format from the Information Schema: mysql (information_schema) > SELECT ROW_FORMAT from TABLES WHERE TABLE_SCHEMA=’employees’ AND TABLE_NAME…
…the local machine which is the usual configuration for Flexviews since it requires local access to the tables and the changelogs in order to…and then insert some more of them: mysql> create table > test.demo ( > c1 int auto_increment primary key, > c2 int > ) > engine=innodb; Query…
…and it appears to work fine. But here’s where things start to get even weirder. According to the documentation, if we specify the name of a table…
…table test.t(a int) engine=innodb *************************** 3. row *************************** Log_name: mysql-bin.000011 Pos: 211 Event_type: Query…typing COMMIT, the rest of the statements go into the binlog. It appears to me that there’s no way to get the CREATE TEMPORARY TABLE statement to…
…the full table scans access the table by primary key. This forces the storage engine to touch the same page numerous times in rapid succession. This invariably moves the…
…query execution. I typically look at ANALYZE TABLE and adding it to the table if I see having it run helps to get good plans. If query…Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type…
…to log only queries doing full table scans you would need to set this to “full_scanâ€, while in order to get…and the file may grow huge very quickly when logging all the queries. This parameter allows you to get the…
…queries to find space used by particular table “type” in sharded environment when multiple tables with same structure and similar name exists: SELECT count(*) tables, concat(round(sum(table…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.