Help me to fix high CPU MySQL

I use XAMPP to build my web server to run my website.

I receive a error all time:

"[login to view URL]

warning : Table is marked as crashed and last repair failed

warning : Size of indexfile is: 54710 Expected: 24576

error : Wrong base information on indexpage at page: 2

error : Corrupt"

If I backup and reinstall database, CPU will very low, maybe about 1 2%. (even though there are a thousand select queries)

When I got [login to view URL] error, CPU will high 60 80%. (even though only 50 select queries)

I need expert help me to fix this error completely, i don't want it to happen in the future. I want to know the cause, I don't want to have to reinstall mysql every week.

My computer:

+ Intel (R) Xeon (R) CPU E5-2678 v3 @2.50 GHz

+ 24 Core, 48 Logical processors

+ Ram: 64 GB

DISK ALLWAY 1%

//SLOW QUERY

# User@Host: gofamedia[gofamedia] @ localhost [::1]

# Thread_id: 35613 Schema: gofa_media QC_hit: No

# Query_time: 6.124151 Lock_time: 0.000056 Rows_sent: 97 Rows_examined: 134587

# Rows_affected: 0 Bytes_sent: 33494

SET timestamp=1618602354;

SELECT * FROM `logs_join_group`

WHERE

ip_join = '[login to view URL]' and status_join='True' and date_join like '%2021-04-17%';

//[login to view URL] file

# Comment the following if you are using InnoDB tables

#skip-innodb

innodb_data_home_dir="E:/xampp/mysql/data"

innodb_data_file_path=ibdata1:10M:autoextend

innodb_log_group_home_dir="E:/xampp/mysql/data"

#innodb_log_arch_dir = "E:/xampp/mysql/data"

## You can set .._buffer_pool_size up to 50 - 80 %

## of RAM but beware of setting memory usage too high

innodb_buffer_pool_size=15000M

## Set .._log_file_size to 25 % of buffer pool size

innodb_log_file_size=3750M

innodb_log_buffer_size=8M

innodb_flush_log_at_trx_commit=1

innodb_lock_wait_timeout=120

//Logs from mysqltuner

Info Up for: 3h 18m 32s (921K q [77.000 qps], 302K conn, TX: 791M, RX: 150M)

Info Reads / Writes: 82% / 18%

Info Total buffers: 24.8G global + 1.8M per thread (2000 max threads)

Pass Maximum possible memory usage: 28.3G (50% of installed RAM)

Pass Slow queries: 1% (5K/921K)

Pass Highest usage of available connections: 24% (468/2000)

Fail Cannot calculate MyISAM index size - please run this program as an Administrator

Pass Sorts requiring temporary tables: 0% (0 temp sorts / 753 sorts)

Fail Temporary tables created on disk: 49% (55K on disk / 114K total)

Pass Thread cache hit rate: 99% (540 created / 302K connections)

Pass Table cache hit rate: 99% (740 open / 747 opened)

Pass Open file limit used: 0% (56/36K)

Pass Table locks acquired immediately: 100% (408 immediate / 408 locks)

Pass InnoDB data size / buffer pool: 1.1G/15.0G

Recommendation Run OPTIMIZE TABLE to defragment tables for better performance

Recommendation MySQL started within last 24 hours - recommendations may be inaccurate

Recommendation When making adjustments, make tmp_table_size/max_heap_table_size equal

Recommendation Reduce your SELECT DISTINCT queries without LIMIT clauses

Recommendation tmp_table_size (> 16M)

Recommendation max_heap_table_size (> 16M)

Info Scan Completed at Saturday, 17 April 2021 1:08:03 am

MySQL Apache Database Administration Web Hosting

Project ID: #29901443

About the project