Ygthkb

Taking an academic pseudonym?

Badly designed reimbursement form. What does that say about the company?

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

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?

How can a kingdom keep the secret of a missing monarch from the public?

Why is Shelob considered evil?

How bad is a Computer Science course that doesn't teach Design Patterns?

Aligning Systems of Equations

Are encryption algorithms with fixed-point free permutations inherently flawed?

What is formjacking?

Is it common to refer to someone as "Prof. Dr. [LastName]"?

Does this property characterize the odd primes?

Buying a "Used" Router

Why are `&array` and `array` pointing to the same address?

Why do we interpret the accelerated expansion of the universe as the proof for the existence of dark energy?

simplicial objects in a model category

What if you do not believe in the project benefits?

When distributing a Linux kernel driver as source code, what's the difference between Proprietary and GPL license?

How to typeset a small black square as a binary operator?

How can I make my enemies feel real and make combat more engaging?

Wy do single power points exist?

Why Doesn't It Completely Uninstall?

Log to console in a Lightning Web Component

Is it ethical to apply for a job on someone's behalf?

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 8 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 8 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 8 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 8 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 8 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 8 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 8 mins ago

KamranKamran

1