High CPU - mysqltuner assistance (wordpress) The Next CEO of Stack OverflowMySQL keeps crashing OS server.. Please help adjust my.ini!How do I allow mysqld to use more than 24.9% of my cpu?my battle against web-server monitoring - slow serverImprove server performance by configuring MySQLMySQL becomes unresponsive a few times per hourCentos MySQL optimization 4gb ramMySQL Tuning — High Memory Usagemysqltuner script to optimize my mysql databaseJoins performed without indexes: 5568MySQL my.cnf config for dedicated server
Is dried pee considered dirt?
Why is information "lost" when it got into a black hole?
Easy to read palindrome checker
Traveling with my 5 year old daughter (as the father) without the mother from Germany to Mexico
Is there such a thing as a proper verb, like a proper noun?
Why is the US ranked as #45 in Press Freedom ratings, despite its extremely permissive free speech laws?
Spaces in which all closed sets are regular closed
Is French Guiana a (hard) EU border?
Inexact numbers as keys in Association?
Physiological effects of huge anime eyes
Scary film where a woman has vaginal teeth
Does destroying a Lich's phylactery destroy the soul within it?
Small nick on power cord from an electric alarm clock, and copper wiring exposed but intact
IC has pull-down resistors on SMBus lines?
Redefining symbol midway through a document
What steps are necessary to read a Modern SSD in Medieval Europe?
Does the Idaho Potato Commission associate potato skins with healthy eating?
Expressing the idea of having a very busy time
Is it OK to decorate a log book cover?
Getting Stale Gas Out of a Gas Tank w/out Dropping the Tank
Can you teleport closer to a creature you are Frightened of?
Aggressive Under-Indexing and no data for missing index
Lucky Feat: How can "more than one creature spend a luck point to influence the outcome of a roll"?
It is correct to match light sources with the same color temperature?
High CPU - mysqltuner assistance (wordpress)
The Next CEO of Stack OverflowMySQL keeps crashing OS server.. Please help adjust my.ini!How do I allow mysqld to use more than 24.9% of my cpu?my battle against web-server monitoring - slow serverImprove server performance by configuring MySQLMySQL becomes unresponsive a few times per hourCentos MySQL optimization 4gb ramMySQL Tuning — High Memory Usagemysqltuner script to optimize my mysql databaseJoins performed without indexes: 5568MySQL my.cnf config for dedicated server
I just migrated wordpress blog to new server. It has some 120K posts.
The problem is It get struck, hang or even freeze during mysql operation.
A single wordpress(without any plugin) create post operation consumes 60-80% of CPU. And when perform 3-5 database operation it goes frozen.
And there isn't any log for slow query.
System: Ubuntu 18.04 with 16GB RAM, 8 Core CPU, 120GB Disk and MySQL version 5.7.25
Here is mysqltuner and other reports
- Mysqltuner:- https://pastebin.com/ZNYieJj8
- htop:- https://pastebin.com/43f4b3fK
- top:- https://pastebin.com/rTh1XvUt
- INNODB STATUS:- https://pastebin.com/nGrZjHAg
- GLOBAL VARIABLES: https://pastebin.com/K2fgKwEv
and current mysql.cnf
[mysqld]
# Skip reverse DNS lookup of clients
skip-name-resolve
default-storage-engine=InnoDB
max_allowed_packet=500M
max_connections = 256
interactive_timeout=7200
wait_timeout=7200
innodb_file_per_table=1
innodb_buffer_pool_size = 8G
innodb_buffer_pool_instances = 4
innodb_log_file_size = 1G
innodb_flush_log_at_trx_commit = 1
innodb_flush_method = O_DIRECT
innodb_open_files=5000
innodb_io_capacity=2000
innodb_io_capacity_max=4000
innodb_old_blocks_time=2000
open_files_limit=50000
query_cache_type = 1
query_cache_min_res_unit = 1M
query_cache_limit = 1M
query_cache_size = 50M
tmp_table_size= 256M
max_heap_table_size= 256M
#key_buffer_size = 128M
thread_stack = 128K
thread_cache_size = 32
slow-query-log = 1
slow-query-log-file = /var/lib/mysql/mysql-slow.log
long_query_time = 1
Edit:
Initial mysql.cnf variables I pasted above had some incorrect/changed values comparing those of when generating mysqltuner report. corrected thank you @EchoMike444
mysql wordpress cpu-usage
asked yesterday
TELATELA
11
New contributor
TELA is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
|
show 1 more comment
I just migrated wordpress blog to new server. It has some 120K posts.
The problem is It get struck, hang or even freeze during mysql operation.
A single wordpress(without any plugin) create post operation consumes 60-80% of CPU. And when perform 3-5 database operation it goes frozen.
And there isn't any log for slow query.
System: Ubuntu 18.04 with 16GB RAM, 8 Core CPU, 120GB Disk and MySQL version 5.7.25
Here is mysqltuner and other reports
- Mysqltuner:- https://pastebin.com/ZNYieJj8
- htop:- https://pastebin.com/43f4b3fK
- top:- https://pastebin.com/rTh1XvUt
- INNODB STATUS:- https://pastebin.com/nGrZjHAg
- GLOBAL VARIABLES: https://pastebin.com/K2fgKwEv
and current mysql.cnf
[mysqld]
# Skip reverse DNS lookup of clients
skip-name-resolve
default-storage-engine=InnoDB
max_allowed_packet=500M
max_connections = 256
interactive_timeout=7200
wait_timeout=7200
innodb_file_per_table=1
innodb_buffer_pool_size = 8G
innodb_buffer_pool_instances = 4
innodb_log_file_size = 1G
innodb_flush_log_at_trx_commit = 1
innodb_flush_method = O_DIRECT
innodb_open_files=5000
innodb_io_capacity=2000
innodb_io_capacity_max=4000
innodb_old_blocks_time=2000
open_files_limit=50000
query_cache_type = 1
query_cache_min_res_unit = 1M
query_cache_limit = 1M
query_cache_size = 50M
tmp_table_size= 256M
max_heap_table_size= 256M
#key_buffer_size = 128M
thread_stack = 128K
thread_cache_size = 32
slow-query-log = 1
slow-query-log-file = /var/lib/mysql/mysql-slow.log
long_query_time = 1
Edit:
Initial mysql.cnf variables I pasted above had some incorrect/changed values comparing those of when generating mysqltuner report. corrected thank you @EchoMike444
mysql wordpress cpu-usage
asked yesterday
TELATELA
11
New contributor
TELA is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
your currentmysql,cnfdoes not match what we see in MysqlTuner / Htop . innodb_buffer_pool_size in you files is 4G , it seem to be 8G
– EchoMike444
yesterday
your database size seem to be small 2G , can you confirm ?
– EchoMike444
yesterday
how did you migrate the database ?
– EchoMike444
yesterday
mysql.cnf variables I pasted above had some incorrect/changed values comparing those of when generating mysqltuner report. corrected. Sorry and thank you @EchoMike444
– TELA
yesterday
Actually I did not migrate the database as a whole and it was not possible at old server due to limited access. I just created an API and inserted using wp_insert_post() at new wp installation.
– TELA
yesterday
|
show 1 more comment
I just migrated wordpress blog to new server. It has some 120K posts.
The problem is It get struck, hang or even freeze during mysql operation.
A single wordpress(without any plugin) create post operation consumes 60-80% of CPU. And when perform 3-5 database operation it goes frozen.
And there isn't any log for slow query.
System: Ubuntu 18.04 with 16GB RAM, 8 Core CPU, 120GB Disk and MySQL version 5.7.25
Here is mysqltuner and other reports
- Mysqltuner:- https://pastebin.com/ZNYieJj8
- htop:- https://pastebin.com/43f4b3fK
- top:- https://pastebin.com/rTh1XvUt
- INNODB STATUS:- https://pastebin.com/nGrZjHAg
- GLOBAL VARIABLES: https://pastebin.com/K2fgKwEv
and current mysql.cnf
[mysqld]
# Skip reverse DNS lookup of clients
skip-name-resolve
default-storage-engine=InnoDB
max_allowed_packet=500M
max_connections = 256
interactive_timeout=7200
wait_timeout=7200
innodb_file_per_table=1
innodb_buffer_pool_size = 8G
innodb_buffer_pool_instances = 4
innodb_log_file_size = 1G
innodb_flush_log_at_trx_commit = 1
innodb_flush_method = O_DIRECT
innodb_open_files=5000
innodb_io_capacity=2000
innodb_io_capacity_max=4000
innodb_old_blocks_time=2000
open_files_limit=50000
query_cache_type = 1
query_cache_min_res_unit = 1M
query_cache_limit = 1M
query_cache_size = 50M
tmp_table_size= 256M
max_heap_table_size= 256M
#key_buffer_size = 128M
thread_stack = 128K
thread_cache_size = 32
slow-query-log = 1
slow-query-log-file = /var/lib/mysql/mysql-slow.log
long_query_time = 1
Edit:
Initial mysql.cnf variables I pasted above had some incorrect/changed values comparing those of when generating mysqltuner report. corrected thank you @EchoMike444
mysql wordpress cpu-usage
asked yesterday
TELATELA
11
New contributor
TELA is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I just migrated wordpress blog to new server. It has some 120K posts.
The problem is It get struck, hang or even freeze during mysql operation.
A single wordpress(without any plugin) create post operation consumes 60-80% of CPU. And when perform 3-5 database operation it goes frozen.
And there isn't any log for slow query.
System: Ubuntu 18.04 with 16GB RAM, 8 Core CPU, 120GB Disk and MySQL version 5.7.25
Here is mysqltuner and other reports
- Mysqltuner:- https://pastebin.com/ZNYieJj8
- htop:- https://pastebin.com/43f4b3fK
- top:- https://pastebin.com/rTh1XvUt
- INNODB STATUS:- https://pastebin.com/nGrZjHAg
- GLOBAL VARIABLES: https://pastebin.com/K2fgKwEv
and current mysql.cnf
[mysqld]
# Skip reverse DNS lookup of clients
skip-name-resolve
default-storage-engine=InnoDB
max_allowed_packet=500M
max_connections = 256
interactive_timeout=7200
wait_timeout=7200
innodb_file_per_table=1
innodb_buffer_pool_size = 8G
innodb_buffer_pool_instances = 4
innodb_log_file_size = 1G
innodb_flush_log_at_trx_commit = 1
innodb_flush_method = O_DIRECT
innodb_open_files=5000
innodb_io_capacity=2000
innodb_io_capacity_max=4000
innodb_old_blocks_time=2000
open_files_limit=50000
query_cache_type = 1
query_cache_min_res_unit = 1M
query_cache_limit = 1M
query_cache_size = 50M
tmp_table_size= 256M
max_heap_table_size= 256M
#key_buffer_size = 128M
thread_stack = 128K
thread_cache_size = 32
slow-query-log = 1
slow-query-log-file = /var/lib/mysql/mysql-slow.log
long_query_time = 1
Edit:
Initial mysql.cnf variables I pasted above had some incorrect/changed values comparing those of when generating mysqltuner report. corrected thank you @EchoMike444
mysql wordpress cpu-usage
mysql wordpress cpu-usage
asked yesterday
TELATELA
11
New contributor
TELA is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
TELATELA
11
New contributor
TELA is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited yesterday
TELA
asked yesterday
TELATELA
11
New contributor
TELA is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
TELATELA
11
asked yesterday
TELATELA
11
11
New contributor
TELA is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
TELA is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
TELA is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
your currentmysql,cnfdoes not match what we see in MysqlTuner / Htop . innodb_buffer_pool_size in you files is 4G , it seem to be 8G
– EchoMike444
yesterday
your database size seem to be small 2G , can you confirm ?
– EchoMike444
yesterday
how did you migrate the database ?
– EchoMike444
yesterday
mysql.cnf variables I pasted above had some incorrect/changed values comparing those of when generating mysqltuner report. corrected. Sorry and thank you @EchoMike444
– TELA
yesterday
Actually I did not migrate the database as a whole and it was not possible at old server due to limited access. I just created an API and inserted using wp_insert_post() at new wp installation.
– TELA
yesterday
|
show 1 more comment
your currentmysql,cnfdoes not match what we see in MysqlTuner / Htop . innodb_buffer_pool_size in you files is 4G , it seem to be 8G
– EchoMike444
yesterday
your database size seem to be small 2G , can you confirm ?
– EchoMike444
yesterday
how did you migrate the database ?
– EchoMike444
yesterday
mysql.cnf variables I pasted above had some incorrect/changed values comparing those of when generating mysqltuner report. corrected. Sorry and thank you @EchoMike444
– TELA
yesterday
Actually I did not migrate the database as a whole and it was not possible at old server due to limited access. I just created an API and inserted using wp_insert_post() at new wp installation.
– TELA
yesterday
your current
mysql,cnfdoes not match what we see in MysqlTuner / Htop . innodb_buffer_pool_size in you files is 4G , it seem to be 8G– EchoMike444
yesterday
your current
mysql,cnfdoes not match what we see in MysqlTuner / Htop . innodb_buffer_pool_size in you files is 4G , it seem to be 8G– EchoMike444
yesterday
your database size seem to be small 2G , can you confirm ?
– EchoMike444
yesterday
your database size seem to be small 2G , can you confirm ?
– EchoMike444
yesterday
how did you migrate the database ?
– EchoMike444
yesterday
how did you migrate the database ?
– EchoMike444
yesterday
mysql.cnf variables I pasted above had some incorrect/changed values comparing those of when generating mysqltuner report. corrected. Sorry and thank you @EchoMike444
– TELA
yesterday
mysql.cnf variables I pasted above had some incorrect/changed values comparing those of when generating mysqltuner report. corrected. Sorry and thank you @EchoMike444
– TELA
yesterday
Actually I did not migrate the database as a whole and it was not possible at old server due to limited access. I just created an API and inserted using wp_insert_post() at new wp installation.
– TELA
yesterday
Actually I did not migrate the database as a whole and it was not possible at old server due to limited access. I just created an API and inserted using wp_insert_post() at new wp installation.
– TELA
yesterday
|
show 1 more comment
0
active
oldest
votes
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
TELA is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f960737%2fhigh-cpu-mysqltuner-assistance-wordpress%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
TELA is a new contributor. Be nice, and check out our Code of Conduct.
TELA is a new contributor. Be nice, and check out our Code of Conduct.
TELA is a new contributor. Be nice, and check out our Code of Conduct.
TELA is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Server Fault!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f960737%2fhigh-cpu-mysqltuner-assistance-wordpress%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
your current
mysql,cnfdoes not match what we see in MysqlTuner / Htop . innodb_buffer_pool_size in you files is 4G , it seem to be 8G– EchoMike444
yesterday
your database size seem to be small 2G , can you confirm ?
– EchoMike444
yesterday
how did you migrate the database ?
– EchoMike444
yesterday
mysql.cnf variables I pasted above had some incorrect/changed values comparing those of when generating mysqltuner report. corrected. Sorry and thank you @EchoMike444
– TELA
yesterday
Actually I did not migrate the database as a whole and it was not possible at old server due to limited access. I just created an API and inserted using wp_insert_post() at new wp installation.
– TELA
yesterday