Skip to content

Instantly share code, notes, and snippets.

@marcomorain
Created November 20, 2012 17:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save marcomorain/4119629 to your computer and use it in GitHub Desktop.
Save marcomorain/4119629 to your computer and use it in GitHub Desktop.
MySQL Crash Explain
mysql> SHOW CREATE TABLE install_tracking_results \G;
*************************** 1. row ***************************
Table: install_tracking_results
Create Table: CREATE TABLE `install_tracking_results` (
`game_id` int(11) NOT NULL,
`segment_id` varchar(255) NOT NULL,
`target_game_id` int(11) NOT NULL,
`source` varchar(255) NOT NULL,
`category` varchar(255) NOT NULL,
`time` varchar(255) NOT NULL,
`value` bigint(20) NOT NULL DEFAULT '0',
UNIQUE KEY `install_tracking_results_unique` (`game_id`,`segment_id`,`target_game_id`,`category`,`time`,`source`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.00 sec)
mysql> EXPLAIN SELECT `install_tracking_results`.* FROM `install_tracking_results` WHERE `install_tracking_results`.`game_id` IN (1, 2, 3) AND `install_tracking_results`.`target_game_id` = 2 AND `install_tracking_results`.`segment_id` = 'default_segment' AND `install_tracking_results`.`category` = 'clickthru' AND `install_tracking_results`.`source` IN ('test') AND (`install_tracking_results`.`time` BETWEEN 'D-2012-10-10' AND 'D-2012-10-11');
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 1
Current database: VirtualGoods
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> SHOW TABLE STATUS LIKE 'install_tracking_results';
+--------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment |
+--------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
| install_tracking_results | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 15728640 | NULL | 2012-11-20 16:23:26 | NULL | NULL | utf8_general_ci | NULL | | |
+--------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
1 row in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment