Re: MYSQL issues with query performance

[Wouter Platteeuw]

mysql Ver 14.14 Distrib 5.7.30, for Linux (x86_64) using EditLine wrapper
 
mysql> Show Create Table users;
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create table
|
`profilepicture` text,
`lastlogon` int(11) DEFAULT NULL COMMENT 'timestamp',
`active` varchar(255) DEFAULT NULL,
`admin` enum('0','1') NOT NULL DEFAULT '0',
`deleted` tinyint(1) DEFAULT NULL,
`createdon` int(11) DEFAULT NULL COMMENT 'timestamp',
`acceptsallworkgroups` tinyint(1) DEFAULT '0',
`acceptsinkmrange` tinyint(1) DEFAULT NULL,
`about` text,
`allowratingcomment` tinyint(1) DEFAULT NULL,
`notifications` enum('0','1','2') NOT NULL DEFAULT '2',
`newsletter` enum('0','1') NOT NULL DEFAULT '1',
`landing_page` enum('0','1','2','') NOT NULL DEFAULT '0',
`wrongpassword` int(11) NOT NULL DEFAULT '0',
`skip_1` enum('0','1') NOT NULL DEFAULT '0',
`skip_2` enum('0','1') NOT NULL DEFAULT '0',
`skip_3` enum('0','1') NOT NULL DEFAULT '0',
`alerts` enum('0','1','2') NOT NULL DEFAULT '1',
`typealert` enum('0','1','2') NOT NULL DEFAULT '2',
`versionid_image` int(11) NOT NULL DEFAULT '0',
`premiumaccount` int(11) NOT NULL DEFAULT '0',
`wrong_pw_time` int(11) DEFAULT NULL,
`average_rating` double(2,1) NOT NULL DEFAULT '0.0',
`city` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `users` (`id`,`acceptsallworkgroups`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)