Sfrgttk

SQL Server 2017 crashes when backing up because filepath is wrong

Can a Hydra make multiple opportunity attacks at once?

Is there a way to pause a running process on Linux systems and resume later?

For the Circle of Spores druid's Halo of Spores feature, is your reaction used regardless of whether the other creature succeeds on the saving throw?

Wy do single power points exist?

Why don't you get burned by the wood benches in a sauna?

Multiplying elements of a list

Aliased pipeline using head and cut

Was the Soviet N1 really capable of sending 9.6 GB/s of telemetry?

Given the mapping a = 1, b = 2, ... z = 26, and an encoded message, count the number of ways it can be decoded

Are all power cords made equal?

Can I legally make a website about boycotting a certain company?

How can changes in personality/values of a person who turned into a vampire be explained?

What does "don't have a baby" imply or mean in this sentence?

What's the function of the word "ли" in the following contexts?

Did the characters in Moving Pictures not know about cameras like Twoflower's?

Now...where was I?

How can guns be countered by melee combat without raw-ability or exceptional explanations?

Identical projects by students at two different colleges: still plagiarism?

Why does this quiz question say that protons and electrons do not combine to form neutrons?

Manager has noticed coworker's excessive breaks. Should I warn him?

How does holding onto an active but un-used credit card affect your ability to get a loan?

Why would you use 2 alternate layout buttons instead of 1, when only one can be selected at once

How do you pronounce "Aeclepiadae"?

Restarting Mysql makes application fast

How to debug a db memory-leak causing mysql to go before it's own limits?Mysql Server Crashing Regularlymariadb / mysql wont change table_cache / table_open_cacheMySQL replication - ibdata1 hugeMySQL connection timeout on connection spikeError 1236 'Found old binary log without GTIDs' after master restartMysql server does not start if binary logging is disabledMysql config for my.cnf make sofware not responseMySQL root login email notificationMysqld process not showing all options on command line in CentOs 7

0

I have a Drupal 7 application running a large Mysql database. It's built on AWS instance (30GB RAM, 8 CPU). Below is the my.cnf copy.

Issue is that my application gets noticeably fast when I restart the mysql which makes me think that current configuration isn't optimal and once the caches get filled, they slow down the server speed.

Any experts who could point out the issue here?

[mysqld]

# moving datadir to /media/db ebs storage

datadir=/media/db/mysql

socket=/var/lib/mysql/mysql.sock

tmpdir=/dev/shm/

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0





local-infile=0

log-warnings=2



skip-external-locking

bind-address        = 127.0.0.1

expire_logs_days    = 1

max_binlog_size         = 100M

log-bin=bin.log

log-bin-index=bin-log.index

binlog_format=row

key_buffer_size                = 512M

max_allowed_packet  = 32M

thread_stack        = 292K

myisam_sort_buffer_size = 64M

thread_cache_size = 50

myisam-recover         = BACKUP

max_connections        = 100

max_user_connections = 150

table_cache            = 16384

table_open_cache       = 10240

table_definition_cache = 4096

thread_concurrency     = 8

join_buffer_size = 4M

query_cache_type = 1

query_cache_limit = 256K

query_cache_min_res_unit = 2k

query_cache_size = 200M

innodb_buffer_pool_size= 8G

tmp_table_size=64M

max_heap_table_size=64M

wait_timeout=50

interactive_timeout=50

connect_timeout=10

open-files-limit               = 65535

innodb_flush_log_at_trx_commit = 0

innodb_large_prefix=true

innodb_file_format=barracuda

innodb_file_per_table=true

table_open_cache = 5000

innodb_log_buffer_size= 32M

innodb_log_file_size = 512m

read_rnd_buffer_size = 8M

transaction-isolation = READ-COMMITTED

innodb_lock_wait_timeout = 25

innodb_write_io_threads = 16

innodb_sync_spin_loops = 200

innodb_spin_wait_delay = 24

innodb_read_io_threads = 16

innodb_flush_method = O_DIRECT

innodb_buffer_pool_instances = 8

innodb_autoinc_lock_mode = 2



[mysqldump]

max_allowed_packet  = 32M



[isamchk]

key_buffer  = 32M



[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

set-variable=long_query_time=1

long_query_time=10

slow_query_log_file =/var/log/mysql/mysql-slow.log

mysql

share

asked 7 mins ago

KamranKamran

1

New contributor

Kamran is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I have a Drupal 7 application running a large Mysql database. It's built on AWS instance (30GB RAM, 8 CPU). Below is the my.cnf copy.

Issue is that my application gets noticeably fast when I restart the mysql which makes me think that current configuration isn't optimal and once the caches get filled, they slow down the server speed.

Any experts who could point out the issue here?

[mysqld]

# moving datadir to /media/db ebs storage

datadir=/media/db/mysql

socket=/var/lib/mysql/mysql.sock

tmpdir=/dev/shm/

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0





local-infile=0

log-warnings=2



skip-external-locking

bind-address        = 127.0.0.1

expire_logs_days    = 1

max_binlog_size         = 100M

log-bin=bin.log

log-bin-index=bin-log.index

binlog_format=row

key_buffer_size                = 512M

max_allowed_packet  = 32M

thread_stack        = 292K

myisam_sort_buffer_size = 64M

thread_cache_size = 50

myisam-recover         = BACKUP

max_connections        = 100

max_user_connections = 150

table_cache            = 16384

table_open_cache       = 10240

table_definition_cache = 4096

thread_concurrency     = 8

join_buffer_size = 4M

query_cache_type = 1

query_cache_limit = 256K

query_cache_min_res_unit = 2k

query_cache_size = 200M

innodb_buffer_pool_size= 8G

tmp_table_size=64M

max_heap_table_size=64M

wait_timeout=50

interactive_timeout=50

connect_timeout=10

open-files-limit               = 65535

innodb_flush_log_at_trx_commit = 0

innodb_large_prefix=true

innodb_file_format=barracuda

innodb_file_per_table=true

table_open_cache = 5000

innodb_log_buffer_size= 32M

innodb_log_file_size = 512m

read_rnd_buffer_size = 8M

transaction-isolation = READ-COMMITTED

innodb_lock_wait_timeout = 25

innodb_write_io_threads = 16

innodb_sync_spin_loops = 200

innodb_spin_wait_delay = 24

innodb_read_io_threads = 16

innodb_flush_method = O_DIRECT

innodb_buffer_pool_instances = 8

innodb_autoinc_lock_mode = 2



[mysqldump]

max_allowed_packet  = 32M



[isamchk]

key_buffer  = 32M



[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

set-variable=long_query_time=1

long_query_time=10

slow_query_log_file =/var/log/mysql/mysql-slow.log

mysql

share

asked 7 mins ago

KamranKamran

1

New contributor

Kamran is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I have a Drupal 7 application running a large Mysql database. It's built on AWS instance (30GB RAM, 8 CPU). Below is the my.cnf copy.

Issue is that my application gets noticeably fast when I restart the mysql which makes me think that current configuration isn't optimal and once the caches get filled, they slow down the server speed.

Any experts who could point out the issue here?

[mysqld]

# moving datadir to /media/db ebs storage

datadir=/media/db/mysql

socket=/var/lib/mysql/mysql.sock

tmpdir=/dev/shm/

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0





local-infile=0

log-warnings=2



skip-external-locking

bind-address        = 127.0.0.1

expire_logs_days    = 1

max_binlog_size         = 100M

log-bin=bin.log

log-bin-index=bin-log.index

binlog_format=row

key_buffer_size                = 512M

max_allowed_packet  = 32M

thread_stack        = 292K

myisam_sort_buffer_size = 64M

thread_cache_size = 50

myisam-recover         = BACKUP

max_connections        = 100

max_user_connections = 150

table_cache            = 16384

table_open_cache       = 10240

table_definition_cache = 4096

thread_concurrency     = 8

join_buffer_size = 4M

query_cache_type = 1

query_cache_limit = 256K

query_cache_min_res_unit = 2k

query_cache_size = 200M

innodb_buffer_pool_size= 8G

tmp_table_size=64M

max_heap_table_size=64M

wait_timeout=50

interactive_timeout=50

connect_timeout=10

open-files-limit               = 65535

innodb_flush_log_at_trx_commit = 0

innodb_large_prefix=true

innodb_file_format=barracuda

innodb_file_per_table=true

table_open_cache = 5000

innodb_log_buffer_size= 32M

innodb_log_file_size = 512m

read_rnd_buffer_size = 8M

transaction-isolation = READ-COMMITTED

innodb_lock_wait_timeout = 25

innodb_write_io_threads = 16

innodb_sync_spin_loops = 200

innodb_spin_wait_delay = 24

innodb_read_io_threads = 16

innodb_flush_method = O_DIRECT

innodb_buffer_pool_instances = 8

innodb_autoinc_lock_mode = 2



[mysqldump]

max_allowed_packet  = 32M



[isamchk]

key_buffer  = 32M



[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

set-variable=long_query_time=1

long_query_time=10

slow_query_log_file =/var/log/mysql/mysql-slow.log

mysql

share

asked 7 mins ago

KamranKamran

1

New contributor

Kamran is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

[mysqld]

# moving datadir to /media/db ebs storage

datadir=/media/db/mysql

socket=/var/lib/mysql/mysql.sock

tmpdir=/dev/shm/

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0





local-infile=0

log-warnings=2



skip-external-locking

bind-address        = 127.0.0.1

expire_logs_days    = 1

max_binlog_size         = 100M

log-bin=bin.log

log-bin-index=bin-log.index

binlog_format=row

key_buffer_size                = 512M

max_allowed_packet  = 32M

thread_stack        = 292K

myisam_sort_buffer_size = 64M

thread_cache_size = 50

myisam-recover         = BACKUP

max_connections        = 100

max_user_connections = 150

table_cache            = 16384

table_open_cache       = 10240

table_definition_cache = 4096

thread_concurrency     = 8

join_buffer_size = 4M

query_cache_type = 1

query_cache_limit = 256K

query_cache_min_res_unit = 2k

query_cache_size = 200M

innodb_buffer_pool_size= 8G

tmp_table_size=64M

max_heap_table_size=64M

wait_timeout=50

interactive_timeout=50

connect_timeout=10

open-files-limit               = 65535

innodb_flush_log_at_trx_commit = 0

innodb_large_prefix=true

innodb_file_format=barracuda

innodb_file_per_table=true

table_open_cache = 5000

innodb_log_buffer_size= 32M

innodb_log_file_size = 512m

read_rnd_buffer_size = 8M

transaction-isolation = READ-COMMITTED

innodb_lock_wait_timeout = 25

innodb_write_io_threads = 16

innodb_sync_spin_loops = 200

innodb_spin_wait_delay = 24

innodb_read_io_threads = 16

innodb_flush_method = O_DIRECT

innodb_buffer_pool_instances = 8

innodb_autoinc_lock_mode = 2



[mysqldump]

max_allowed_packet  = 32M



[isamchk]

key_buffer  = 32M



[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

set-variable=long_query_time=1

long_query_time=10

slow_query_log_file =/var/log/mysql/mysql-slow.log

share

asked 7 mins ago

KamranKamran

1

New contributor

Kamran is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 7 mins ago

KamranKamran

1

New contributor

Kamran is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 7 mins ago

KamranKamran

1

New contributor

Kamran is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 7 mins ago

KamranKamran

1