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



# 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`


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





#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


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





//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

Taidot: MySQL, Apache, Tietokannan hallinto, Web hosting

Näytä lisää: build game server website, can use newcs build cccam server, build web server oscam, build web server, build web server with authentication, visual studio use local iis web server, mysql high cpu wordpress, mysql high cpu usage windows, wp mysql high cpu usage, mysql high cpu usage centos, how to use xampp to host a website, how to fix high cpu usage when playing games, how to build web server python, how to fix high cpu usage, the web application project is configured to use iis the web server could not be found, remote php interpreter is configured please select local php interpreter to use built in web server, high cpu mysql aws, how to fix high cpu usage chromebook, fix high cpu load in wordpress, troubleshooting high cpu mysql

Tietoa työnantajasta:
( 0 arvostelua ) Ho Chi Minh City, Vietnam

Projektin tunnus: #29901443

2 freelanceria on tarjonnut keskimäärin $30 tähän työhön


Hi, I can fix the SQL issue on time and within your budget, have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I am a full-stack web developer and graphics d Lisää

$30 USD 1 päivässä
(4 arvostelua)

Hi, Thank you for your job posting and providing me a good opportunity to work with you. I am a full stack developer who have lots of experiences in web developing. I can help you if you install anydesk or teamviewer Lisää

$30 USD 7 päivässä
(1 arvostelu)