--
-- Структура таблицы `products`
--

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `vendor` text DEFAULT NULL,
  `manufacturer` text DEFAULT NULL,
  `options` text NOT NULL,
  `price` text NOT NULL,
  `time` text NOT NULL,
  `type` text NOT NULL,
  `img` text NOT NULL,
  `href` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


--
-- Индексы таблицы `cyfronsemi`
--
ALTER TABLE `products` ADD KEY `id` (`id`);

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `vendor` varchar(255) DEFAULT NULL,
  `manufacturer` varchar(255) DEFAULT NULL,
  `options` varchar(255) NOT NULL,
  `price` varchar(32) NOT NULL,
  `time` varchar(32) NOT NULL,
  `type` varchar(255) NOT NULL,
  `img` varchar(255) NOT NULL,
  `href` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


ALTER TABLE `products`
  ADD KEY `id` (`id`),
  ADD KEY `vendor` (`vendor`),
  ADD KEY `manufacturer` (`manufacturer`),
  ADD KEY `type` (`type`);


mysql> SELECT * FROM `products` WHERE `vendor`='PIC12E674P04I' LIMIT 1;
+---------+---------------+--------------+---------+-------+------+------+-----+------+
| id      | vendor        | manufacturer | options | price | time | type | img | href |
+---------+---------------+--------------+---------+-------+------+------+-----+------+
| 2582951 | PIC12E674P04I |              |         |       |      |      |     |      |
+---------+---------------+--------------+---------+-------+------+------+-----+------+
1 row in set (3.07 sec)


mysql> EXPLAIN SELECT * FROM `products` WHERE `vendor`='PIC12E674P04I' LIMIT 1;
+----+-------------+------------+------------+------+---------------+------+---------+------+---------+----------+-------------+
| id | select_type | table      | partitions | type | possible_keys | key  | key_len | ref  | rows    | filtered | Extra       |
+----+-------------+------------+------------+------+---------------+------+---------+------+---------+----------+-------------+
|  1 | SIMPLE      | products   | NULL       | ALL  | vendor        | NULL | NULL    | NULL | 5763259 |    10.00 | Using where |
+----+-------------+------------+------------+------+---------------+------+---------+------+---------+----------+-------------+
1 row in set, 1 warning (0.00 sec)

mysql> SHOW WARNINGS;
+-------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Level | Code | Message                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
+-------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Note  | 1003 | /* select#1 */ select `productsdb`.`products`.`id` AS `id`,`productsdb`.`products`.`vendor` AS `vendor`,`productsdb`.`products`.`manufacturer` AS `manufacturer`,`productsdb`.`products`.`options` AS `options`,`productsdb`.`products`.`price` AS `price`,`productsdb`.`products`.`time` AS `time`,`productsdb`.`products`.`type` AS `type`,`productsdb`.`products`.`img` AS `img`,`productsdb`.`products`.`href` AS `href` from `productsdb`.`products` where (`productsdb`.`products`.`vendor` = 'PIC12E674P04I') limit 1 |
+-------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> analyze table products;
+----------------------------+---------+----------+----------+
| Table                      | Op      | Msg_type | Msg_text |
+----------------------------+---------+----------+----------+
| productsnnodb.products     | analyze | status   | OK       |
+----------------------------+---------+----------+----------+
1 row in set (0.09 sec)


mysql> SELECT * FROM `products` WHERE `vendor`='T140D107K030AS' LIMIT 1;
+---------+----------------+--------------+---------+-------+------+------+-----+------+
| id      | vendor         | manufacturer | options | price | time | type | img | href |
+---------+----------------+--------------+---------+-------+------+------+-----+------+
| 4740952 | T140D107K030AS |              |         |       | 1    |      |     |      |
+---------+----------------+--------------+---------+-------+------+------+-----+------+
1 row in set (6.10 sec)


mysql> EXPLAIN SELECT * FROM `products` WHERE `vendor`='T140D107K030AS' LIMIT 1;
+----+-------------+------------+------------+------+---------------+------+---------+------+---------+----------+-------------+
| id | select_type | table      | partitions | type | possible_keys | key  | key_len | ref  | rows    | filtered | Extra       |
+----+-------------+------------+------------+------+---------------+------+---------+------+---------+----------+-------------+
|  1 | SIMPLE      | products   | NULL       | ALL  | vendor        | NULL | NULL    | NULL | 5763259 |    10.00 | Using where |
+----+-------------+------------+------------+------+---------------+------+---------+------+---------+----------+-------------+
1 row in set, 1 warning (0.00 sec)

cat /etc/mysql/mysql.conf.d/mysqld.cnf 

[mysqld_safe]
log-error=/var/log/mysql.log
socket		= /var/run/mysqld/mysqld.sock
nice		= 0

[mysqld]
collation-server = utf8_general_ci
character-set-server = utf8
local-infile=0
innodb_file_per_table = 1
sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /tmp
lc-messages-dir	= /usr/share/mysql
skip-external-locking

bind-address		= 127.0.0.1

key_buffer_size		= 256M
max_allowed_packet	= 16M
thread_stack		= 192K
thread_cache_size       = 8

myisam-recover-options  = BACKUP
max_connections        = 162

innodb_buffer_pool_size = 3G
innodb_buffer_pool_instances = 3
innodb_flush_method = O_DIRECT

query_cache_type        = 1
query_cache_limit	= 8M
query_cache_size        = 32M

tmp_table_size          = 32M
max_heap_table_size     = 32M
table_open_cache        = 3000

log_error = /var/log/mysql/error.log
slow_query_log=1
slow_query_log_file=/var/log/mysql/mysql-slow.log


expire_logs_days	= 10
max_binlog_size   = 100M
bind-address = 127.0.0.1

innodb_temp_data_file_path = ibtmp1:12M:autoextend:max:5G
long-query-time = 5

mysql> ANALYZE TABLE `products` UPDATE HISTOGRAM ON `vendor`;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE HISTOGRAM ON `vendor`' at line 1


mysql> SELECT * FROM `products` FORCE INDEX (vendor) WHERE `vendor`='T140D107K030AS';
+---------+----------------+--------------+---------+-------+------+------+-----+------+
| id      | vendor         | manufacturer | options | price | time | type | img | href |
+---------+----------------+--------------+---------+-------+------+------+-----+------+
| 4740952 | T140D107K030AS |              |         |       | 1    |      |     |      |
+---------+----------------+--------------+---------+-------+------+------+-----+------+
1 row in set (9.47 sec)

mysql -v
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 965461
Server version: 5.7.31-0ubuntu0.16.04.1-log (Ubuntu)