Как в MySQL через консоль пересоздать индексы

Intel® Xeon® CPU E7-4830 v2 @ 2.20GHz
Intel® Xeon® CPU E7-4830 v2 @ 2.20GHz

Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 2
On-line CPU(s) list: 0,1
Thread(s) per core: 1
Core(s) per socket: 1
Socket(s): 2
NUMA node(s): 1
Vendor ID: GenuineIntel
CPU family: 6
Model: 62
Model name: Intel® Xeon® CPU E7-4830 v2 @ 2.20GHz
Stepping: 7
CPU MHz: 2194.711
BogoMIPS: 4389.42
Hypervisor vendor: VMware
Virtualization type: full
L1d cache: 32K
L1i cache: 32K
L2 cache: 256K
L3 cache: 20480K
NUMA node0 CPU(s): 0,1
Flags: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts mmx fxsr sse sse2 ss sysca

total used free shared buff/cache available
Mem: 991 415 79 13 496 400
Swap: 2047 246 1801
Total: 3039 662 1880

Filesystem Size Used Avail Use% Mounted on
/dev/mapper/centos-root 38G 19G 19G 51% /
devtmpfs 485M 0 485M 0% /dev
tmpfs 496M 0 496M 0% /dev/shm
tmpfs 496M 51M 446M 11% /run
tmpfs 496M 0 496M 0% /sys/fs/cgroup
/dev/sda1 497M 262M 236M 53% /boot
tmpfs 100M 0 100M 0% /run/user/0

3291 mysql 20 0 1777876 300176 4104 S 4.3 29.6 770:41.10 mysqld
1335 ***** 20 0 492752 15636 4156 S 1.7 1.5 0:01.97 php-fpm
1059 nginx 20 0 69840 3620 1636 S 0.7 0.4 29:07.94 nginx
1060 nginx 20 0 69992 3640 1720 S 0.7 0.4 28:06.66 nginx
9 root 20 0 0 0 0 R 0.3 0.0 11:46.54 rcu_sched
1356 root 20 0 161984 2228 1576 R 0.3 0.2 0:00.09 top
1 root 20 0 125524 2412 1396 S 0.0 0.2 0:50.11 systemd
2 root 20 0 0 0 0 S 0.0 0.0 0:00.12 kthreadd
3 root 20 0 0 0 0 S 0.0 0.0 0:16.66 ksoftirqd/0
5 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/0:0H
7 root rt 0 0 0 0 S 0.0 0.0 0:02.94 migration/0
8 root 20 0 0 0 0 S 0.0 0.0 0:00.00 rcu_bh
10 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 lru-add-drain
11 root rt 0 0 0 0 S 0.0 0.0 0:01.93 watchdog/0
12 root rt 0 0 0 0 S 0.0 0.0 0:02.75 watchdog/1
13 root rt 0 0 0 0 S 0.0 0.0 0:02.94 migration/1
14 root 20 0 0 0 0 S 0.0 0.0 0:12.22 ksoftirqd/1
16 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/1:0H
18 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kdevtmpfs
19 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 netns
20 root 20 0 0 0 0 S 0.0 0.0 0:00.27 khungtaskd
21 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 writeback
22 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kintegrityd
23 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
24 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
25 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
26 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kblockd
27 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 md
28 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 edac-poller
29 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 watchdogd
36 root 20 0 0 0 0 S 0.0 0.0 2:51.93 kswapd0
37 root 25 5 0 0 0 S 0.0 0.0 0:00.00 ksmd
38 root 39 19 0 0 0 S 0.0 0.0 0:01.43 khugepaged
39 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 crypto
47 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kthrotld
49 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kmpath_rdacd
50 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kaluad
51 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kpsmoused
53 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ipv6_addrconf
66 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 deferwq
98 root 20 0 0 0 0 S 0.0 0.0 0:02.73 kauditd
277 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0
278 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 scsi_tmf_0
279 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ata_sff
280 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 vmw_pvscsi_wq_0
289 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_1
291 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 scsi_tmf_1
292 root 20 0 0 0 0 S 0.0 0.0 0:00.01 scsi_eh_2
293 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 scsi_tmf_2
315 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ttm_swap
316 root -51 0 0 0 0 S 0.0 0.0 0:00.00 irq/16-vmwgfx
369 root 0 -20 0 0 0 S 0.0 0.0 0:05.95 kworker/1:1H