Magento 2 MySQL server has gone awayIndex error after upgrade to EE 1.14.2.0: table catalog_product_entity_tmp_indexer doesn't existMagento Installer - File Permission Check FailMagento 2 SQLSTATE[42S22]: while create product?Magento installation on live server is throwing errorMagento 2.2 : Cannot Add Subcategoryerror on magento 2 after update php 5 to 7, Warning: require(/var/www/html/vendor/magento/framework/registration.php):?Magento Setup on AWS server getting ErrorPDOException: SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'Magento 2, Unable to save products (Catalog rule indexing failed. See details in exception log.)Getting error while adding category Magento2
Why is the President allowed to veto a cancellation of emergency powers?
Brexit - No Deal Rejection
combinatorics floor summation
Why does a Star of David appear at a rally with Francisco Franco?
My adviser wants to be the first author
What is the Japanese sound word for the clinking of money?
Did Ender ever learn that he killed Stilson and/or Bonzo?
Most cost effective thermostat setting: consistent temperature vs. lowest temperature possible
Meme-controlled people
Are relativity and doppler effect related?
What options are left, if Britain cannot decide?
Why do tuner card drivers fail to build after kernel update to 4.4.0-143-generic?
How are passwords stolen from companies if they only store hashes?
PTIJ: Who should I vote for? (21st Knesset Edition)
Examples of transfinite towers
Instead of a Universal Basic Income program, why not implement a "Universal Basic Needs" program?
Are Roman Catholic priests ever addressed as pastor
Why does energy conservation give me the wrong answer in this inelastic collision problem?
The German vowel “a” changes to the English “i”
How to explain that I do not want to visit a country due to personal safety concern?
Is it insecure to send a password in a `curl` command?
Does this sum go infinity?
Happy pi day, everyone!
ERC721: How to get the owned tokens of an address
Magento 2 MySQL server has gone away
Index error after upgrade to EE 1.14.2.0: table catalog_product_entity_tmp_indexer doesn't existMagento Installer - File Permission Check FailMagento 2 SQLSTATE[42S22]: while create product?Magento installation on live server is throwing errorMagento 2.2 : Cannot Add Subcategoryerror on magento 2 after update php 5 to 7, Warning: require(/var/www/html/vendor/magento/framework/registration.php):?Magento Setup on AWS server getting ErrorPDOException: SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'Magento 2, Unable to save products (Catalog rule indexing failed. See details in exception log.)Getting error while adding category Magento2
I managed to migrate magento 1 to new magento 2.2.5
When I reindex for the first time I get in indexer
Category Products
[2019-02-07 21:58:57] main.CRITICAL: Warning: PDOStatement::execute(): MySQL server has gone away in /var/www/html/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228 "exception":"[object] (Exception(code: 0): Warning: PDOStatement::execute(): MySQL server has gone away in /var/www/html/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228 at /var/www/html/vendor/magento/framework/App/ErrorHandler.php:61)" []
mysql.conf settings are:
[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = localhost
#
# * Fine Tuning
#
key_buffer_size = 512M
max_allowed_packet = 1024M
thread_stack = 192K
thread_cache_size = 256
connect_timeout=320 # default 10
table_open_cache = 4096
table_definition_cache = 4096
sort_buffer_size = 16M
max_heap_table_size = 512M
tmp_table_size = 512M
interactive_timeout = 3600
max_connections = 400
max_connect_errors = 1000000
skip_name_resolve
#skip_secure_auth
wait_timeout = 28800
innodb_buffer_pool_size = 2G
myisam_sort_buffer_size = 128M
innodb_log_file_size = 256M
innodb_thread_concurrency = 18
innodb_flush_log_at_trx_commit = 2
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover-options = BACKUP
#max_connections = 100
#table_open_cache = 64
#thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 64M
query_cache_type = 1
Tried to increase the limits in mysql with no luck.
Any suggestions please?
magento2 database reindex
asked Feb 8 at 7:58
G. G.G. G.
607
|
show 5 more comments
I managed to migrate magento 1 to new magento 2.2.5
When I reindex for the first time I get in indexer
Category Products
[2019-02-07 21:58:57] main.CRITICAL: Warning: PDOStatement::execute(): MySQL server has gone away in /var/www/html/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228 "exception":"[object] (Exception(code: 0): Warning: PDOStatement::execute(): MySQL server has gone away in /var/www/html/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228 at /var/www/html/vendor/magento/framework/App/ErrorHandler.php:61)" []
mysql.conf settings are:
[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = localhost
#
# * Fine Tuning
#
key_buffer_size = 512M
max_allowed_packet = 1024M
thread_stack = 192K
thread_cache_size = 256
connect_timeout=320 # default 10
table_open_cache = 4096
table_definition_cache = 4096
sort_buffer_size = 16M
max_heap_table_size = 512M
tmp_table_size = 512M
interactive_timeout = 3600
max_connections = 400
max_connect_errors = 1000000
skip_name_resolve
#skip_secure_auth
wait_timeout = 28800
innodb_buffer_pool_size = 2G
myisam_sort_buffer_size = 128M
innodb_log_file_size = 256M
innodb_thread_concurrency = 18
innodb_flush_log_at_trx_commit = 2
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover-options = BACKUP
#max_connections = 100
#table_open_cache = 64
#thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 64M
query_cache_type = 1
Tried to increase the limits in mysql with no luck.
Any suggestions please?
magento2 database reindex
asked Feb 8 at 7:58
G. G.G. G.
607
what are your MySQL configuration parameters for wait_timeout, max_allowed_packet, tmp_table_size and max_heap_table_size?
– HelgeB
Feb 8 at 8:23
HelgeB I edited the post with my settings
– G. G.
Feb 8 at 8:28
1
Additional information request. Post on pastebin.com and share the links. RAM size of your MySQL Host server Text results of: B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME C) SHOW GLOBAL VARIABLES; D) SHOW FULL PROCESSLIST; E) complete MySQLTuner report AND Optional very helpful information, if available includes - htop OR top OR mytop for most active apps, ulimit -a for a linux/unix list of limits, iostat -xm 5 3 for IOPS by device and core/cpu count, df -h for a linux/unix free space list by device, for server tuning analysis.
– Wilson Hauck
Feb 28 at 1:16
1
Glad you are back together. Providing the information requested yesterday will allow meaningful suggestions to improve your system performance. Why are are you allowing hacker/cracker 1 million attempts to guess a password with the max_connect_errors at 1 million?
– Wilson Hauck
Feb 28 at 21:30
1
@G.G. With secondary review of your config, it looks like you accidentally have innodb_log_buffer_size much larger than innodb_log_file_size. The buffer should always be smaller than the log_file_size. Sorry I missed this earlier. Still willing to help with tuning, if SHOW GLOBAL STATUS; and SHOW GLOBAL VARIABLES; could be posted, even for DEV or PROD instance.
– Wilson Hauck
1 hour ago
|
show 5 more comments
I managed to migrate magento 1 to new magento 2.2.5
When I reindex for the first time I get in indexer
Category Products
[2019-02-07 21:58:57] main.CRITICAL: Warning: PDOStatement::execute(): MySQL server has gone away in /var/www/html/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228 "exception":"[object] (Exception(code: 0): Warning: PDOStatement::execute(): MySQL server has gone away in /var/www/html/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228 at /var/www/html/vendor/magento/framework/App/ErrorHandler.php:61)" []
mysql.conf settings are:
[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = localhost
#
# * Fine Tuning
#
key_buffer_size = 512M
max_allowed_packet = 1024M
thread_stack = 192K
thread_cache_size = 256
connect_timeout=320 # default 10
table_open_cache = 4096
table_definition_cache = 4096
sort_buffer_size = 16M
max_heap_table_size = 512M
tmp_table_size = 512M
interactive_timeout = 3600
max_connections = 400
max_connect_errors = 1000000
skip_name_resolve
#skip_secure_auth
wait_timeout = 28800
innodb_buffer_pool_size = 2G
myisam_sort_buffer_size = 128M
innodb_log_file_size = 256M
innodb_thread_concurrency = 18
innodb_flush_log_at_trx_commit = 2
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover-options = BACKUP
#max_connections = 100
#table_open_cache = 64
#thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 64M
query_cache_type = 1
Tried to increase the limits in mysql with no luck.
Any suggestions please?
magento2 database reindex
asked Feb 8 at 7:58
G. G.G. G.
607
I managed to migrate magento 1 to new magento 2.2.5
When I reindex for the first time I get in indexer
Category Products
[2019-02-07 21:58:57] main.CRITICAL: Warning: PDOStatement::execute(): MySQL server has gone away in /var/www/html/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228 "exception":"[object] (Exception(code: 0): Warning: PDOStatement::execute(): MySQL server has gone away in /var/www/html/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228 at /var/www/html/vendor/magento/framework/App/ErrorHandler.php:61)" []
mysql.conf settings are:
[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = localhost
#
# * Fine Tuning
#
key_buffer_size = 512M
max_allowed_packet = 1024M
thread_stack = 192K
thread_cache_size = 256
connect_timeout=320 # default 10
table_open_cache = 4096
table_definition_cache = 4096
sort_buffer_size = 16M
max_heap_table_size = 512M
tmp_table_size = 512M
interactive_timeout = 3600
max_connections = 400
max_connect_errors = 1000000
skip_name_resolve
#skip_secure_auth
wait_timeout = 28800
innodb_buffer_pool_size = 2G
myisam_sort_buffer_size = 128M
innodb_log_file_size = 256M
innodb_thread_concurrency = 18
innodb_flush_log_at_trx_commit = 2
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover-options = BACKUP
#max_connections = 100
#table_open_cache = 64
#thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 64M
query_cache_type = 1
Tried to increase the limits in mysql with no luck.
Any suggestions please?
magento2 database reindex
magento2 database reindex
asked Feb 8 at 7:58
G. G.G. G.
607
asked Feb 8 at 7:58
G. G.G. G.
607
edited Feb 8 at 8:28
G. G.
asked Feb 8 at 7:58
G. G.G. G.
607
asked Feb 8 at 7:58
G. G.G. G.
607
asked Feb 8 at 7:58
G. G.G. G.
607
607
what are your MySQL configuration parameters for wait_timeout, max_allowed_packet, tmp_table_size and max_heap_table_size?
– HelgeB
Feb 8 at 8:23
HelgeB I edited the post with my settings
– G. G.
Feb 8 at 8:28
1
Additional information request. Post on pastebin.com and share the links. RAM size of your MySQL Host server Text results of: B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME C) SHOW GLOBAL VARIABLES; D) SHOW FULL PROCESSLIST; E) complete MySQLTuner report AND Optional very helpful information, if available includes - htop OR top OR mytop for most active apps, ulimit -a for a linux/unix list of limits, iostat -xm 5 3 for IOPS by device and core/cpu count, df -h for a linux/unix free space list by device, for server tuning analysis.
– Wilson Hauck
Feb 28 at 1:16
1
Glad you are back together. Providing the information requested yesterday will allow meaningful suggestions to improve your system performance. Why are are you allowing hacker/cracker 1 million attempts to guess a password with the max_connect_errors at 1 million?
– Wilson Hauck
Feb 28 at 21:30
1
@G.G. With secondary review of your config, it looks like you accidentally have innodb_log_buffer_size much larger than innodb_log_file_size. The buffer should always be smaller than the log_file_size. Sorry I missed this earlier. Still willing to help with tuning, if SHOW GLOBAL STATUS; and SHOW GLOBAL VARIABLES; could be posted, even for DEV or PROD instance.
– Wilson Hauck
1 hour ago
|
show 5 more comments
what are your MySQL configuration parameters for wait_timeout, max_allowed_packet, tmp_table_size and max_heap_table_size?
– HelgeB
Feb 8 at 8:23
HelgeB I edited the post with my settings
– G. G.
Feb 8 at 8:28
1
Additional information request. Post on pastebin.com and share the links. RAM size of your MySQL Host server Text results of: B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME C) SHOW GLOBAL VARIABLES; D) SHOW FULL PROCESSLIST; E) complete MySQLTuner report AND Optional very helpful information, if available includes - htop OR top OR mytop for most active apps, ulimit -a for a linux/unix list of limits, iostat -xm 5 3 for IOPS by device and core/cpu count, df -h for a linux/unix free space list by device, for server tuning analysis.
– Wilson Hauck
Feb 28 at 1:16
1
Glad you are back together. Providing the information requested yesterday will allow meaningful suggestions to improve your system performance. Why are are you allowing hacker/cracker 1 million attempts to guess a password with the max_connect_errors at 1 million?
– Wilson Hauck
Feb 28 at 21:30
1
@G.G. With secondary review of your config, it looks like you accidentally have innodb_log_buffer_size much larger than innodb_log_file_size. The buffer should always be smaller than the log_file_size. Sorry I missed this earlier. Still willing to help with tuning, if SHOW GLOBAL STATUS; and SHOW GLOBAL VARIABLES; could be posted, even for DEV or PROD instance.
– Wilson Hauck
1 hour ago
what are your MySQL configuration parameters for wait_timeout, max_allowed_packet, tmp_table_size and max_heap_table_size?
– HelgeB
Feb 8 at 8:23
what are your MySQL configuration parameters for wait_timeout, max_allowed_packet, tmp_table_size and max_heap_table_size?
– HelgeB
Feb 8 at 8:23
HelgeB I edited the post with my settings
– G. G.
Feb 8 at 8:28
HelgeB I edited the post with my settings
– G. G.
Feb 8 at 8:28
1
1
Additional information request. Post on pastebin.com and share the links. RAM size of your MySQL Host server Text results of: B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME C) SHOW GLOBAL VARIABLES; D) SHOW FULL PROCESSLIST; E) complete MySQLTuner report AND Optional very helpful information, if available includes - htop OR top OR mytop for most active apps, ulimit -a for a linux/unix list of limits, iostat -xm 5 3 for IOPS by device and core/cpu count, df -h for a linux/unix free space list by device, for server tuning analysis.
– Wilson Hauck
Feb 28 at 1:16
Additional information request. Post on pastebin.com and share the links. RAM size of your MySQL Host server Text results of: B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME C) SHOW GLOBAL VARIABLES; D) SHOW FULL PROCESSLIST; E) complete MySQLTuner report AND Optional very helpful information, if available includes - htop OR top OR mytop for most active apps, ulimit -a for a linux/unix list of limits, iostat -xm 5 3 for IOPS by device and core/cpu count, df -h for a linux/unix free space list by device, for server tuning analysis.
– Wilson Hauck
Feb 28 at 1:16
1
1
Glad you are back together. Providing the information requested yesterday will allow meaningful suggestions to improve your system performance. Why are are you allowing hacker/cracker 1 million attempts to guess a password with the max_connect_errors at 1 million?
– Wilson Hauck
Feb 28 at 21:30
Glad you are back together. Providing the information requested yesterday will allow meaningful suggestions to improve your system performance. Why are are you allowing hacker/cracker 1 million attempts to guess a password with the max_connect_errors at 1 million?
– Wilson Hauck
Feb 28 at 21:30
1
1
@G.G. With secondary review of your config, it looks like you accidentally have innodb_log_buffer_size much larger than innodb_log_file_size. The buffer should always be smaller than the log_file_size. Sorry I missed this earlier. Still willing to help with tuning, if SHOW GLOBAL STATUS; and SHOW GLOBAL VARIABLES; could be posted, even for DEV or PROD instance.
– Wilson Hauck
1 hour ago
@G.G. With secondary review of your config, it looks like you accidentally have innodb_log_buffer_size much larger than innodb_log_file_size. The buffer should always be smaller than the log_file_size. Sorry I missed this earlier. Still willing to help with tuning, if SHOW GLOBAL STATUS; and SHOW GLOBAL VARIABLES; could be posted, even for DEV or PROD instance.
– Wilson Hauck
1 hour ago
|
show 5 more comments
1 Answer
1
active
oldest
votes
I managed to solved this.
Problem was not really on mysql.
Problem was because of wrong in the migration process. Although I got no errors there. This migration was the uber migration tool.
When did the process from start with magento native migration tool mysql and indexers are fine. Everything is working now
answered 25 mins ago
G. G.G. G.
607
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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
);
);
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%2fmagento.stackexchange.com%2fquestions%2f260939%2fmagento-2-mysql-server-has-gone-away%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I managed to solved this.
Problem was not really on mysql.
Problem was because of wrong in the migration process. Although I got no errors there. This migration was the uber migration tool.
When did the process from start with magento native migration tool mysql and indexers are fine. Everything is working now
answered 25 mins ago
G. G.G. G.
607
add a comment |
I managed to solved this.
Problem was not really on mysql.
Problem was because of wrong in the migration process. Although I got no errors there. This migration was the uber migration tool.
When did the process from start with magento native migration tool mysql and indexers are fine. Everything is working now
answered 25 mins ago
G. G.G. G.
607
add a comment |
I managed to solved this.
Problem was not really on mysql.
Problem was because of wrong in the migration process. Although I got no errors there. This migration was the uber migration tool.
When did the process from start with magento native migration tool mysql and indexers are fine. Everything is working now
answered 25 mins ago
G. G.G. G.
607
I managed to solved this.
Problem was not really on mysql.
Problem was because of wrong in the migration process. Although I got no errors there. This migration was the uber migration tool.
When did the process from start with magento native migration tool mysql and indexers are fine. Everything is working now
answered 25 mins ago
G. G.G. G.
607
answered 25 mins ago
G. G.G. G.
607
answered 25 mins ago
G. G.G. G.
607
answered 25 mins ago
G. G.G. G.
607
607
add a comment |
add a comment |
Thanks for contributing an answer to Magento Stack Exchange!
- 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%2fmagento.stackexchange.com%2fquestions%2f260939%2fmagento-2-mysql-server-has-gone-away%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
what are your MySQL configuration parameters for wait_timeout, max_allowed_packet, tmp_table_size and max_heap_table_size?
– HelgeB
Feb 8 at 8:23
HelgeB I edited the post with my settings
– G. G.
Feb 8 at 8:28
1
Additional information request. Post on pastebin.com and share the links. RAM size of your MySQL Host server Text results of: B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME C) SHOW GLOBAL VARIABLES; D) SHOW FULL PROCESSLIST; E) complete MySQLTuner report AND Optional very helpful information, if available includes - htop OR top OR mytop for most active apps, ulimit -a for a linux/unix list of limits, iostat -xm 5 3 for IOPS by device and core/cpu count, df -h for a linux/unix free space list by device, for server tuning analysis.
– Wilson Hauck
Feb 28 at 1:16
1
Glad you are back together. Providing the information requested yesterday will allow meaningful suggestions to improve your system performance. Why are are you allowing hacker/cracker 1 million attempts to guess a password with the max_connect_errors at 1 million?
– Wilson Hauck
Feb 28 at 21:30
1
@G.G. With secondary review of your config, it looks like you accidentally have innodb_log_buffer_size much larger than innodb_log_file_size. The buffer should always be smaller than the log_file_size. Sorry I missed this earlier. Still willing to help with tuning, if SHOW GLOBAL STATUS; and SHOW GLOBAL VARIABLES; could be posted, even for DEV or PROD instance.
– Wilson Hauck
1 hour ago