Help me to fix high CPU MySQL
$10-30 USD
Paid on delivery
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
Project ID: #29901443
About the project
2 freelancers are bidding on average $30 for this job
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 More