2.2.3. проверяем структуру innodb/myisam файлов, для этого используем штатные средства диагностики или вспомогательные утилиты, например "Percona Data Recovery Tool for InnoDB can help recover corrupted or deleted InnoDB tables. https://launchpad.net/percona-data-recovery-tool-f..." если проблемы - пытаемся чинить.
Простой старый способ решения некоторых проблем - это dump базы в sql файл , и импорт заново в базу. старую можно переименовать.
# Дамп таблицы game
# ------------------------------------------------------------
# Error: Lost connection to MySQL server during query<blockquote></blockquote>root@95916:~# cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 6
model name : QEMU Virtual CPU version 2.4.0
stepping : 3
microcode : 0x1
cpu MHz : 2399.996
cache size : 4096 KB
physical id : 0
siblings : 1
core id : 0
cpu cores : 1
apicid : 0
initial apicid : 0
fpu : yes
fpu_exception : yes
cpuid level : 13
wp : yes
flags : fpu de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pse36 clflush mmx fxsr sse sse2 syscall nx lm rep_good nopl eagerfpu pni vmx cx16 x2apic popcnt hypervisor lahf_lm abm kaiser tpr_shadow vnmi flexpriority ept vpid
bugs : cpu_meltdown spectre_v1 spectre_v2 spec_store_bypass l1tf
bogomips : 4799.99
clflush size : 64
cache_alignment : 64
address sizes : 40 bits physical, 48 bits virtual
power management:
processor : 1
vendor_id : GenuineIntel
cpu family : 6
model : 6
model name : QEMU Virtual CPU version 2.4.0
stepping : 3
microcode : 0x1
cpu MHz : 2399.996
cache size : 4096 KB
physical id : 1
siblings : 1
core id : 0
cpu cores : 1
apicid : 1
initial apicid : 1
fpu : yes
fpu_exception : yes
cpuid level : 13
wp : yes
flags : fpu de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pse36 clflush mmx fxsr sse sse2 syscall nx lm rep_good nopl eagerfpu pni vmx cx16 x2apic popcnt hypervisor lahf_lm abm kaiser tpr_shadow vnmi flexpriority ept vpid
bugs : cpu_meltdown spectre_v1 spectre_v2 spec_store_bypass l1tf
bogomips : 4799.99
clflush size : 64
cache_alignment : 64
address sizes : 40 bits physical, 48 bits virtual
power management:root@95916:~# cat /proc/meminfo
MemTotal: 1015772 kB
MemFree: 94196 kB
MemAvailable: 534772 kB
Buffers: 92688 kB
Cached: 461700 kB
SwapCached: 48 kB
Active: 356760 kB
Inactive: 393916 kB
Active(anon): 184296 kB
Inactive(anon): 68784 kB
Active(file): 172464 kB
Inactive(file): 325132 kB
Unevictable: 0 kB
Mlocked: 0 kB
SwapTotal: 524284 kB
SwapFree: 521980 kB
Dirty: 0 kB
Writeback: 0 kB
AnonPages: 196292 kB
Mapped: 98744 kB
Shmem: 56780 kB
Slab: 142296 kB
SReclaimable: 126940 kB
SUnreclaim: 15356 kB
KernelStack: 2400 kB
PageTables: 11864 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
WritebackTmp: 0 kB
CommitLimit: 1032168 kB
Committed_AS: 1107480 kB
VmallocTotal: 34359738367 kB
VmallocUsed: 0 kB
VmallocChunk: 0 kB
HardwareCorrupted: 0 kB
AnonHugePages: 26624 kB
CmaTotal: 0 kB
CmaFree: 0 kB
HugePages_Total: 0
HugePages_Free: 0
HugePages_Rsvd: 0
HugePages_Surp: 0
Hugepagesize: 2048 kB
DirectMap4k: 57216 kB
DirectMap2M: 991232 kBroot@95916:~# cat /proc/partitions
major minor #blocks name
253 0 31457280 vda
253 1 31456256 vda1