【20180329】MySQL优化SQL一则以及思考
mysql> show create table articles \G *************************** 1. row ***************************Table: articles
Create Table: CREATE TABLE `articles` (
`id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`pic_urls` varchar(512) NOT NULL,
`vote_id` int(11) NOT NULL DEFAULT '0',
`topic_id` int(11) NOT NULL DEFAULT '0',
`type` int(11) NOT NULL,
`content` varchar(3000) DEFAULT NULL,
`location` varchar(32) NOT NULL DEFAULT '',
`longitude` varchar(12) NOT NULL,
`latitude` varchar(12) NOT NULL,
`status` int(11) NOT NULL,
`created_at` datetime NOT NULL,
`user_ip` int(11) unsigned NOT NULL DEFAULT '0',
`review` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `topic_id` (`topic_id`),
KEY `user_id` (`user_id`,`status`,`created_at`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
/*!50100 PARTITION BY HASH (id)
PARTITIONS 16 */
页:
[1]