Închis

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

Aptitudini: MySQL, Apache, Administrare baze de date, Web Hosting

Vezi mai multe: 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

Despre angajator:
( 0 recenzii ) Ho Chi Minh City, Vietnam

ID Proiect: #29901443

2 freelanceri licitează în medie 30$ pentru acest proiect

usmansyedid

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 Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(4 recenzii)
2.9
drevan2022

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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(1 părere)
1.2